CJM_PROG_ADJUSTMENTS_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name

PROGRAM_ADJUSTMENT_ID PROGRAM_HEADER_ID ADJUSTMENT_NUMBER ADJUSTMENT_TYPE_CODE STATUS_CODE ADJUSTMENT_EFFECTIVE_DATE ADJUSTMENT_ACTIVATION_DATE ORIG_PROGRAM_START_DATE BU_ID ACCRUAL_TYPE_CODE ADJUSTMENT_COMMENTS SUBMITTED_BY SUBMITTED_DATE APPROVED_DATE REJECTED_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 NAME LANGUAGE SOURCE_LANG

Query

SQL_Statement

SELECT B.PROGRAM_ADJUSTMENT_ID, B.PROGRAM_HEADER_ID, B.ADJUSTMENT_NUMBER, B.ADJUSTMENT_TYPE_CODE, B.STATUS_CODE, B.ADJUSTMENT_EFFECTIVE_DATE, B.ADJUSTMENT_ACTIVATION_DATE, B.ORIG_PROGRAM_START_DATE, B.BU_ID, B.ACCRUAL_TYPE_CODE, B.ADJUSTMENT_COMMENTS, B.SUBMITTED_BY, B.SUBMITTED_DATE, B.APPROVED_DATE, B.REJECTED_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, T.NAME, T.LANGUAGE, T.SOURCE_LANG FROM CJM_PROG_ADJUSTMENTS_ALL_B B, CJM_PROG_ADJUSTMENTS_ALL_TL T WHERE B.PROGRAM_ADJUSTMENT_ID = T.PROGRAM_ADJUSTMENT_ID AND T.LANGUAGE=userenv('LANG')