[Home] [Help]
1574: ,gt.event_type_code
1575: ,gt.event_class_code
1576: ,gt.entity_code
1577: ,'N' --MFAR_ADDITIONAL_ENTRY
1578: FROM ar_adjustments_all adj,
1579: gl_sets_of_books sob,
1580: xla_events_gt gt,
1581: ra_customer_trx_all trxf,
1582: ra_cust_trx_line_gl_dist_all ctlgd
2392: ,'N' --MFAR_ADDITIONAL_ENTRY
2393: --}
2394: FROM xla_events_gt gt,
2395: ar_distributions_all dist,
2396: ar_adjustments_all adj,
2397: gl_sets_of_books sob,
2398: ra_customer_trx_all trxt,
2399: ra_customer_trx_lines_all tlt,
2400: ra_cust_trx_line_gl_dist_all gldt,
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
5352: -- AR_MC_ADJUSTMENTS C (Adjustments)
5353: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together
5354: -- AR_MC_RECEIVABLE_APPS D (Applications)
5355: -- AR_TRANSACTION_HISTORY_ALL E Those 2 E entities will post together
5474:
5475: --
5476: -- ADJ
5477: -- GL Posting entiting are
5478: -- AR_ADJUSTMENTS_ALL,
5479: --
5480: UPDATE ar_adjustments_all
5481: SET posting_control_id = l_pst_id,
5482: gl_posted_date = l_date
5476: -- ADJ
5477: -- GL Posting entiting are
5478: -- AR_ADJUSTMENTS_ALL,
5479: --
5480: UPDATE ar_adjustments_all
5481: SET posting_control_id = l_pst_id,
5482: gl_posted_date = l_date
5483: WHERE posting_control_id = -3
5484: AND adjustment_id IN
5648: -- ADJ
5649: SELECT 'lock'
5650: BULK COLLECT INTO l_lock
5651: FROM xla_entity_events_v eve,
5652: ar_adjustments_all adj
5653: WHERE eve.request_id = p_report_request_id
5654: AND eve.application_id = p_application_id
5655: AND eve.entity_code = 'ADJUSTMENTS'
5656: AND eve.event_id = adj.event_id