DBA Data[Home] [Help]

APPS.ARP_XLA_EVENTS dependencies on RA_CUSTOMER_TRX_ALL

Line 2492: ra_customer_trx_all trx

2488: and ae2.event_id IN
2489: ( select MAX( ae.event_id )
2490: from xla_events ae,
2491: xla_transaction_entities_upg xt,
2492: ra_customer_trx_all trx
2493: where trx.customer_trx_id = ev_rec.trx_id(i)
2494: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2495: and xt.entity_code = 'TRANSACTIONS'
2496: and xt.ledger_id = trx.set_of_books_id

Line 2526: ra_customer_trx_all trx

2522: and ae2.event_id IN
2523: ( select MAX( ae.event_id )
2524: from xla_events ae,
2525: xla_transaction_entities_upg xt,
2526: ra_customer_trx_all trx
2527: where trx.customer_trx_id = ev_rec.trx_id(i)
2528: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2529: and xt.entity_code = 'BILLS_RECEIVABLE'
2530: and xt.ledger_id = trx.set_of_books_id

Line 4560: FROM ra_customer_trx_all

4556: AND l_ar_xla_period_close_evt_tab(i).ENTITY_CODE IN ('TRANSACTIONS', 'BILLS_RECEIVABLE') THEN
4557: BEGIN
4558: SELECT
4559: count(*) into l_trx_cnt
4560: FROM ra_customer_trx_all
4561: WHERE customer_trx_id = l_ar_xla_period_close_evt_tab(i).SOURCE_ID_INT_1 /* The trx id stored in XLA entities table */
4562: AND org_id = l_ar_xla_period_close_evt_tab(i).SECURITY_ID_INT_1 /* The Org_ID stored in XLA entities table */
4563: AND complete_flag = 'N'; /* Incomplete Transaction */
4564: