VIEW: BEN.BEN_PL_BNF_CTFN_F#

Source

View Text - Preformatted

select PL_BNF_CTFN_ID PL_BNF_CTFN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BNF_CTFN_TYP_CD BNF_CTFN_TYP_CD, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG, PFD_FLAG PFD_FLAG, RQD_FLAG RQD_FLAG, PL_ID PL_ID, PCX_ATTRIBUTE_CATEGORY PCX_ATTRIBUTE_CATEGORY, PCX_ATTRIBUTE1 PCX_ATTRIBUTE1, PCX_ATTRIBUTE2 PCX_ATTRIBUTE2, PCX_ATTRIBUTE3 PCX_ATTRIBUTE3, PCX_ATTRIBUTE4 PCX_ATTRIBUTE4, PCX_ATTRIBUTE5 PCX_ATTRIBUTE5, PCX_ATTRIBUTE6 PCX_ATTRIBUTE6, PCX_ATTRIBUTE7 PCX_ATTRIBUTE7, PCX_ATTRIBUTE8 PCX_ATTRIBUTE8, PCX_ATTRIBUTE9 PCX_ATTRIBUTE9, PCX_ATTRIBUTE10 PCX_ATTRIBUTE10, PCX_ATTRIBUTE11 PCX_ATTRIBUTE11, PCX_ATTRIBUTE12 PCX_ATTRIBUTE12, PCX_ATTRIBUTE13 PCX_ATTRIBUTE13, PCX_ATTRIBUTE14 PCX_ATTRIBUTE14, PCX_ATTRIBUTE15 PCX_ATTRIBUTE15, PCX_ATTRIBUTE16 PCX_ATTRIBUTE16, PCX_ATTRIBUTE17 PCX_ATTRIBUTE17, PCX_ATTRIBUTE18 PCX_ATTRIBUTE18, PCX_ATTRIBUTE19 PCX_ATTRIBUTE19, PCX_ATTRIBUTE20 PCX_ATTRIBUTE20, PCX_ATTRIBUTE21 PCX_ATTRIBUTE21, PCX_ATTRIBUTE22 PCX_ATTRIBUTE22, PCX_ATTRIBUTE23 PCX_ATTRIBUTE23, PCX_ATTRIBUTE24 PCX_ATTRIBUTE24, PCX_ATTRIBUTE25 PCX_ATTRIBUTE25, PCX_ATTRIBUTE26 PCX_ATTRIBUTE26, PCX_ATTRIBUTE27 PCX_ATTRIBUTE27, PCX_ATTRIBUTE28 PCX_ATTRIBUTE28, PCX_ATTRIBUTE29 PCX_ATTRIBUTE29, PCX_ATTRIBUTE30 PCX_ATTRIBUTE30, 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, BNF_TYP_CD BNF_TYP_CD, RLSHP_TYP_CD RLSHP_TYP_CD, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL from "BEN"."BEN_PL_BNF_CTFN_F"

View Text - HTML Formatted

SELECT PL_BNF_CTFN_ID PL_BNF_CTFN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BNF_CTFN_TYP_CD BNF_CTFN_TYP_CD
, LACK_CTFN_SSPND_ENRT_FLAG LACK_CTFN_SSPND_ENRT_FLAG
, PFD_FLAG PFD_FLAG
, RQD_FLAG RQD_FLAG
, PL_ID PL_ID
, PCX_ATTRIBUTE_CATEGORY PCX_ATTRIBUTE_CATEGORY
, PCX_ATTRIBUTE1 PCX_ATTRIBUTE1
, PCX_ATTRIBUTE2 PCX_ATTRIBUTE2
, PCX_ATTRIBUTE3 PCX_ATTRIBUTE3
, PCX_ATTRIBUTE4 PCX_ATTRIBUTE4
, PCX_ATTRIBUTE5 PCX_ATTRIBUTE5
, PCX_ATTRIBUTE6 PCX_ATTRIBUTE6
, PCX_ATTRIBUTE7 PCX_ATTRIBUTE7
, PCX_ATTRIBUTE8 PCX_ATTRIBUTE8
, PCX_ATTRIBUTE9 PCX_ATTRIBUTE9
, PCX_ATTRIBUTE10 PCX_ATTRIBUTE10
, PCX_ATTRIBUTE11 PCX_ATTRIBUTE11
, PCX_ATTRIBUTE12 PCX_ATTRIBUTE12
, PCX_ATTRIBUTE13 PCX_ATTRIBUTE13
, PCX_ATTRIBUTE14 PCX_ATTRIBUTE14
, PCX_ATTRIBUTE15 PCX_ATTRIBUTE15
, PCX_ATTRIBUTE16 PCX_ATTRIBUTE16
, PCX_ATTRIBUTE17 PCX_ATTRIBUTE17
, PCX_ATTRIBUTE18 PCX_ATTRIBUTE18
, PCX_ATTRIBUTE19 PCX_ATTRIBUTE19
, PCX_ATTRIBUTE20 PCX_ATTRIBUTE20
, PCX_ATTRIBUTE21 PCX_ATTRIBUTE21
, PCX_ATTRIBUTE22 PCX_ATTRIBUTE22
, PCX_ATTRIBUTE23 PCX_ATTRIBUTE23
, PCX_ATTRIBUTE24 PCX_ATTRIBUTE24
, PCX_ATTRIBUTE25 PCX_ATTRIBUTE25
, PCX_ATTRIBUTE26 PCX_ATTRIBUTE26
, PCX_ATTRIBUTE27 PCX_ATTRIBUTE27
, PCX_ATTRIBUTE28 PCX_ATTRIBUTE28
, PCX_ATTRIBUTE29 PCX_ATTRIBUTE29
, PCX_ATTRIBUTE30 PCX_ATTRIBUTE30
, 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
, BNF_TYP_CD BNF_TYP_CD
, RLSHP_TYP_CD RLSHP_TYP_CD
, CTFN_RQD_WHEN_RL CTFN_RQD_WHEN_RL
FROM "BEN"."BEN_PL_BNF_CTFN_F"