APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_DESC_PRIORITIES

Line 5126: FROM xla_desc_priorities s

5122: ,s.description_prio_id s_description_prio_id
5123: ,w.description_prio_id w_description_prio_id
5124: ,bs.transaction_coa_id s_transaction_coa_id
5125: ,bw.transaction_coa_id w_transaction_coa_id
5126: FROM xla_desc_priorities s
5127: JOIN xla_descriptions_b bs
5128: ON bs.application_id = s.application_id
5129: AND bs.amb_context_code = s.amb_context_code
5130: AND bs.description_type_code = s.description_type_code

Line 5137: LEFT OUTER JOIN xla_desc_priorities w

5133: ON bw.application_id = g_application_id
5134: AND bw.amb_context_code = g_amb_context_code
5135: AND bw.description_type_code = s.description_type_code
5136: AND bw.description_code = s.description_code
5137: LEFT OUTER JOIN xla_desc_priorities w
5138: ON w.application_id = g_application_id
5139: AND w.amb_context_code = g_amb_context_code
5140: AND w.description_type_code = s.description_type_code
5141: AND w.description_code = s.description_code

Line 5150: FROM xla_desc_priorities w

5146: ,w.description_code
5147: ,w.user_sequence
5148: ,C_MERGE_IMPACT_DELETED
5149: , null , null , null , null
5150: FROM xla_desc_priorities w
5151: JOIN xla_descriptions_b bs
5152: ON bs.application_id = g_application_id
5153: AND bs.amb_context_code = g_staging_context_code
5154: AND bs.description_type_code = w.description_type_code

Line 5159: FROM xla_desc_priorities s

5155: AND bs.description_code = w.description_code
5156: WHERE w.amb_context_code = g_amb_context_code
5157: AND NOT EXISTS
5158: (SELECT 1
5159: FROM xla_desc_priorities s
5160: WHERE s.application_id = g_application_id
5161: AND s.amb_context_code = g_staging_context_code
5162: AND s.description_type_code = w.description_type_code
5163: AND s.description_code = w.description_code