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.AR_UPG_PSA_DIST_PKG dependencies on XLA_EVENTS

Line 1282: INDEX(ev XLA_EVENTS_U2)

1278:
1279: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1280: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1281: INDEX(ent xla_transaction_entities_N1)
1282: INDEX(ev XLA_EVENTS_U2)
1283: INDEX(hdr XLA_AE_HEADERS_N2)
1284: INDEX (ln, XLA_AE_LINES_U1)
1285: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */
1286: ln.AE_HEADER_ID

Line 1356: , xla_events ev

1352: FROM ra_customer_trx_all ct
1353: , ra_cust_trx_line_gl_dist_all ctlgd
1354: , xla_upgrade_dates gud
1355: , xla_transaction_entities_upg ent
1356: , xla_events ev
1357: , xla_ae_headers hdr
1358: , xla_ae_lines ln
1359: , xla_distribution_links lnk
1360: , psa_mf_trx_dist_all pd

Line 1394: INDEX(ev XLA_EVENTS_U2)

1390: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date
1391: UNION
1392: SELECT /*+ leading(pd,ct,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1393: INDEX(ent xla_transaction_entities_N1)
1394: INDEX(ev XLA_EVENTS_U2)
1395: INDEX(hdr XLA_AE_HEADERS_N2)
1396: INDEX (ln, XLA_AE_LINES_U1)
1397: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */
1398: ln.AE_HEADER_ID

Line 1468: , xla_events ev

1464: FROM ra_customer_trx_all ct
1465: , ra_cust_trx_line_gl_dist_all ctlgd
1466: , xla_upgrade_dates gud
1467: , xla_transaction_entities_upg ent
1468: , xla_events ev
1469: , xla_ae_headers hdr
1470: , xla_ae_lines ln
1471: , xla_distribution_links lnk
1472: ,(SELECT /*+ rowid(pdist) use_nl(dist) no_merge */ dist.customer_trx_id