DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_DESCRIPTIONS_B

Line 3836: FROM xla_descriptions_b w

3832: IS
3833: CURSOR c_comp IS
3834: SELECT w.description_type_code
3835: , w.description_code
3836: FROM xla_descriptions_b w
3837: WHERE w.application_id = g_application_id
3838: AND w.amb_context_code = g_amb_context_code
3839: AND w.description_type_code = C_OWNER_ORACLE
3840: AND NOT EXISTS (

Line 3842: FROM xla_descriptions_b s

3838: AND w.amb_context_code = g_amb_context_code
3839: AND w.description_type_code = C_OWNER_ORACLE
3840: AND NOT EXISTS (
3841: SELECT 1
3842: FROM xla_descriptions_b s
3843: WHERE s.application_id = g_application_id
3844: AND s.amb_context_code = g_staging_context_code
3845: AND s.description_type_code = w.description_type_code
3846: AND s.description_code = w.description_code);

Line 4987: FROM xla_descriptions_b bs

4983: ,bs.transaction_coa_id s_transaction_coa_id
4984: ,bw.transaction_coa_id w_transaction_coa_id
4985: ,bs.enabled_flag s_enabled_flag
4986: ,bw.enabled_flag w_enabled_flag
4987: FROM xla_descriptions_b bs
4988: JOIN xla_descriptions_tl ts
4989: ON ts.application_id = bs.application_id
4990: AND ts.amb_context_code = bs.amb_context_code
4991: AND ts.description_type_code = bs.description_type_code

Line 4994: JOIN xla_descriptions_b bw

4990: AND ts.amb_context_code = bs.amb_context_code
4991: AND ts.description_type_code = bs.description_type_code
4992: AND ts.description_code = bs.description_code
4993: AND ts.language = USERENV('LANG')
4994: JOIN xla_descriptions_b bw
4995: ON bw.application_id = g_application_id
4996: AND bw.amb_context_code = g_amb_context_code
4997: AND bw.description_type_code = bs.description_type_code
4998: AND bw.description_code = bs.description_code

Line 5127: JOIN xla_descriptions_b bs

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
5131: AND bs.description_code = s.description_code

Line 5132: JOIN xla_descriptions_b bw

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
5131: AND bs.description_code = s.description_code
5132: JOIN xla_descriptions_b bw
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

Line 5151: JOIN xla_descriptions_b bs

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
5155: AND bs.description_code = w.description_code