DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MAPPING_SETS_B

Line 4253: FROM xla_mapping_sets_b bs

4249: ,bs.view_application_id s_view_application_id
4250: ,bw.view_application_id w_view_application_id
4251: ,bs.lookup_type s_lookup_type
4252: ,bw.lookup_type w_lookup_type
4253: FROM xla_mapping_sets_b bs
4254: JOIN xla_mapping_sets_tl ts
4255: ON ts.amb_context_code = bs.amb_context_code
4256: AND ts.mapping_set_code = bs.mapping_set_code
4257: AND ts.language = USERENV('LANG')

Line 4258: JOIN xla_mapping_sets_b bw

4254: JOIN xla_mapping_sets_tl ts
4255: ON ts.amb_context_code = bs.amb_context_code
4256: AND ts.mapping_set_code = bs.mapping_set_code
4257: AND ts.language = USERENV('LANG')
4258: JOIN xla_mapping_sets_b bw
4259: ON bw.amb_context_code = g_amb_context_code
4260: AND bw.mapping_set_code = bs.mapping_set_code
4261: JOIN xla_mapping_sets_tl tw
4262: ON tw.amb_context_code = bw.amb_context_code

Line 4437: JOIN xla_mapping_sets_b bs

4433: ,s.input_value_type_code
4434: ,s.input_value_constant
4435: ,C_MERGE_IMPACT_NEW merge_impact
4436: FROM xla_mapping_set_values s
4437: JOIN xla_mapping_sets_b bs
4438: ON bs.amb_context_code = s.amb_context_code
4439: AND bs.mapping_set_code = s.mapping_set_code
4440: WHERE s.amb_context_code = g_staging_context_code
4441: AND NOT EXISTS

Line 4466: JOIN xla_mapping_sets_b bw

4462: ,w.input_value_type_code
4463: ,w.input_value_constant
4464: ,C_MERGE_IMPACT_DELETED
4465: FROM xla_mapping_set_values w
4466: JOIN xla_mapping_sets_b bw
4467: ON bw.amb_context_code = w.amb_context_code
4468: AND bw.mapping_set_code = w.mapping_set_code
4469: WHERE w.amb_context_code = g_staging_context_code
4470: AND NOT EXISTS