DBA Data[Home] [Help]

APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on XLA_ENTITY_EVENTS_V

Line 5638: FROM xla_entity_events_v eve,

5634:
5635: -- CTLGD
5636: SELECT 'lock'
5637: BULK COLLECT INTO l_lock
5638: FROM xla_entity_events_v eve,
5639: ra_cust_trx_line_gl_dist_all ctlgd
5640: WHERE eve.request_id = p_report_request_id
5641: AND eve.application_id = p_application_id
5642: AND eve.entity_code = 'TRANSACTIONS'

Line 5651: FROM xla_entity_events_v eve,

5647:
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'

Line 5664: FROM xla_entity_events_v eve,

5660:
5661: -- APP
5662: SELECT 'lock'
5663: BULK COLLECT INTO l_lock
5664: FROM xla_entity_events_v eve,
5665: ar_receivable_applications_all app
5666: WHERE eve.request_id = p_report_request_id
5667: AND eve.application_id = p_application_id
5668: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')

Line 5678: FROM xla_entity_events_v eve,

5674:
5675: -- CRH MCD
5676: SELECT 'lock'
5677: BULK COLLECT INTO l_lock
5678: FROM xla_entity_events_v eve,
5679: ar_cash_receipt_history_all crh
5680: WHERE eve.request_id = p_report_request_id
5681: AND eve.application_id = p_application_id
5682: AND eve.entity_code = 'RECEIPTS'

Line 5689: FROM xla_entity_events_v eve,

5685: FOR UPDATE OF crh.cash_receipt_history_id;
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'

Line 5701: FROM xla_entity_events_v eve,

5697:
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'