DBA Data[Home] [Help]

APPS.ARP_XLA_UPGRADE dependencies on XLA_AE_LINES

Line 482: INTO XLA_AE_LINES

478: IF NVL(l_entity_type,'L') = 'L' THEN
479:
480: INSERT ALL
481: WHEN 1 = 1 THEN
482: INTO XLA_AE_LINES
483: (upg_batch_id,
484: ae_header_id,
485: ae_line_num,
486: application_id,

Line 1232: INTO XLA_AE_LINES

1228: IF NVL(l_entity_type,'L') = 'L' THEN
1229:
1230: INSERT ALL
1231: WHEN 1 = 1 THEN
1232: INTO XLA_AE_LINES
1233: (upg_batch_id,
1234: ae_header_id,
1235: ae_line_num,
1236: application_id,

Line 2100: INTO XLA_AE_LINES

2096: IF NVL(l_entity_type,'L') = 'L' THEN
2097:
2098: INSERT ALL
2099: WHEN 1 = 1 THEN
2100: INTO XLA_AE_LINES
2101: (upg_batch_id,
2102: ae_header_id,
2103: ae_line_num,
2104: application_id,

Line 2859: INTO XLA_AE_LINES

2855: IF NVL(l_entity_type,'L') = 'L' THEN
2856:
2857: INSERT ALL
2858: WHEN 1 = 1 THEN
2859: INTO XLA_AE_LINES
2860: (upg_batch_id,
2861: ae_header_id,
2862: ae_line_num,
2863: application_id,

Line 3195: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)

3191: gl_sl_link_table) =
3192: (SELECT /*+
3193: NO_EXPAND leading(ghd,periods,gld,gps,lnk,ln)
3194: use_nl(ghd,gld,gps)
3195: USE_NL_WITH_INDEX(ln XLA_AE_LINES_U1)
3196: USE_NL_WITH_INDEX(lnk XLA_DISTRIBUTION_LINKS_N1)
3197: */
3198: LN.GL_SL_LINK_ID, 'XLAJEL'
3199: FROM GL_JE_HEADERS GHD,

Line 3203: XLA_AE_LINES LN

3199: FROM GL_JE_HEADERS GHD,
3200: GL_JE_LINES GLD,
3201: XLA_UPGRADE_DATES GPS,
3202: XLA_DISTRIBUTION_LINKS LNK,
3203: XLA_AE_LINES LN
3204: WHERE EXISTS
3205: (select /*+ PUSH_SUBQ */ null
3206: from ar120gir_periods periods
3207: where periods.period_name = GHD.period_name