VIEW: APPS.BENBV_CM_TRGR_V

Source

View Text - Preformatted

SELECT CM.DESC_TXT, /* codes */ CM.CM_TRGR_SRC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_SRC',CM.CM_TRGR_SRC_CD), CM.CM_TRGR_TYP_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_TYP',CM.CM_TRGR_TYP_CD), CM.PROC_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PROC',CM.PROC_CD), /* id columns */ CM.CM_TRGR_ID, /* who columns */ CM.LAST_UPDATE_DATE, CM.LAST_UPDATED_BY, CM.CREATED_BY, CM.CREATION_DATE FROM BEN_CM_TRGR CM WITH READ ONLY

View Text - HTML Formatted

SELECT CM.DESC_TXT
, /* CODES */ CM.CM_TRGR_SRC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_SRC'
, CM.CM_TRGR_SRC_CD)
, CM.CM_TRGR_TYP_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_TRGR_TYP'
, CM.CM_TRGR_TYP_CD)
, CM.PROC_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PROC'
, CM.PROC_CD)
, /* ID COLUMNS */ CM.CM_TRGR_ID
, /* WHO COLUMNS */ CM.LAST_UPDATE_DATE
, CM.LAST_UPDATED_BY
, CM.CREATED_BY
, CM.CREATION_DATE
FROM BEN_CM_TRGR CM WITH READ ONLY