APPS.AR_UPG_PSA_DIST_PKG dependencies on XLA_AE_LINES

Line 1284: INDEX (ln, XLA_AE_LINES_U1)

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

Line 1358: , xla_ae_lines ln

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

Line 1396: INDEX (ln, XLA_AE_LINES_U1)

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

Line 1470: , xla_ae_lines ln

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

Line 1512: --xla_ae_lines

1508: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date;
1509:
1510:
1511:
1512: --xla_ae_lines
1513:
1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1868: INSERT INTO xla_ae_lines

1864: END LOOP;
1865:
1866:
1867: FORALL i IN LAE_HEADER_ID.FIRST .. LAE_HEADER_ID.LAST
1868: INSERT INTO xla_ae_lines
1869: ( AE_HEADER_ID ,
1870: AE_LINE_NUM ,
1871: APPLICATION_ID ,
1872: CODE_COMBINATION_ID ,