APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_AE_LINES

Line 1319: INDEX (ln, XLA_AE_LINES_U1)

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
1323: , ln.APPLICATION_ID

Line 1405: , xla_ae_lines ln

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
1409: AND pd.ROWID <= l_end_rowid

Line 1443: INDEX (ln, XLA_AE_LINES_U1)

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
1447: , ln.APPLICATION_ID

Line 1529: , xla_ae_lines ln

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,
1533: psa_mf_trx_dist_all pdist,

Line 1543: xla_ae_lines xal

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
1547: AND xte.entity_code = 'TRANSACTIONS'

Line 1591: --xla_ae_lines

1587: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date;
1588:
1589:
1590:
1591: --xla_ae_lines
1592:
1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

Line 2004: INSERT INTO xla_ae_lines

2000: END LOOP;
2001:
2002:
2003: FORALL i IN LAE_HEADER_ID.FIRST .. LAE_HEADER_ID.LAST
2004: INSERT INTO xla_ae_lines
2005: ( AE_HEADER_ID ,
2006: AE_LINE_NUM ,
2007: APPLICATION_ID ,
2008: CODE_COMBINATION_ID ,