CJM_XLA_CUST_ACC_HDR_MLS_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
EVENT_ID CUST_PROGRAM_TEMPLATE_NAME CUST_PROGRAM_TYPE_NAME CUST_ADJUSTMENT_TYPE_NAME CUST_PROGRAM_NAME LANGUAGE

Query

SQL_Statement

SELECT /*+ leading(XEG) use_nl(XEG cxa )*/ cxa.event_id event_id, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_PROGRAM_TYPE', pgm_b.program_type_code) cust_program_template_name, ptype_tl.program_type_name cust_program_type_name, adj.adjustment_type_name cust_adjustment_type_name, pgm_tl.name cust_program_name, pgm_tl.language language FROM xla_events_gt xeg, cjm_customer_accruals_all accr, cjm_xla_customer_accruals cxa, cjm_programs_all_b pgm_b, cjm_programs_all_tl pgm_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 accr.customer_accrual_id = cxa.customer_accrual_id AND xeg.entity_code = 'CUSTOMER_ACCRUAL' AND xeg.application_id = 10566 AND xeg.source_id_int_1 = cxa.customer_accrual_id AND cxa.event_type_code = xeg.event_type_code AND accr.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 accr.adjustment_type_id = adj.adjustment_type_id(+) AND pgm_tl.language = ptype_tl.language AND adj.language(+) = pgm_tl.language