APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 1420: FROM xla_mpa_jlt_assgns w

1416: , w.accounting_line_type_code
1417: , w.accounting_line_code
1418: , w.mpa_accounting_line_type_code
1419: , w.mpa_accounting_line_code
1420: FROM xla_mpa_jlt_assgns w
1421: , xla_mpa_jlt_assgns s
1422: WHERE s.application_id = g_application_id
1423: AND s.amb_context_code = g_staging_context_code
1424: AND s.event_class_code = w.event_class_code

Line 1421: , xla_mpa_jlt_assgns s

1417: , w.accounting_line_code
1418: , w.mpa_accounting_line_type_code
1419: , w.mpa_accounting_line_code
1420: FROM xla_mpa_jlt_assgns w
1421: , xla_mpa_jlt_assgns s
1422: WHERE s.application_id = g_application_id
1423: AND s.amb_context_code = g_staging_context_code
1424: AND s.event_class_code = w.event_class_code
1425: AND s.event_type_code = w.event_type_code

Line 1617: FROM xla_mpa_jlt_assgns w

1613: , w.accounting_line_type_code
1614: , w.accounting_line_code
1615: , w.mpa_accounting_line_type_code
1616: , w.mpa_accounting_line_code
1617: FROM xla_mpa_jlt_assgns w
1618: LEFT OUTER JOIN xla_mpa_jlt_assgns s
1619: ON s.amb_context_code = g_staging_context_code
1620: AND s.application_id = g_application_id
1621: AND s.event_class_code = w.event_class_code

Line 1618: LEFT OUTER JOIN xla_mpa_jlt_assgns s

1614: , w.accounting_line_code
1615: , w.mpa_accounting_line_type_code
1616: , w.mpa_accounting_line_code
1617: FROM xla_mpa_jlt_assgns w
1618: LEFT OUTER JOIN xla_mpa_jlt_assgns s
1619: ON s.amb_context_code = g_staging_context_code
1620: AND s.application_id = g_application_id
1621: AND s.event_class_code = w.event_class_code
1622: AND s.event_type_code = w.event_type_code

Line 1871: , xla_mpa_jlt_assgns j

1867: , NULL
1868: , l.accounting_coa_id
1869: FROM xla_mpa_jlt_adr_assgns w
1870: , xla_mpa_jlt_adr_assgns s
1871: , xla_mpa_jlt_assgns j
1872: , xla_line_definitions_b l
1873: WHERE s.application_id = g_application_id
1874: AND s.amb_context_code = g_staging_context_code
1875: AND s.event_class_code = w.event_class_code

Line 2051: JOIN xla_mpa_jlt_assgns j

2047: AND l.event_class_code = w.event_class_code
2048: AND l.event_type_code = w.event_type_code
2049: AND l.line_definition_owner_code = w.line_definition_owner_code
2050: AND l.line_definition_code = w.line_definition_code
2051: JOIN xla_mpa_jlt_assgns j
2052: ON j.amb_context_code = g_amb_context_code
2053: AND j.application_id = g_application_id
2054: AND j.event_class_code = w.event_class_code
2055: AND j.event_type_code = w.event_type_code

Line 2540: FROM xla_mpa_jlt_assgns w

2536: , w.accounting_line_type_code
2537: , w.accounting_line_code
2538: , w.mpa_accounting_line_type_code
2539: , w.mpa_accounting_line_code
2540: FROM xla_mpa_jlt_assgns w
2541: , xla_mpa_jlt_assgns s
2542: WHERE s.application_id = g_application_id
2543: AND s.amb_context_code = g_staging_context_code
2544: AND s.event_class_code = w.event_class_code

Line 2541: , xla_mpa_jlt_assgns s

2537: , w.accounting_line_code
2538: , w.mpa_accounting_line_type_code
2539: , w.mpa_accounting_line_code
2540: FROM xla_mpa_jlt_assgns w
2541: , xla_mpa_jlt_assgns s
2542: WHERE s.application_id = g_application_id
2543: AND s.amb_context_code = g_staging_context_code
2544: AND s.event_class_code = w.event_class_code
2545: AND s.event_type_code = w.event_type_code

Line 2725: FROM xla_mpa_jlt_assgns w

2721: , w.accounting_line_type_code
2722: , w.accounting_line_code
2723: , w.mpa_accounting_line_type_code
2724: , w.mpa_accounting_line_code
2725: FROM xla_mpa_jlt_assgns w
2726: LEFT OUTER JOIN xla_mpa_jlt_assgns s
2727: ON s.amb_context_code = g_staging_context_code
2728: AND s.application_id = g_application_id
2729: AND s.event_class_code = w.event_class_code

Line 2726: LEFT OUTER JOIN xla_mpa_jlt_assgns s

