EBS R12中SLA子分类帐与子模块的关联关系.docx

EBS R12中SLA子分类帐与子模块的关联关系一、应付帐款--发票分录select ai.INVOICE_NUM, xal.* from AP_INVOICES_ALL ai, XLA_TRANSACTION_ENTITIES xte, xla_events xe, XLA_AE_HEADERS xah, XLA_AE_LINES xal where ai.SET_OF_BOOKS_ID = 2027 and ai.SET_OF_BOOKS_ID = xte.LEDGER_ID and ai.INVOICE_ID = xte.SOURCE_ID_INT_1 and ai.INVOICE_NUM = 4600060381@2012_1500000511_2 and xte.ENTITY_ID = xe.ENTITY_ID and xe.EVENT_ID = xah.EVENT_ID and xal.AE_HEADER_ID = xah.AE_HEADER_ID?--付款分录select ac.CHECK_NUMBER, xal.* from AP_INVOICES_ALL ai, AP_INVOICE_PAYMENTS_ALL aip, AP_CHECKS_ALL ac, XLA_TRANSACTION_ENTITIES xte, xla_events xe, XLA_AE_HEADERS xah, XLA_AE_LINES xal where ai.SET_OF_BOOKS_ID =’sob_id’ and ai.SET_OF_BOOKS_ID = xte.LEDGER_ID and ac.check_id = xte.SOURCE_ID_INT_1 and ai.INVOICE_NUM = INVOICE_NUM and xte.ENTITY_ID = xe.ENTITY_ID and xe.EVENT_ID = xah.EVENT_ID and xal.AE_HEADER_ID = xah.AE_HEADER_ID and ai.INVOICE_ID=aip.INVOICE_ID and aip.CHECK_ID=ac.CHECK_ID?二、应收帐款????三、资产FA_DEPRN_DETAIL_H 折旧回滚表FA_DEPRN_EVENTS 折旧事件表注：R12回滚是基于资产卡片，R11I回滚是基于资产帐簿?--资产折旧select fa.TAG_NUMBER, fdp.PERIOD_NAME, xal.* from FA_ADDITIONS_B fa, FA_DEPRN_DETAIL fdd, FA_DEPRN_PERIODS fdp, XLA_TRANSACTION_ENTITIES xte, xla_events xe, XLA_AE_HEADERS xah, XLA_AE_LINES xal where fa.TAG_NUMBER = TAG_NUMBER and fa.ASSET_ID = fdd.ASSET_ID and xte.SOURCE_ID_INT_1 = fdd.ASSET_ID and xte.SOURCE_ID_CHAR_1 = fdd.BOOK_TYPE_CODE and xte.SOURCE_ID_INT_2 = fdd.PERIOD_COUNTER and xte.SOURCE_ID_INT_3 = fdd.DEPRN_RUN_ID and fdp.BOOK_TYPE_CODE = fdd.BOOK_TYPE_CODE and fdp.PERIOD_COUNTER = fdd.PERIOD_COUNTER and xte.ENTITY_ID = xe.ENTITY_ID and xah.EVENT_ID = xe.EVENT_IDand xah.AE_HEADER_ID = xal.AE_HEADER_ID??--资产事务select xe.EVENT_TYPE_CODE,xah.EVENT_TYPE_CODE,xal.* from FA_TRANSACTION_HEADERS fth, XLA_TRANSACTION_ENTITIES xte, xla_events xe, XLA_AE_HEADERS xah, XLA_AE_LIN