CEL_PROGRAMS_VL

Details

• Schema: FUSION

• Object owner: CEL

• Object type: VIEW

Columns

Name
PROGRAM_ID PROGRAM_NAME POINTS_RANGE_CODE POINTS_MINIMUM POINTS_MAXIMUM POINTS_INCREMENT TYPE_CODE SUBTYPE_CODE AWARD_TYPE_CODE VISIBILITY_CODE TIME_UNIT_CODE TIME_UNIT_COUNT TRIGGER_TIME_UNIT_COUNT OWNERS_ENABLED_FLAG START_DATE END_DATE USE_POINTS_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION AWARD_DESCRIPTION

Query

SQL_Statement

SELECT B.PROGRAM_ID, T.PROGRAM_NAME, B.POINTS_RANGE_CODE, B.POINTS_MINIMUM, B.POINTS_MAXIMUM, B.POINTS_INCREMENT, B.TYPE_CODE, B.SUBTYPE_CODE, B.AWARD_TYPE_CODE, B.VISIBILITY_CODE, B.TIME_UNIT_CODE, B.TIME_UNIT_COUNT, B.TRIGGER_TIME_UNIT_COUNT, B.OWNERS_ENABLED_FLAG, B.START_DATE, B.END_DATE, B.USE_POINTS_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.DESCRIPTION, T.AWARD_DESCRIPTION FROM CEL_PROGRAMS_B B, CEL_PROGRAMS_TL T WHERE B.PROGRAM_ID = T.PROGRAM_ID AND T.LANGUAGE = USERENV('LANG')