eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_XLA_EVENTS dependencies on XLA_TRANSACTION_ENTITIES_UPG

Line 208: xla_transaction_entities_upg xt

204: ae.event_date ,
205: ae.event_status_code,
206: ae.event_type_code
207: from xla_events ae,
208: xla_transaction_entities_upg xt
209: where xt.source_id_int_1 = :trx_id
210: and xt.entity_id = ae.entity_id
211: and nvl(ae.event_date,
212: to_date(''01-01-1900'',''DD-MM-YYYY'')) = :dist_gl_date

Line 738: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

734: ev1.event_id ';
735:
736: l_from_clause :=
737: ' FROM xla_events' || ' ev1, ' || CRLF ||
738: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
739: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
740:
741: --{BUG#5131345 suggested by perf team
742:

Line 879: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

875: ev1.event_id ';
876:
877: l_from_clause :=
878: ' FROM xla_events' || ' ev1, ' || CRLF ||
879: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
880: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;
881:
882: l_where_clause :=
883: ' WHERE adj.event_id IS NULL

Line 1098: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

1094: ev1.event_id ';
1095:
1096: l_from_clause :=
1097: ' FROM xla_events' || ' ev1, ' || CRLF ||
1098: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1099: ' ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1100: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1101:
1102: l_where_clause :=

Line 1292: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

1288: ev1.event_id ';
1289:
1290: l_from_clause :=
1291: ' FROM xla_events' || ' ev1, ' || CRLF ||
1292: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1293: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||
1294: ' ar_misc_cash_distributions' || l_all_clause || ' mcd ' || CRLF ;
1295:
1296: l_where_clause :=

Line 1525: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

1521: log('l_select_clause ' || l_select_clause);
1522:
1523: l_from_clause :=
1524: ' FROM xla_events' || ' ev1, ' || CRLF ||
1525: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1526: ' ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||
1527: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1528:
1529: log('l_from_clause ' || l_from_clause);

Line 1676: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

1672: ev1.event_id ';
1673:
1674: l_from_clause :=
1675: ' FROM xla_events' || ' ev1, ' || CRLF ||
1676: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1677: ' ar_receivable_applications' || l_all_clause || ' app ' || CRLF ;
1678:
1679:
1680: --Use xla_transaction_entity_n1

Line 1884: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

1880: --use xla_transaction_entity_n1
1881:
1882: l_from_clause :=
1883: ' FROM xla_events' || ' ev1, ' || CRLF ||
1884: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1885: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1886: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1887: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1888:

Line 2491: xla_transaction_entities_upg xt,

2487: where ae2.application_id = 222
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'

Line 2525: xla_transaction_entities_upg xt,

2521: where ae2.application_id = 222
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'

Line 2558: xla_transaction_entities_upg xt,

2554: where ae2.application_id = 222
2555: and ae2.event_id IN
2556: ( select MAX( ae.event_id )
2557: from xla_events ae,
2558: xla_transaction_entities_upg xt,
2559: ar_Cash_receipts_all cr
2560: where cr.cash_receipt_id = ev_rec.trx_id(i)
2561: and NVL(xt.source_id_int_1,-99) = cr.cash_receipt_id
2562: and xt.entity_code = 'RECEIPTS'

Line 2590: xla_transaction_entities_upg xt,

2586: where ae2.application_id = 222
2587: and ae2.event_id IN
2588: ( select MAX( ae.event_id )
2589: from xla_events ae,
2590: xla_transaction_entities_upg xt,
2591: ar_adjustments_all adj
2592: where adj.adjustment_id = ev_rec.trx_id(i)
2593: and NVL(xt.source_id_int_1,-99) = adj.adjustment_id
2594: and xt.entity_code = 'ADJUSTMENTS'

Line 3270: FROM xla_transaction_entities_upg a,

3266: log(' Checking if Trxn number has changed by Copy Document Sequence Feature');
3267:
3268: BEGIN
3269: SELECT a.transaction_number INTO trxn_number
3270: FROM xla_transaction_entities_upg a,
3271: xla_events b
3272: WHERE NVL(a.source_id_int_1,-99) = bld_ev_ent(m).source_id_int_1
3273: AND b.event_id = bld_ev_ent(m).event_id
3274: AND a.entity_id = b.entity_id

Line 4296: xla_transaction_entities_upg xte,

4292: /*7229913 */
4293: CURSOR c_ct_rules is
4294: select xe.event_id event_id from
4295: ra_customer_trx ct,
4296: xla_transaction_entities_upg xte,
4297: xla_events xe
4298: where ct.customer_trx_id = p_document_id
4299: and ct.invoicing_rule_id in (-2,-3)
4300: and ct.set_of_books_id = xte.ledger_id