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 1291: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||

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

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

1516: log('l_select_clause ' || l_select_clause);
1517:
1518: l_from_clause :=
1519: ' FROM xla_events' || ' ev1, ' || CRLF ||
1520: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1521: ' ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||
1522: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1523:
1524: log('l_from_clause ' || l_from_clause);

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

1664: ev1.event_id ';
1665:
1666: l_from_clause :=
1667: ' FROM xla_events' || ' ev1, ' || CRLF ||
1668: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1669: ' ar_receivable_applications' || l_all_clause || ' app ' || CRLF ;
1670:
1671:
1672: --Use xla_transaction_entity_n1

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

1871: --use xla_transaction_entity_n1
1872:
1873: l_from_clause :=
1874: ' FROM xla_events' || ' ev1, ' || CRLF ||
1875: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1876: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1877: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1878: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1879:

Line 2480: xla_transaction_entities_upg xt,

2476: where ae2.application_id = 222
2477: and ae2.event_id IN
2478: ( select MAX( ae.event_id )
2479: from xla_events ae,
2480: xla_transaction_entities_upg xt,
2481: ra_customer_trx_all trx
2482: where trx.customer_trx_id = ev_rec.trx_id(i)
2483: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2484: and xt.entity_code = 'TRANSACTIONS'

Line 2514: xla_transaction_entities_upg xt,

2510: where ae2.application_id = 222
2511: and ae2.event_id IN
2512: ( select MAX( ae.event_id )
2513: from xla_events ae,
2514: xla_transaction_entities_upg xt,
2515: ra_customer_trx_all trx
2516: where trx.customer_trx_id = ev_rec.trx_id(i)
2517: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2518: and xt.entity_code = 'BILLS_RECEIVABLE'

Line 2547: xla_transaction_entities_upg xt,

2543: where ae2.application_id = 222
2544: and ae2.event_id IN
2545: ( select MAX( ae.event_id )
2546: from xla_events ae,
2547: xla_transaction_entities_upg xt,
2548: ar_Cash_receipts_all cr
2549: where cr.cash_receipt_id = ev_rec.trx_id(i)
2550: and NVL(xt.source_id_int_1,-99) = cr.cash_receipt_id
2551: and xt.entity_code = 'RECEIPTS'

Line 2579: xla_transaction_entities_upg xt,

2575: where ae2.application_id = 222
2576: and ae2.event_id IN
2577: ( select MAX( ae.event_id )
2578: from xla_events ae,
2579: xla_transaction_entities_upg xt,
2580: ar_adjustments_all adj
2581: where adj.adjustment_id = ev_rec.trx_id(i)
2582: and NVL(xt.source_id_int_1,-99) = adj.adjustment_id
2583: and xt.entity_code = 'ADJUSTMENTS'

Line 3258: FROM xla_transaction_entities_upg a,

3254: log(' Checking if Trxn number has changed by Copy Document Sequence Feature');
3255:
3256: BEGIN
3257: SELECT a.transaction_number INTO trxn_number
3258: FROM xla_transaction_entities_upg a,
3259: xla_events b
3260: WHERE NVL(a.source_id_int_1,-99) = bld_ev_ent(m).source_id_int_1
3261: AND b.event_id = bld_ev_ent(m).event_id
3262: AND a.entity_id = b.entity_id

Line 4284: xla_transaction_entities_upg xte,

4280: /*7229913 */
4281: CURSOR c_ct_rules is
4282: select xe.event_id event_id from
4283: ra_customer_trx ct,
4284: xla_transaction_entities_upg xte,
4285: xla_events xe
4286: where ct.customer_trx_id = p_document_id
4287: and ct.invoicing_rule_id in (-2,-3)
4288: and ct.set_of_books_id = xte.ledger_id