CJM_ADJUSTMENT_TYPES_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
ADJUSTMENT_TYPE_ID ADJUSTMENT_TYPE_UNIQUE_CODE ADJUSTMENT_TYPE_NAME ADJUSTMENT_TYPE_GUID DESCRIPTION SET_ID ADJUSTMENT_TYPE_CODE BUY_SIDE_FLAG SELL_SIDE_FLAG SEEDED_FLAG ENABLED_FLAG START_DATE END_DATE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ADJUSTMENT_NUMBER_PREFIX

Query

SQL_Statement

SELECT B.ADJUSTMENT_TYPE_ID, B.ADJUSTMENT_TYPE_UNIQUE_CODE, TL.ADJUSTMENT_TYPE_NAME, B.ADJUSTMENT_TYPE_GUID, TL.DESCRIPTION, B.SET_ID, B.ADJUSTMENT_TYPE_CODE, B.BUY_SIDE_FLAG, B.SELL_SIDE_FLAG, B.SEEDED_FLAG, B.ENABLED_FLAG, B.START_DATE, B.END_DATE, 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.ADJUSTMENT_NUMBER_PREFIX FROM CJM_ADJUSTMENT_TYPES_B B, CJM_ADJUSTMENT_TYPES_TL TL WHERE B.ADJUSTMENT_TYPE_ID = TL.ADJUSTMENT_TYPE_ID AND TL.LANGUAGE = USERENV('LANG')