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 1317: INDEX(ev XLA_EVENTS_U2)

1313:
1314: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1315: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1316: INDEX(ent xla_transaction_entities_N1)
1317: INDEX(ev XLA_EVENTS_U2)
1318: INDEX(hdr XLA_AE_HEADERS_N2)
1319: INDEX (ln, XLA_AE_LINES_U1)
1320: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */
1321: ln.AE_HEADER_ID

Line 1403: , xla_events ev

1399: FROM ra_customer_trx_all ct
1400: , ra_cust_trx_line_gl_dist_all ctlgd
1401: , xla_upgrade_dates gud
1402: , xla_transaction_entities_upg ent
1403: , xla_events ev
1404: , xla_ae_headers hdr
1405: , xla_ae_lines ln
1406: , xla_distribution_links lnk
1407: , psa_mf_trx_dist_all pd

Line 1441: INDEX(ev XLA_EVENTS_U2)

1437: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date
1438: UNION
1439: SELECT /*+ leading(pd,ct,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1440: INDEX(ent xla_transaction_entities_N1)
1441: INDEX(ev XLA_EVENTS_U2)
1442: INDEX(hdr XLA_AE_HEADERS_N2)
1443: INDEX (ln, XLA_AE_LINES_U1)
1444: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */
1445: ln.AE_HEADER_ID

Line 1527: , xla_events ev

1523: FROM ra_customer_trx_all ct
1524: , ra_cust_trx_line_gl_dist_all ctlgd
1525: , xla_upgrade_dates gud
1526: , xla_transaction_entities_upg ent
1527: , xla_events ev
1528: , xla_ae_headers hdr
1529: , xla_ae_lines ln
1530: , xla_distribution_links lnk
1531: ,(SELECT /*+ rowid(pdist) use_nl(dist) no_merge */ dist.customer_trx_id