DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 5660: FROM xla_analytical_sources s

5656: , s.source_application_id s_source_application_id
5657: , w.source_type_code w_source_type_code
5658: , w.source_code w_source_code
5659: , w.source_application_id w_source_application_id
5660: FROM xla_analytical_sources s
5661: JOIN xla_analytical_dtls_b b
5662: ON b.amb_context_code = g_amb_context_code
5663: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5664: AND b.analytical_criterion_code = s.analytical_criterion_code

Line 5666: LEFT OUTER JOIN xla_analytical_sources w

5662: ON b.amb_context_code = g_amb_context_code
5663: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5664: AND b.analytical_criterion_code = s.analytical_criterion_code
5665: AND b.analytical_detail_code = s.analytical_detail_code
5666: LEFT OUTER JOIN xla_analytical_sources w
5667: ON w.amb_context_code = g_amb_context_code
5668: AND w.analytical_criterion_type_code = s.analytical_criterion_type_code
5669: AND w.analytical_criterion_code = s.analytical_criterion_code
5670: AND w.analytical_detail_code = s.analytical_detail_code

Line 5692: FROM xla_analytical_sources w

5688: , NULL
5689: , w.source_type_code
5690: , w.source_code
5691: , w.source_application_id
5692: FROM xla_analytical_sources w
5693: , xla_analytical_dtls_b b
5694: WHERE w.amb_context_code = g_amb_context_code
5695: AND b.amb_context_code = g_staging_context_code
5696: AND b.analytical_criterion_type_code = w.analytical_criterion_type_code

Line 5701: FROM xla_analytical_sources s

5697: AND b.analytical_criterion_code = w.analytical_criterion_code
5698: AND b.analytical_detail_code = w.analytical_detail_code
5699: AND NOT EXISTS
5700: (SELECT 1
5701: FROM xla_analytical_sources s
5702: WHERE s.amb_context_code = g_staging_context_code
5703: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
5704: AND s.analytical_criterion_code = w.analytical_criterion_code
5705: AND s.analytical_detail_code = w.analytical_detail_code