[Home] [Help]
4601: ,NULL
4602: ,NULL
4603: ,NULL
4604: FROM ar_cash_receipts_all cr
4605: ,ar_misc_cash_distributions_all mcd
4606: ,ar_cash_receipt_history_all crh
4607: ,ar_distributions_all ard
4608: ,(SELECT entity_id,
4609: source_id_int_1
5173: -NVL(dist.from_acctd_amount_dr,0) -- AMOUNT
5174: ,DECODE(gt.event_type_code,'MISC_RECP_REVERSE' ,'Y','N') --reversal_code
5175: ,'N'
5176: FROM xla_events_gt gt,
5177: ar_misc_cash_distributions_all mcd,
5178: ar_distributions_all dist,
5179: gl_sets_of_books sob,
5180: ar_cash_receipts_all cr,
5181: --5201086
5343: -- RA_CUSTOMER_TRX_ALL Do not post
5344: -- AR_RATE_ADJUSTMENTS_ALL Do not post
5345: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
5346: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
5347: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A
5348: -- AR_MC_MISC_CASH_DISTS A
5349: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
5350: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
5351: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
5412: --
5413: -- CRH
5414: -- GL Posting entiting are
5415: -- AR_CASH_RECEIPT_HISTORY_ALL,
5416: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
5417: --
5418: UPDATE ar_cash_receipt_history_all
5419: SET posting_control_id = l_pst_id,
5420: gl_posted_date = l_date
5433: 'MISC_RECP_UPDATE' ,
5434: 'MISC_RECP_RATE_ADJUST',
5435: 'MISC_RECP_REVERSE' ));
5436:
5437: UPDATE AR_MISC_CASH_DISTRIBUTIONS_ALL
5438: SET posting_control_id = l_pst_id,
5439: gl_posted_date = l_date
5440: WHERE posting_control_id = -3
5441: AND (cash_receipt_id, event_id) IN
5686:
5687: SELECT 'lock'
5688: BULK COLLECT INTO l_lock
5689: FROM xla_entity_events_v eve,
5690: ar_misc_cash_distributions_all mcd
5691: WHERE eve.request_id = p_report_request_id
5692: AND eve.application_id = p_application_id
5693: AND eve.entity_code = 'RECEIPTS'
5694: AND eve.event_id = mcd.event_id