VIEW: APPS.BENBV_CM_TYP_V

Source

View Text - Preformatted

SELECT CCT.EFFECTIVE_START_DATE, CCT.EFFECTIVE_END_DATE, TL.NAME, CCT.DESC_TXT, CCT.SHRT_NAME, CCT.CM_TYP_RL, CCT.MX_NUM_AVLBL_VAL, CCT.INSPN_RQD_RL, CCT.TO_BE_SENT_DT_RL, /* descriptive flexfield */ '_DF:BEN:BEN_CM_TYP_F:CCT', /* codes */ CCT.TO_BE_SENT_DT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_TO_BE_SENT_DT',CCT.TO_BE_SENT_DT_CD), CCT.RCPENT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_RCPENT',CCT.RCPENT_CD), CCT.CM_USG_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_USG',CCT.CM_USG_CD), CCT.PC_KIT_CD, HR_BIS.BIS_DECODE_LOOKUP('BEN_PC_KIT',CCT.PC_KIT_CD), CCT.WHNVR_TRGRD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CCT.WHNVR_TRGRD_FLAG), CCT.TRK_MLG_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CCT.TRK_MLG_FLAG), CCT.INSPN_RQD_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',CCT.INSPN_RQD_FLAG), /* id columns */ CCT.CM_TYP_ID, CCT.BUSINESS_GROUP_ID, CCT.PARNT_CM_TYP_ID, /* who columns */ CCT.LAST_UPDATE_DATE, CCT.LAST_UPDATED_BY, CCT.CREATED_BY, CCT.CREATION_DATE FROM BEN_CM_TYP_F CCT, BEN_CM_TYP_F_TL TL WHERE CCT.CM_TYP_ID = TL.CM_TYP_ID AND CCT.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT CCT.EFFECTIVE_START_DATE
, CCT.EFFECTIVE_END_DATE
, TL.NAME
, CCT.DESC_TXT
, CCT.SHRT_NAME
, CCT.CM_TYP_RL
, CCT.MX_NUM_AVLBL_VAL
, CCT.INSPN_RQD_RL
, CCT.TO_BE_SENT_DT_RL
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_CM_TYP_F:CCT'
, /* CODES */ CCT.TO_BE_SENT_DT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_TO_BE_SENT_DT'
, CCT.TO_BE_SENT_DT_CD)
, CCT.RCPENT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RCPENT'
, CCT.RCPENT_CD)
, CCT.CM_USG_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_CM_USG'
, CCT.CM_USG_CD)
, CCT.PC_KIT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_PC_KIT'
, CCT.PC_KIT_CD)
, CCT.WHNVR_TRGRD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.WHNVR_TRGRD_FLAG)
, CCT.TRK_MLG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.TRK_MLG_FLAG)
, CCT.INSPN_RQD_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, CCT.INSPN_RQD_FLAG)
, /* ID COLUMNS */ CCT.CM_TYP_ID
, CCT.BUSINESS_GROUP_ID
, CCT.PARNT_CM_TYP_ID
, /* WHO COLUMNS */ CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.CREATED_BY
, CCT.CREATION_DATE
FROM BEN_CM_TYP_F CCT
, BEN_CM_TYP_F_TL TL
WHERE CCT.CM_TYP_ID = TL.CM_TYP_ID
AND CCT.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY