APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 1320: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */

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
1324: , ln.CODE_COMBINATION_ID

Line 1406: , xla_distribution_links lnk

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
1410: AND ct.customer_trx_id = ctlgd.customer_trx_id

Line 1444: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */

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
1448: , ln.CODE_COMBINATION_ID

Line 1530: , xla_distribution_links lnk

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,
1534: xla_upgrade_dates xud

Line 1630: --xla_distribution_links

1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;
1628:
1629:
1630: --xla_distribution_links
1631:
1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

Line 1808: --xla_distribution_links

1804: laccounting_date := empty_date_list;
1805: lledger_id := empty_number_list;
1806:
1807:
1808: --xla_distribution_links
1809:
1810: DAPPLICATION_ID := empty_number_list;
1811: DEVENT_ID := empty_number_list;
1812: DAE_HEADER_ID := empty_number_list;

Line 2085: INSERT INTO XLA_DISTRIBUTION_LINKS

2081: laccounting_date(i),
2082: lledger_id(i));
2083:
2084: FORALL i IN LAE_HEADER_ID.FIRST .. LAE_HEADER_ID.LAST
2085: INSERT INTO XLA_DISTRIBUTION_LINKS
2086: (APPLICATION_ID,
2087: EVENT_ID,
2088: AE_HEADER_ID,
2089: AE_LINE_NUM,