子分类帐与子模块代码关系

--应付发票       
select ai.INVOICE_NUM, xal.*
from AP_INVOICES_ALL          ai,
xla.XLA_TRANSACTION_ENTITIES xte,
xla.xla_events               xe,
xla.XLA_AE_HEADERS           xah,
xla.XLA_AE_LINES             xal
where ai.SET_OF_BOOKS_ID = 2022
and ai.SET_OF_BOOKS_ID = xte.LEDGER_ID
and ai.INVOICE_ID = nvl(xte.SOURCE_ID_INT_1,-99)
and ai.INVOICE_NUM = '&a'
and xte.ENTITY_ID = xe.ENTITY_ID
and xe.EVENT_ID = xah.EVENT_ID
and xal.AE_HEADER_ID = xah.AE_HEADER_ID
AND XTE.ENTITY_CODE LIKE 'AP_INVOICES'
;

--付款
select ac.CHECK_NUMBER, xal.*
from AP_INVOICES_ALL          ai,
AP_INVOICE_PAYMENTS_ALL aip,
AP_CHECKS_ALL ac,
xla.XLA_TRANSACTION_ENTITIES xte,
xla.xla_events               xe,
xla.XLA_AE_HEADERS           xah,
xla.XLA_AE_LINES             xal
where ai.SET_OF_BOOKS_ID =2022
and ai.SET_OF_BOOKS_ID = xte.LEDGER_ID
and ac.check_id = nvl(xte.SOURCE_ID_INT_1,-99)
and ai.INVOICE_NUM = '&a'
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
and xte.entity_code like  'AP_PAYMENTS'
;