CJM_XLA_CUST_CLAIM_ACCR_MLS_VL
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: VIEW
Columns
Name |
---|
EVENT_ID LINE_NUMBER CUST_CLA_ASO_PRG_TEMP_NAME CUST_CLA_ASO_PRG_TYPE_NAME CUST_UTIL_PROGRAM_NAME LANGUAGE |
Query
SQL_Statement |
---|
SELECT /*+ leading(XEG) use_nl(XEG cxh )*/ xeg.event_id event_id, cxl.line_number line_number, cjm_utility_pkg.get_lookup_meaning('ORA_CJM_PROGRAM_TYPE', pgm_b.program_type_code) cust_cla_aso_prg_temp_name, pgmtytl.PROGRAM_TYPE_NAME cust_cla_aso_prg_type_name, pgm_tl.name cust_util_program_name, pgm_tl.language language FROM cjm_claims_all cla, cjm_claim_associations_all classo, cjm_claim_lines_accrual_all claccrual, cjm_customer_accruals_all accr, cjm_xla_customer_claim_lines cxl, cjm_xla_customer_claim_headers cxh, cjm_programs_all_b pgm_b, cjm_program_types_b ptype_b, cjm_program_types_tl pgmtytl, cjm_programs_all_tl pgm_tl, xla_events_gt xeg WHERE xeg.entity_code = 'CUSTOMER_CLAIM_SETTLEMENT' AND cla.claim_for_code = 'CUSTOMER' AND xeg.application_id = 10566 AND xeg.source_id_int_1 = cxh.claim_id AND cxh.event_type_code = xeg.event_type_code AND xeg.event_id = cxh.event_id AND cxh.claim_id = cla.claim_id AND cla.claim_id = classo.claim_id AND classo.association_id = claccrual.association_id AND claccrual.customer_accrual_id = accr.customer_accrual_id AND cxh.xla_customer_claim_header_id = cxl.xla_customer_claim_header_id AND cxl.claim_line_accrual_id = claccrual.claim_line_accrual_id AND accr.program_header_id = pgm_b.program_header_id AND pgm_b.program_type_id = ptype_b.program_type_id AND pgmtytl.program_type_id = ptype_b.program_type_id AND pgm_b.program_header_id = pgm_tl.program_header_id AND pgmtytl.language = pgm_tl.language |