CJM_XLA_SUPP_ACC_HDR_MLS_VL
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
EVENT_ID PROGRAM_TEMPLATE_NAME PROGRAM_TYPE_NAME ADJUSTMENT_TYPE_NAME PROGRAM_NAME LANGUAGE |
Query
SQL_Statement |
---|
SELECT /*+ leading(XEG) use_nl(XEG oxa )*/ oxa.event_id, template_tl.program_type_name program_template_name, ptype_tl.program_type_name program_type_name, adj.adjustment_type_name, pgm_tl.name program_name, pgm_tl.language language FROM xla_events_gt xeg, cjm_programs_utilized_all_b util, cjm_xla_accruals oxa, cjm_programs_all_b pgm_b, cjm_programs_all_tl pgm_tl, cjm_program_types_b template_b, cjm_program_types_tl template_tl, cjm_program_types_b ptype_b, cjm_program_types_tl ptype_tl, (SELECT adjtype_tl.adjustment_type_name, adjtype_b.adjustment_type_id, adjtype_tl.language FROM cjm_adjustment_types_b adjtype_b, cjm_adjustment_types_tl adjtype_tl WHERE adjtype_b.adjustment_type_id = adjtype_tl.adjustment_type_id) adj WHERE util.utilization_id = oxa.utilization_id AND xeg.entity_code = 'SUPPLIER_ACCRUAL' AND xeg.application_id = 10566 AND xeg.source_id_int_1 = oxa.utilization_id AND oxa.event_type_code = xeg.event_type_code AND util.program_header_id = pgm_b.program_header_id AND pgm_b.program_header_id = pgm_tl.program_header_id AND pgm_b.program_type_id = ptype_b.program_type_id AND ptype_b.program_type_id = ptype_tl.program_type_id AND util.adjustment_type_id = adj.adjustment_type_id(+) AND ptype_b.parent_program_type_id = template_b.program_type_id AND template_b.program_type_id = template_tl.program_type_id AND template_tl.language = pgm_tl.language AND ptype_tl.language = pgm_tl.language AND adj.language(+) = pgm_tl.language |