View: BEN_CM_TYP_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_CM_TYP_V

View Text

SELECT CCT.ROWID ROW_ID
, CCT.CM_TYP_ID
, CCT.EFFECTIVE_START_DATE
, CCT.EFFECTIVE_END_DATE
, TL.NAME
, CCT.DESC_TXT
, CCT.CM_TYP_RL
, CCT.CM_USG_CD
, CCT.WHNVR_TRGRD_FLAG
, CCT.SHRT_NAME
, CCT.PC_KIT_CD
, CCT.TRK_MLG_FLAG
, CCT.MX_NUM_AVLBL_VAL
, CCT.TO_BE_SENT_DT_CD
, CCT.TO_BE_SENT_DT_RL
, CCT.INSPN_RQD_FLAG
, CCT.INSPN_RQD_RL
, CCT.RCPENT_CD
, CCT.PARNT_CM_TYP_ID
, CCT.BUSINESS_GROUP_ID
, CCT.CCT_ATTRIBUTE_CATEGORY
, CCT.CCT_ATTRIBUTE1
, CCT.CCT_ATTRIBUTE10
, CCT.CCT_ATTRIBUTE11
, CCT.CCT_ATTRIBUTE12
, CCT.CCT_ATTRIBUTE13
, CCT.CCT_ATTRIBUTE14
, CCT.CCT_ATTRIBUTE15
, CCT.CCT_ATTRIBUTE16
, CCT.CCT_ATTRIBUTE17
, CCT.CCT_ATTRIBUTE18
, CCT.CCT_ATTRIBUTE19
, CCT.CCT_ATTRIBUTE2
, CCT.CCT_ATTRIBUTE20
, CCT.CCT_ATTRIBUTE21
, CCT.CCT_ATTRIBUTE22
, CCT.CCT_ATTRIBUTE23
, CCT.CCT_ATTRIBUTE24
, CCT.CCT_ATTRIBUTE25
, CCT.CCT_ATTRIBUTE26
, CCT.CCT_ATTRIBUTE27
, CCT.CCT_ATTRIBUTE28
, CCT.CCT_ATTRIBUTE29
, CCT.CCT_ATTRIBUTE3
, CCT.CCT_ATTRIBUTE30
, CCT.CCT_ATTRIBUTE4
, CCT.CCT_ATTRIBUTE5
, CCT.CCT_ATTRIBUTE6
, CCT.CCT_ATTRIBUTE7
, CCT.CCT_ATTRIBUTE8
, CCT.CCT_ATTRIBUTE9
, CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.LAST_UPDATE_LOGIN
, CCT.CREATED_BY
, CCT.CREATION_DATE
, CCT.OBJECT_VERSION_NUMBER
FROM BEN_CM_TYP_F CCT
, BEN_CM_TYP_F_TL TL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CCT.EFFECTIVE_START_DATE
AND CCT.EFFECTIVE_END_DATE
AND TL.CM_TYP_ID = CCT.CM_TYP_ID
AND TL.EFFECTIVE_START_DATE = CCT.EFFECTIVE_START_DATE
AND USERENV('LANG') = TL.LANGUAGE

Columns