资源描述:
《SLA子分类帐与子模块的关联关系》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、ForinternaluseONLYEBSR12中SLA子分类帐与子模块的关联关系一、应付帐款selectai.INVOICE_NUM,xal.*fromAP_INVOICES_ALLai,XLA_TRANSACTION_ENTITIESxte,xla_eventsxe,XLA_AE_HEADERSxah,XLA_AE_LINESxalwhereai.SET_OF_BOOKS_ID=2027andai.SET_OF_BOOKS_ID=xte.LEDGER_IDandai.INVOICE_ID=xte.S
2、OURCE_ID_INT_1andai.INVOICE_NUM='4600060381@2012_1500000511_2'andxte.ENTITY_ID=xe.ENTITY_IDandxe.EVENT_ID=xah.EVENT_IDandxal.AE_HEADER_ID=xah.AE_HEADER_IDselectac.CHECK_NUMBER,xal.*fromAP_INVOICES_ALLai,~1~ForinternaluseONLYAP_INVOICE_PAYMENTS_ALLaip,AP_
3、CHECKS_ALLac,XLA_TRANSACTION_ENTITIESxte,xla_eventsxe,XLA_AE_HEADERSxah,XLA_AE_LINESxalwhereai.SET_OF_BOOKS_ID=’&sob_id’andai.SET_OF_BOOKS_ID=xte.LEDGER_IDandac.check_id=xte.SOURCE_ID_INT_1andai.INVOICE_NUM='&INVOICE_NUM'andxte.ENTITY_ID=xe.ENTITY_IDandx
4、e.EVENT_ID=xah.EVENT_IDandxal.AE_HEADER_ID=xah.AE_HEADER_IDandai.INVOICE_ID=aip.INVOICE_IDandaip.CHECK_ID=ac.CHECK_ID二、应收帐款selectrct.TRX_NUMBER,xah.*fromRA_CUSTOMER_TRX_ALLrct,XLA_TRANSACTION_ENTITIESxte,xla_eventsxe,XLA_AE_HEADERSxah,xla_ae_linesxalwher
5、erct.SET_OF_BOOKS_ID=2027andrct.CUSTOMER_TRX_ID=22206andrct.SET_OF_BOOKS_ID=xte.LEDGER_IDandxte.SOURCE_ID_INT_1=rct.CUSTOMER_TRX_IDandxte.ENTITY_ID=xe.ENTITY_IDandxe.EVENT_ID=xah.EVENT_IDandxah.AE_HEADER_ID=xal.AE_HEADER_ID--andxah.PERIOD_NAME='&period_n
6、ame'~2~ForinternaluseONLY正常收款selectarc.RECEIPT_NUMBER,xal.*fromAR_CASH_RECEIPTS_ALLarc,XLA_TRANSACTION_ENTITIESxte,xla_eventsxe,XLA_AE_HEADERSxah,xla_ae_linesxalwherearc.SET_OF_BOOKS_ID=xte.LEDGER_IDandxte.SOURCE_ID_INT_1=arc.CASH_RECEIPT_IDandxte.ENTITY
7、_ID=xe.ENTITY_IDandxe.EVENT_ID=xah.EVENT_IDandxah.AE_HEADER_ID=xal.AE_HEADER_IDandarc.CASH_RECEIPT_ID=1348516杂项收款selectarc.RECEIPT_NUMBER,xal.*fromAR_CASH_RECEIPTS_ALLarc,AR_MISC_CASH_DISTRIBUTIONS_ALLamc,XLA_TRANSACTION_ENTITIESxte,xla_eventsxe,XLA_AE_H
8、EADERSxah,xla_ae_linesxalwherearc.SET_OF_BOOKS_ID=xte.LEDGER_IDandxte.SOURCE_ID_INT_1=arc.CASH_RECEIPT_IDandarc.CASH_RECEIPT_ID=amc.CASH_RECEIPT_IDandxte.ENTITY_ID=xe.ENTITY_IDandxe.EVENT_ID=xah.EVENT_IDandxah.AE_HEADER_ID