DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 5664: FROM xla_analytical_sources s

5660: , s.source_application_id s_source_application_id
5661: , w.source_type_code w_source_type_code
5662: , w.source_code w_source_code
5663: , w.source_application_id w_source_application_id
5664: FROM xla_analytical_sources s
5665: JOIN xla_analytical_dtls_b b
5666: ON b.amb_context_code = g_amb_context_code
5667: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5668: AND b.analytical_criterion_code = s.analytical_criterion_code

Line 5670: LEFT OUTER JOIN xla_analytical_sources w

5666: ON b.amb_context_code = g_amb_context_code
5667: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5668: AND b.analytical_criterion_code = s.analytical_criterion_code
5669: AND b.analytical_detail_code = s.analytical_detail_code
5670: LEFT OUTER JOIN xla_analytical_sources w
5671: ON w.amb_context_code = g_amb_context_code
5672: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5673: AND w.analytical_criterion_code = s.analytical_criterion_code
5674: AND w.analytical_detail_code = s.analytical_detail_code

Line 5696: FROM xla_analytical_sources w

5692: , NULL
5693: , w.source_type_code
5694: , w.source_code
5695: , w.source_application_id
5696: FROM xla_analytical_sources w
5697: , xla_analytical_dtls_b b
5698: WHERE w.amb_context_code = g_amb_context_code
5699: AND b.amb_context_code = g_staging_context_code
5700: AND b.analytical_criterion_type_code = w.analytical_criterion_type_code

Line 5705: FROM xla_analytical_sources s

5701: AND b.analytical_criterion_code = w.analytical_criterion_code
5702: AND b.analytical_detail_code = w.analytical_detail_code
5703: AND NOT EXISTS
5704: (SELECT 1
5705: FROM xla_analytical_sources s
5706: WHERE s.amb_context_code = g_staging_context_code
5707: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5708: AND s.analytical_criterion_code = w.analytical_criterion_code
5709: AND s.analytical_detail_code = w.analytical_detail_code