APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_TRANSACTION_HISTORY_ALL

Line 4970: ar_transaction_history_all th,

4966: --BUG#4645389
4967: ,tl.tax_line_id --tax_line_id
4968: ,'N'
4969: FROM xla_events_gt gt,
4970: ar_transaction_history_all th,
4971: ra_customer_trx_all trx,
4972: ra_customer_trx_lines_all tl,
4973: ra_cust_trx_line_gl_dist_all gld,
4974: oe_system_parameters_all osp,

Line 5355: -- AR_TRANSACTION_HISTORY_ALL E Those 2 E entities will post together

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
5356: -- AR_MC_TRANSACTION_HISTORY E (Bill Receivables)
5357: -- Question are there any side effect
5358: -- from BR on TRX ?
5359: ------------------

Line 5514: -- AR_TRANSACTION_HISTORY_ALL,

5510:
5511: --
5512: -- TH
5513: -- GL Posting entiting are
5514: -- AR_TRANSACTION_HISTORY_ALL,
5515: --
5516: UPDATE AR_TRANSACTION_HISTORY_ALL
5517: SET posting_control_id = l_pst_id,
5518: gl_posted_date = l_date

Line 5516: UPDATE AR_TRANSACTION_HISTORY_ALL

5512: -- TH
5513: -- GL Posting entiting are
5514: -- AR_TRANSACTION_HISTORY_ALL,
5515: --
5516: UPDATE AR_TRANSACTION_HISTORY_ALL
5517: SET posting_control_id = l_pst_id,
5518: gl_posted_date = l_date
5519: WHERE posting_control_id = -3
5520: AND postable_flag='Y'

Line 5702: ar_transaction_history_all trh

5698: --TRH
5699: SELECT 'lock'
5700: BULK COLLECT INTO l_lock
5701: FROM xla_entity_events_v eve,
5702: ar_transaction_history_all trh
5703: WHERE eve.request_id = p_report_request_id
5704: AND eve.application_id = p_application_id
5705: AND eve.entity_code = 'BILLS_RECEIVABLE'
5706: AND eve.event_id = trh.event_id