APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MPA_JLT_ADR_ASSGNS

Line 1869: FROM xla_mpa_jlt_adr_assgns w

1865: , w.mpa_accounting_line_code
1866: , w.flexfield_segment_code
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

Line 1870: , xla_mpa_jlt_adr_assgns s

1866: , w.flexfield_segment_code
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

Line 2043: FROM xla_mpa_jlt_adr_assgns w

2039: , w.mpa_accounting_line_code
2040: , w.flexfield_segment_code
2041: , NULL
2042: , l.accounting_coa_id
2043: FROM xla_mpa_jlt_adr_assgns w
2044: JOIN xla_line_definitions_b l
2045: ON l.amb_context_code = g_amb_context_code
2046: AND l.application_id = g_application_id
2047: AND l.event_class_code = w.event_class_code

Line 2062: LEFT OUTER JOIN xla_mpa_jlt_adr_assgns s

2058: AND j.accounting_line_type_code = w.accounting_line_type_code
2059: AND j.accounting_line_code = w.accounting_line_code
2060: AND j.mpa_accounting_line_type_code = w.mpa_accounting_line_type_code
2061: AND j.mpa_accounting_line_code = w.mpa_accounting_line_code
2062: LEFT OUTER JOIN xla_mpa_jlt_adr_assgns s
2063: ON s.amb_context_code = g_staging_context_code
2064: AND s.application_id = g_application_id
2065: AND s.event_class_code = w.event_class_code
2066: AND s.event_type_code = w.event_type_code

Line 6964: FROM xla_mpa_jlt_adr_assgns s

6960: , s.segment_rule_code s_segment_rule_code
6961: , w.segment_rule_code w_segment_rule_code
6962: , s.inherit_adr_flag s_inherit_adr_flag
6963: , w.inherit_adr_flag w_inherit_adr_flag
6964: FROM xla_mpa_jlt_adr_assgns s
6965: JOIN xla_line_definitions_b l
6966: ON l.application_id = g_application_id
6967: AND l.amb_context_code = g_amb_context_code
6968: AND l.event_class_code = s.event_class_code

Line 6983: LEFT OUTER JOIN xla_mpa_jlt_adr_assgns w

6979: AND b.accounting_line_type_code = s.accounting_line_type_code
6980: AND b.accounting_line_code = s.accounting_line_code
6981: AND b.mpa_accounting_line_type_code = s.mpa_accounting_line_type_code
6982: AND b.mpa_accounting_line_code = s.mpa_accounting_line_code
6983: LEFT OUTER JOIN xla_mpa_jlt_adr_assgns w
6984: ON w.application_id = g_application_id
6985: AND w.amb_context_code = g_amb_context_code
6986: AND w.event_class_code = s.event_class_code
6987: AND w.event_type_code = s.event_type_code