VIEW: BEN.BEN_PL_TYP_OPT_TYP_F#

Source

View Text - Preformatted

select PL_TYP_OPT_TYP_ID PL_TYP_OPT_TYP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PL_TYP_OPT_TYP_CD PL_TYP_OPT_TYP_CD, PL_TYP_ID PL_TYP_ID, OPT_ID OPT_ID, PON_ATTRIBUTE_CATEGORY PON_ATTRIBUTE_CATEGORY, PON_ATTRIBUTE1 PON_ATTRIBUTE1, PON_ATTRIBUTE2 PON_ATTRIBUTE2, PON_ATTRIBUTE3 PON_ATTRIBUTE3, PON_ATTRIBUTE4 PON_ATTRIBUTE4, PON_ATTRIBUTE5 PON_ATTRIBUTE5, PON_ATTRIBUTE6 PON_ATTRIBUTE6, PON_ATTRIBUTE7 PON_ATTRIBUTE7, PON_ATTRIBUTE8 PON_ATTRIBUTE8, PON_ATTRIBUTE9 PON_ATTRIBUTE9, PON_ATTRIBUTE10 PON_ATTRIBUTE10, PON_ATTRIBUTE11 PON_ATTRIBUTE11, PON_ATTRIBUTE12 PON_ATTRIBUTE12, PON_ATTRIBUTE13 PON_ATTRIBUTE13, PON_ATTRIBUTE14 PON_ATTRIBUTE14, PON_ATTRIBUTE15 PON_ATTRIBUTE15, PON_ATTRIBUTE16 PON_ATTRIBUTE16, PON_ATTRIBUTE17 PON_ATTRIBUTE17, PON_ATTRIBUTE18 PON_ATTRIBUTE18, PON_ATTRIBUTE19 PON_ATTRIBUTE19, PON_ATTRIBUTE20 PON_ATTRIBUTE20, PON_ATTRIBUTE21 PON_ATTRIBUTE21, PON_ATTRIBUTE22 PON_ATTRIBUTE22, PON_ATTRIBUTE23 PON_ATTRIBUTE23, PON_ATTRIBUTE24 PON_ATTRIBUTE24, PON_ATTRIBUTE25 PON_ATTRIBUTE25, PON_ATTRIBUTE26 PON_ATTRIBUTE26, PON_ATTRIBUTE27 PON_ATTRIBUTE27, PON_ATTRIBUTE28 PON_ATTRIBUTE28, PON_ATTRIBUTE29 PON_ATTRIBUTE29, PON_ATTRIBUTE30 PON_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, LEGISLATION_CODE LEGISLATION_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP from "BEN"."BEN_PL_TYP_OPT_TYP_F"

View Text - HTML Formatted

SELECT PL_TYP_OPT_TYP_ID PL_TYP_OPT_TYP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PL_TYP_OPT_TYP_CD PL_TYP_OPT_TYP_CD
, PL_TYP_ID PL_TYP_ID
, OPT_ID OPT_ID
, PON_ATTRIBUTE_CATEGORY PON_ATTRIBUTE_CATEGORY
, PON_ATTRIBUTE1 PON_ATTRIBUTE1
, PON_ATTRIBUTE2 PON_ATTRIBUTE2
, PON_ATTRIBUTE3 PON_ATTRIBUTE3
, PON_ATTRIBUTE4 PON_ATTRIBUTE4
, PON_ATTRIBUTE5 PON_ATTRIBUTE5
, PON_ATTRIBUTE6 PON_ATTRIBUTE6
, PON_ATTRIBUTE7 PON_ATTRIBUTE7
, PON_ATTRIBUTE8 PON_ATTRIBUTE8
, PON_ATTRIBUTE9 PON_ATTRIBUTE9
, PON_ATTRIBUTE10 PON_ATTRIBUTE10
, PON_ATTRIBUTE11 PON_ATTRIBUTE11
, PON_ATTRIBUTE12 PON_ATTRIBUTE12
, PON_ATTRIBUTE13 PON_ATTRIBUTE13
, PON_ATTRIBUTE14 PON_ATTRIBUTE14
, PON_ATTRIBUTE15 PON_ATTRIBUTE15
, PON_ATTRIBUTE16 PON_ATTRIBUTE16
, PON_ATTRIBUTE17 PON_ATTRIBUTE17
, PON_ATTRIBUTE18 PON_ATTRIBUTE18
, PON_ATTRIBUTE19 PON_ATTRIBUTE19
, PON_ATTRIBUTE20 PON_ATTRIBUTE20
, PON_ATTRIBUTE21 PON_ATTRIBUTE21
, PON_ATTRIBUTE22 PON_ATTRIBUTE22
, PON_ATTRIBUTE23 PON_ATTRIBUTE23
, PON_ATTRIBUTE24 PON_ATTRIBUTE24
, PON_ATTRIBUTE25 PON_ATTRIBUTE25
, PON_ATTRIBUTE26 PON_ATTRIBUTE26
, PON_ATTRIBUTE27 PON_ATTRIBUTE27
, PON_ATTRIBUTE28 PON_ATTRIBUTE28
, PON_ATTRIBUTE29 PON_ATTRIBUTE29
, PON_ATTRIBUTE30 PON_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
, LEGISLATION_CODE LEGISLATION_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
FROM "BEN"."BEN_PL_TYP_OPT_TYP_F"