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_AE_HEADERS

Line 1283: INDEX(hdr XLA_AE_HEADERS_N2)

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
1287: , ln.AE_LINE_NUM

Line 1357: , xla_ae_headers hdr

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
1361: WHERE pd.ROWID >= l_start_rowid

Line 1395: INDEX(hdr XLA_AE_HEADERS_N2)

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
1399: , ln.AE_LINE_NUM

Line 1469: , xla_ae_headers hdr

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
1473: FROM ra_cust_trx_line_gl_dist_all dist,