APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_AE_HEADERS

Line 1318: INDEX(hdr XLA_AE_HEADERS_N2)

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

Line 1404: , xla_ae_headers hdr

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

Line 1442: INDEX(hdr XLA_AE_HEADERS_N2)

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

Line 1528: , xla_ae_headers hdr

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

Line 1542: xla_ae_headers xah,

1538: AND pdist.ROWID <= l_end_rowid
1539: AND NOT EXISTS
1540: ( SELECT /*+ordered */ 'x'
1541: FROM xla_transaction_entities_upg xte,
1542: xla_ae_headers xah,
1543: xla_ae_lines xal
1544: WHERE nvl(xte.source_id_int_1,-99) = dist.customer_trx_id
1545: AND xte.ledger_id = dist.set_of_books_id
1546: AND xte.application_id = 222