VIEW: APPS.BENBV_OPT_INFO_TYPES_V

Source

View Text - Preformatted

SELECT OPT.INFORMATION_TYPE, OPT.DESCRIPTION, OPT.LEGISLATION_CODE, OPT.PROGRAM_UPDATE_DATE, OPT.ACTIVE_INACTIVE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',OPT.ACTIVE_INACTIVE_FLAG), OPT.MULTIPLE_OCCURENCES_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',OPT.MULTIPLE_OCCURENCES_FLAG), /* id columns */ OPT.REQUEST_ID, OPT.PROGRAM_APPLICATION_ID, OPT.PROGRAM_ID, /* who columns */ OPT.LAST_UPDATE_DATE, OPT.LAST_UPDATED_BY, OPT.CREATED_BY, OPT.CREATION_DATE FROM BEN_OPT_INFO_TYPES OPT WITH READ ONLY

View Text - HTML Formatted

SELECT OPT.INFORMATION_TYPE
, OPT.DESCRIPTION
, OPT.LEGISLATION_CODE
, OPT.PROGRAM_UPDATE_DATE
, OPT.ACTIVE_INACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OPT.ACTIVE_INACTIVE_FLAG)
, OPT.MULTIPLE_OCCURENCES_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OPT.MULTIPLE_OCCURENCES_FLAG)
, /* ID COLUMNS */ OPT.REQUEST_ID
, OPT.PROGRAM_APPLICATION_ID
, OPT.PROGRAM_ID
, /* WHO COLUMNS */ OPT.LAST_UPDATE_DATE
, OPT.LAST_UPDATED_BY
, OPT.CREATED_BY
, OPT.CREATION_DATE
FROM BEN_OPT_INFO_TYPES OPT WITH READ ONLY