VIEW: BEN.BEN_CM_TYP_F#

Source

View Text - Preformatted

select CM_TYP_ID CM_TYP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, WHNVR_TRGRD_FLAG WHNVR_TRGRD_FLAG, TRK_MLG_FLAG TRK_MLG_FLAG, TO_BE_SENT_DT_CD TO_BE_SENT_DT_CD, INSPN_RQD_FLAG INSPN_RQD_FLAG, RCPENT_CD RCPENT_CD, CCT_ATTRIBUTE_CATEGORY CCT_ATTRIBUTE_CATEGORY, CCT_ATTRIBUTE1 CCT_ATTRIBUTE1, CCT_ATTRIBUTE10 CCT_ATTRIBUTE10, CCT_ATTRIBUTE11 CCT_ATTRIBUTE11, CCT_ATTRIBUTE12 CCT_ATTRIBUTE12, CCT_ATTRIBUTE13 CCT_ATTRIBUTE13, CCT_ATTRIBUTE14 CCT_ATTRIBUTE14, CCT_ATTRIBUTE15 CCT_ATTRIBUTE15, CCT_ATTRIBUTE16 CCT_ATTRIBUTE16, CCT_ATTRIBUTE17 CCT_ATTRIBUTE17, CCT_ATTRIBUTE18 CCT_ATTRIBUTE18, CCT_ATTRIBUTE19 CCT_ATTRIBUTE19, CCT_ATTRIBUTE2 CCT_ATTRIBUTE2, CCT_ATTRIBUTE20 CCT_ATTRIBUTE20, CCT_ATTRIBUTE21 CCT_ATTRIBUTE21, CCT_ATTRIBUTE22 CCT_ATTRIBUTE22, CCT_ATTRIBUTE23 CCT_ATTRIBUTE23, CCT_ATTRIBUTE24 CCT_ATTRIBUTE24, CCT_ATTRIBUTE25 CCT_ATTRIBUTE25, CCT_ATTRIBUTE26 CCT_ATTRIBUTE26, CCT_ATTRIBUTE27 CCT_ATTRIBUTE27, CCT_ATTRIBUTE28 CCT_ATTRIBUTE28, CCT_ATTRIBUTE29 CCT_ATTRIBUTE29, CCT_ATTRIBUTE3 CCT_ATTRIBUTE3, CCT_ATTRIBUTE30 CCT_ATTRIBUTE30, CCT_ATTRIBUTE4 CCT_ATTRIBUTE4, CCT_ATTRIBUTE5 CCT_ATTRIBUTE5, CCT_ATTRIBUTE6 CCT_ATTRIBUTE6, CCT_ATTRIBUTE7 CCT_ATTRIBUTE7, CCT_ATTRIBUTE8 CCT_ATTRIBUTE8, CCT_ATTRIBUTE9 CCT_ATTRIBUTE9, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DESC_TXT DESC_TXT, PARNT_CM_TYP_ID PARNT_CM_TYP_ID, CM_USG_CD CM_USG_CD, SHRT_NAME SHRT_NAME, CM_TYP_RL CM_TYP_RL, PC_KIT_CD PC_KIT_CD, MX_NUM_AVLBL_VAL MX_NUM_AVLBL_VAL, INSPN_RQD_RL INSPN_RQD_RL, TO_BE_SENT_DT_RL TO_BE_SENT_DT_RL, INACTIVE_FLAG INACTIVE_FLAG from "BEN"."BEN_CM_TYP_F"

View Text - HTML Formatted

SELECT CM_TYP_ID CM_TYP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, WHNVR_TRGRD_FLAG WHNVR_TRGRD_FLAG
, TRK_MLG_FLAG TRK_MLG_FLAG
, TO_BE_SENT_DT_CD TO_BE_SENT_DT_CD
, INSPN_RQD_FLAG INSPN_RQD_FLAG
, RCPENT_CD RCPENT_CD
, CCT_ATTRIBUTE_CATEGORY CCT_ATTRIBUTE_CATEGORY
, CCT_ATTRIBUTE1 CCT_ATTRIBUTE1
, CCT_ATTRIBUTE10 CCT_ATTRIBUTE10
, CCT_ATTRIBUTE11 CCT_ATTRIBUTE11
, CCT_ATTRIBUTE12 CCT_ATTRIBUTE12
, CCT_ATTRIBUTE13 CCT_ATTRIBUTE13
, CCT_ATTRIBUTE14 CCT_ATTRIBUTE14
, CCT_ATTRIBUTE15 CCT_ATTRIBUTE15
, CCT_ATTRIBUTE16 CCT_ATTRIBUTE16
, CCT_ATTRIBUTE17 CCT_ATTRIBUTE17
, CCT_ATTRIBUTE18 CCT_ATTRIBUTE18
, CCT_ATTRIBUTE19 CCT_ATTRIBUTE19
, CCT_ATTRIBUTE2 CCT_ATTRIBUTE2
, CCT_ATTRIBUTE20 CCT_ATTRIBUTE20
, CCT_ATTRIBUTE21 CCT_ATTRIBUTE21
, CCT_ATTRIBUTE22 CCT_ATTRIBUTE22
, CCT_ATTRIBUTE23 CCT_ATTRIBUTE23
, CCT_ATTRIBUTE24 CCT_ATTRIBUTE24
, CCT_ATTRIBUTE25 CCT_ATTRIBUTE25
, CCT_ATTRIBUTE26 CCT_ATTRIBUTE26
, CCT_ATTRIBUTE27 CCT_ATTRIBUTE27
, CCT_ATTRIBUTE28 CCT_ATTRIBUTE28
, CCT_ATTRIBUTE29 CCT_ATTRIBUTE29
, CCT_ATTRIBUTE3 CCT_ATTRIBUTE3
, CCT_ATTRIBUTE30 CCT_ATTRIBUTE30
, CCT_ATTRIBUTE4 CCT_ATTRIBUTE4
, CCT_ATTRIBUTE5 CCT_ATTRIBUTE5
, CCT_ATTRIBUTE6 CCT_ATTRIBUTE6
, CCT_ATTRIBUTE7 CCT_ATTRIBUTE7
, CCT_ATTRIBUTE8 CCT_ATTRIBUTE8
, CCT_ATTRIBUTE9 CCT_ATTRIBUTE9
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DESC_TXT DESC_TXT
, PARNT_CM_TYP_ID PARNT_CM_TYP_ID
, CM_USG_CD CM_USG_CD
, SHRT_NAME SHRT_NAME
, CM_TYP_RL CM_TYP_RL
, PC_KIT_CD PC_KIT_CD
, MX_NUM_AVLBL_VAL MX_NUM_AVLBL_VAL
, INSPN_RQD_RL INSPN_RQD_RL
, TO_BE_SENT_DT_RL TO_BE_SENT_DT_RL
, INACTIVE_FLAG INACTIVE_FLAG
FROM "BEN"."BEN_CM_TYP_F"