CJM_XLA_SUPP_ACC_HDR_MLS

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

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

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