EBS R12中SLA子分类帐与子模块的关联关系
一、应付帐款
--发票分录
selectai.INVOICE_NUM, xal.*
fromAP_INVOICES_ALLai,
XLA_TRANSACTION_ENTITIES xte,
xla_eventsxe,
XLA_AE_HEADERSxah,
XLA_AE_LINESxal
whereai.SET_OF_BOOKS_ID =2027
andai.SET_OF_BOOKS_ID = xte.LEDGER_ID
andai.INVOICE_ID = xte.SOURCE_ID_INT_1
andai.INVOICE_NUM ='4600060381@2012_1500000511_2'
andxte.ENTITY_ID = xe.ENTITY_ID
andxe.EVENT_ID = xah.EVENT_ID
andxal.AE_HEADER_ID = xah.AE_HEADER_ID
--付款分录
selectac.CHECK_NUMBER, xal.*
fromAP_INVOICES_ALLai,
AP_INVOICE_PAYMENTS_ALL aip,
AP_CHECKS_ALL ac,
XLA_TRANSACTION_ENTITIES xte,
xla_eventsxe,
XLA_AE_HEADERSxah,
XLA_AE_LINESxal
whereai.SET_OF_BOOKS_ID =’&sob_id’
andai.SET_OF_BOOKS_ID = xte.LEDG