APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_JLT_ACCT_ATTRS

Line 3930: FROM xla_jlt_acct_attrs w

3926: SELECT w.event_class_code
3927: , w.accounting_line_type_code
3928: ,w.accounting_line_code
3929: ,w.accounting_attribute_code
3930: FROM xla_jlt_acct_attrs w
3931: , xla_acct_line_types_b b
3932: WHERE b.amb_context_code = g_staging_context_code
3933: AND b.application_id = g_application_id
3934: AND b.accounting_line_type_code = w.accounting_line_type_code

Line 3941: FROM xla_jlt_acct_attrs s

3937: AND w.application_id = g_application_id
3938: AND w.accounting_line_type_code = C_OWNER_ORACLE
3939: AND NOT EXISTS
3940: (SELECT 1
3941: FROM xla_jlt_acct_attrs s
3942: WHERE s.amb_context_code = g_staging_context_code
3943: AND s.application_id = g_application_id
3944: AND s.accounting_line_type_code = w.accounting_line_type_code
3945: AND s.accounting_line_code = w.accounting_line_code

Line 5826: FROM xla_jlt_acct_attrs s

5822: , s.source_code s_source_code
5823: , w.source_code w_source_code
5824: , s.event_class_default_flag s_event_class_default_flag
5825: , w.event_class_default_flag w_event_class_default_flag
5826: FROM xla_jlt_acct_attrs s
5827: JOIN xla_acct_line_types_b b
5828: ON b.application_id = g_application_id
5829: AND b.amb_context_code = g_amb_context_code
5830: AND b.event_class_code = s.event_class_code

Line 5833: LEFT OUTER JOIN xla_jlt_acct_attrs w

5829: AND b.amb_context_code = g_amb_context_code
5830: AND b.event_class_code = s.event_class_code
5831: AND b.accounting_line_type_code = s.accounting_line_type_code
5832: AND b.accounting_line_code = s.accounting_line_code
5833: LEFT OUTER JOIN xla_jlt_acct_attrs w
5834: ON w.application_id = g_application_id
5835: AND w.amb_context_code = g_amb_context_code
5836: AND w.event_class_code = s.event_class_code
5837: AND w.accounting_line_type_code = s.accounting_line_type_code