CJM_CLAIM_TYPES_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name

CLAIM_TYPE_ID CLAIM_TYPE_CODE CLAIM_TYPE_NAME DESCRIPTION SET_ID BUY_SIDE_FLAG SELL_SIDE_FLAG ENABLED_FLAG START_DATE END_DATE CM_CUST_TRX_TYPE_SEQ_ID INV_CUST_TRX_TYPE_SEQ_ID CB_CUST_TRX_TYPE_SEQ_ID ADJ_WO_CUST_TRX_TYPE_ID RCPT_WO_CUST_TRX_TYPE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CLAIM_TYPE_GUID

Query

SQL_Statement

SELECT b.claim_type_id, b.claim_type_code, tl.claim_type_name, tl.description, b.set_id, b.buy_side_flag, b.sell_side_flag, b.enabled_flag, b.start_date, b.end_date, b.cm_cust_trx_type_seq_id, b.inv_cust_trx_type_seq_id, b.cb_cust_trx_type_seq_id, b.adj_wo_cust_trx_type_id, b.rcpt_wo_cust_trx_type_id, b.object_version_number, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, b.request_id, b.job_definition_name, b.job_definition_package, b.claim_type_guid FROM cjm_claim_types_b b, cjm_claim_types_tl tl WHERE b.claim_type_id = tl.claim_type_id AND tl.language = userenv('LANG')