2722: , w.accounting_line_code
2723: , w.mpa_accounting_line_type_code
2724: , w.mpa_accounting_line_code
2725: FROM xla_mpa_jlt_assgns w
2726: LEFT OUTER JOIN xla_mpa_jlt_assgns s
2727: ON s.amb_context_code = g_staging_context_code
2728: AND s.application_id = g_application_id
2729: AND s.event_class_code = w.event_class_code
2730: AND s.event_type_code = w.event_type_code

Line 2973: , xla_mpa_jlt_assgns b

2969: , w.accounting_line_code
2970: , w.mpa_accounting_line_type_code
2971: , w.mpa_accounting_line_code
2972: FROM xla_mpa_jlt_ac_assgns w
2973: , xla_mpa_jlt_assgns b
2974: WHERE b.amb_context_code = g_staging_context_code
2975: AND b.application_id = g_application_id
2976: AND b.event_class_code = w.event_class_code
2977: AND b.event_type_code = w.event_type_code

Line 3159: LEFT OUTER JOIN xla_mpa_jlt_assgns s

3155: , w.accounting_line_code
3156: , w.mpa_accounting_line_type_code
3157: , w.mpa_accounting_line_code
3158: FROM xla_mpa_jlt_ac_assgns w
3159: LEFT OUTER JOIN xla_mpa_jlt_assgns s
3160: ON s.amb_context_code = g_staging_context_code
3161: AND s.event_class_code = w.event_class_code
3162: AND s.event_type_code = w.event_type_code
3163: AND s.line_definition_owner_code = w.line_definition_owner_code

Line 6972: JOIN xla_mpa_jlt_assgns b

6968: AND l.event_class_code = s.event_class_code
6969: AND l.event_type_code = s.event_type_code
6970: AND l.line_definition_owner_code = s.line_definition_owner_code
6971: AND l.line_definition_code = s.line_definition_code
6972: JOIN xla_mpa_jlt_assgns b
6973: ON b.application_id = g_application_id
6974: AND b.amb_context_code = g_amb_context_code
6975: AND b.event_class_code = s.event_class_code
6976: AND b.event_type_code = s.event_type_code

Line 7165: , xla_mpa_jlt_assgns b

7161: , s.analytical_criterion_type_code
7162: , s.analytical_criterion_code
7163: , C_MERGE_IMPACT_NEW merge_impact
7164: FROM xla_mpa_jlt_ac_assgns s
7165: , xla_mpa_jlt_assgns b
7166: WHERE s.application_id = g_application_id
7167: AND s.amb_context_code = g_staging_context_code
7168: AND b.application_id = g_application_id
7169: AND b.amb_context_code = g_amb_context_code

Line 7308: FROM xla_mpa_jlt_assgns s

7304: , s.description_type_code s_description_type_code
7305: , w.description_type_code w_description_type_code
7306: , s.description_code s_description_code
7307: , w.description_code w_description_code
7308: FROM xla_mpa_jlt_assgns s
7309: JOIN xla_line_defn_jlt_assgns bw
7310: ON bw.application_id = g_application_id
7311: AND bw.amb_context_code = g_amb_context_code
7312: AND bw.event_class_code = s.event_class_code

Line 7318: LEFT OUTER JOIN xla_mpa_jlt_assgns w

7314: AND bw.line_definition_owner_code = s.line_definition_owner_code
7315: AND bw.line_definition_code = s.line_definition_code
7316: AND bw.accounting_line_type_code = s.accounting_line_type_code
7317: AND bw.accounting_line_code = s.accounting_line_code
7318: LEFT OUTER JOIN xla_mpa_jlt_assgns w
7319: ON w.application_id = g_application_id
7320: AND w.amb_context_code = g_amb_context_code
7321: AND w.event_class_code = s.event_class_code
7322: AND w.event_type_code = s.event_type_code

Line 7345: FROM xla_mpa_jlt_assgns w

7341: , w.mpa_accounting_line_type_code
7342: , w.mpa_accounting_line_code
7343: , C_MERGE_IMPACT_DELETED
7344: , NULL, NULL, NULL, NULL
7345: FROM xla_mpa_jlt_assgns w
7346: JOIN xla_line_defn_jlt_assgns bs
7347: ON bs.application_id = g_application_id
7348: AND bs.amb_context_code = g_staging_context_code
7349: AND bs.event_class_code = w.event_class_code

Line 7355: LEFT OUTER JOIN xla_mpa_jlt_assgns s

7351: AND bs.line_definition_owner_code = w.line_definition_owner_code
7352: AND bs.line_definition_code = w.line_definition_code
7353: AND bs.accounting_line_type_code = w.accounting_line_type_code
7354: AND bs.accounting_line_code = w.accounting_line_code
7355: LEFT OUTER JOIN xla_mpa_jlt_assgns s
7356: ON s.application_id = g_application_id
7357: AND s.amb_context_code = g_staging_context_code
7358: AND s.event_class_code = w.event_class_code
7359: AND s.event_type_code = w.event_type_code