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 6962: JOIN xla_mpa_jlt_assgns b

6958: AND l.event_class_code = s.event_class_code
6959: AND l.event_type_code = s.event_type_code
6960: AND l.line_definition_owner_code = s.line_definition_owner_code
6961: AND l.line_definition_code = s.line_definition_code
6962: JOIN xla_mpa_jlt_assgns b
6963: ON b.application_id = g_application_id
6964: AND b.amb_context_code = g_amb_context_code
6965: AND b.event_class_code = s.event_class_code
6966: AND b.event_type_code = s.event_type_code

Line 7155: , xla_mpa_jlt_assgns b

7151: , s.analytical_criterion_type_code
7152: , s.analytical_criterion_code
7153: , C_MERGE_IMPACT_NEW merge_impact
7154: FROM xla_mpa_jlt_ac_assgns s
7155: , xla_mpa_jlt_assgns b
7156: WHERE s.application_id = g_application_id
7157: AND s.amb_context_code = g_staging_context_code
7158: AND b.application_id = g_application_id
7159: AND b.amb_context_code = g_amb_context_code

Line 7298: FROM xla_mpa_jlt_assgns s

7294: , s.description_type_code s_description_type_code
7295: , w.description_type_code w_description_type_code
7296: , s.description_code s_description_code
7297: , w.description_code w_description_code
7298: FROM xla_mpa_jlt_assgns s
7299: JOIN xla_line_defn_jlt_assgns bw
7300: ON bw.application_id = g_application_id
7301: AND bw.amb_context_code = g_amb_context_code
7302: AND bw.event_class_code = s.event_class_code

Line 7308: LEFT OUTER JOIN xla_mpa_jlt_assgns w

7304: AND bw.line_definition_owner_code = s.line_definition_owner_code
7305: AND bw.line_definition_code = s.line_definition_code
7306: AND bw.accounting_line_type_code = s.accounting_line_type_code
7307: AND bw.accounting_line_code = s.accounting_line_code
7308: LEFT OUTER JOIN xla_mpa_jlt_assgns w
7309: ON w.application_id = g_application_id
7310: AND w.amb_context_code = g_amb_context_code
7311: AND w.event_class_code = s.event_class_code
7312: AND w.event_type_code = s.event_type_code

Line 7335: FROM xla_mpa_jlt_assgns w

7331: , w.mpa_accounting_line_type_code
7332: , w.mpa_accounting_line_code
7333: , C_MERGE_IMPACT_DELETED
7334: , NULL, NULL, NULL, NULL
7335: FROM xla_mpa_jlt_assgns w
7336: JOIN xla_line_defn_jlt_assgns bs
7337: ON bs.application_id = g_application_id
7338: AND bs.amb_context_code = g_staging_context_code
7339: AND bs.event_class_code = w.event_class_code

Line 7345: LEFT OUTER JOIN xla_mpa_jlt_assgns s

7341: AND bs.line_definition_owner_code = w.line_definition_owner_code
7342: AND bs.line_definition_code = w.line_definition_code
7343: AND bs.accounting_line_type_code = w.accounting_line_type_code
7344: AND bs.accounting_line_code = w.accounting_line_code
7345: LEFT OUTER JOIN xla_mpa_jlt_assgns s
7346: ON s.application_id = g_application_id
7347: AND s.amb_context_code = g_staging_context_code
7348: AND s.event_class_code = w.event_class_code
7349: AND s.event_type_code = w.event_type_code