CJM_XLA_CUST_CLAIM_ACCR_MLS

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

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 IN ('CUSTOMER_CLAIM_SETTLEMENT','CUST_CLAIM_SETLMNT_EXT_AP','CUST_CLAIM_SETLMNT_EXT_AR') 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

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 IN ('CUSTOMER_CLAIM_SETTLEMENT','CUST_CLAIM_SETLMNT_EXT_AP','CUST_CLAIM_SETLMNT_EXT_AR')

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