CJM_CLAIM_REASON_CODES_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
REASON_CODE_ID CLAIM_REASON_CODE REASON_CODE_NAME DESCRIPTION SET_ID START_DATE END_DATE CM_REASON_CODE ADJUSTMENT_REASON_CODE CHARGEBACK_REASON_CODE BUY_SIDE_FLAG SELL_SIDE_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE REASON_CODE_GUID

Query

SQL_Statement

SELECT b.reason_code_id, b.claim_reason_code, tl.reason_code_name, tl.description, b.set_id, b.start_date, b.end_date, b.cm_reason_code, b.adjustment_reason_code, b.chargeback_reason_code, b.buy_side_flag, b.sell_side_flag, 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.reason_code_guid FROM cjm_claim_reason_codes_b b, cjm_claim_reason_codes_tl tl WHERE b.reason_code_id = tl.reason_code_id AND tl.language = userenv('LANG')