[Home] [Help]
7253: ,NULL
7254: ,NULL
7255: ,cr.amount
7256: FROM ar_cash_receipts_all cr
7257: ,ar_misc_cash_distributions_all mcd
7258: ,ar_cash_receipt_history_all crh
7259: ,ar_distributions_all ard
7260: ,(SELECT entity_id,
7261: source_id_int_1
7825: -NVL(dist.from_acctd_amount_dr,0) -- AMOUNT
7826: ,DECODE(gt.event_type_code,'MISC_RECP_REVERSE' ,'Y','N') --reversal_code
7827: ,'N'
7828: FROM xla_events_gt gt,
7829: ar_misc_cash_distributions_all mcd,
7830: ar_distributions_all dist,
7831: gl_sets_of_books sob,
7832: ar_cash_receipts_all cr,
7833: --5201086
8000: -- RA_CUSTOMER_TRX_ALL Do not post
8001: -- AR_RATE_ADJUSTMENTS_ALL Do not post
8002: -- AR_CASH_RECEIPT_HISTORY_ALL A Those 4 A entities will post together
8003: -- AR_MC_CASH_RECEIPT_HIST A (Misc) Cash Receipt
8004: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A
8005: -- AR_MC_MISC_CASH_DISTS A
8006: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
8007: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
8008: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
8069: --
8070: -- CRH
8071: -- GL Posting entiting are
8072: -- AR_CASH_RECEIPT_HISTORY_ALL,
8073: -- AR_MISC_CASH_DISTRIBUTIONS_ALL,
8074: --
8075: UPDATE ar_cash_receipt_history_all
8076: SET posting_control_id = l_pst_id,
8077: gl_posted_date = l_date,
8094: 'MISC_RECP_UPDATE' ,
8095: 'MISC_RECP_RATE_ADJUST',
8096: 'MISC_RECP_REVERSE' ));
8097:
8098: UPDATE AR_MISC_CASH_DISTRIBUTIONS_ALL
8099: SET posting_control_id = l_pst_id,
8100: gl_posted_date = l_date,
8101: last_updated_by = fnd_global.user_id,
8102: last_update_date = sysdate,
8362:
8363: SELECT 'lock'
8364: BULK COLLECT INTO l_lock
8365: FROM xla_entity_events_v eve,
8366: ar_misc_cash_distributions_all mcd
8367: WHERE eve.request_id = p_report_request_id
8368: AND eve.application_id = p_application_id
8369: AND eve.entity_code = 'RECEIPTS'
8370: AND eve.event_id = mcd.event_id