APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 1285: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */

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
1288: , ln.APPLICATION_ID
1289: , ln.CODE_COMBINATION_ID

Line 1359: , xla_distribution_links lnk

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
1362: AND pd.ROWID <= l_end_rowid
1363: AND ct.customer_trx_id = ctlgd.customer_trx_id

Line 1397: INDEX (lnk, XLA_DISTRIBUTION_LINKS_N1) */

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
1400: , ln.APPLICATION_ID
1401: , ln.CODE_COMBINATION_ID

Line 1471: , xla_distribution_links lnk

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,
1474: psa_mf_trx_dist_all pdist
1475: WHERE pdist.cust_trx_line_gl_dist_id = dist.cust_trx_line_gl_dist_id

Line 1551: --xla_distribution_links

1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;
1549:
1550:
1551: --xla_distribution_links
1552:
1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

Line 1728: --xla_distribution_links

1724: laccounting_date := empty_date_list;
1725: lledger_id := empty_number_list;
1726:
1727:
1728: --xla_distribution_links
1729:
1730: DAPPLICATION_ID := empty_number_list;
1731: DEVENT_ID := empty_number_list;
1732: DAE_HEADER_ID := empty_number_list;