VIEW: BEN.BEN_OPTIP_F#

Source

View Text - Preformatted

select OPTIP_ID OPTIP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PGM_ID PGM_ID, PTIP_ID PTIP_ID, PL_TYP_ID PL_TYP_ID, OPT_ID OPT_ID, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID, OTP_ATTRIBUTE_CATEGORY OTP_ATTRIBUTE_CATEGORY, OTP_ATTRIBUTE1 OTP_ATTRIBUTE1, OTP_ATTRIBUTE2 OTP_ATTRIBUTE2, OTP_ATTRIBUTE3 OTP_ATTRIBUTE3, OTP_ATTRIBUTE4 OTP_ATTRIBUTE4, OTP_ATTRIBUTE5 OTP_ATTRIBUTE5, OTP_ATTRIBUTE6 OTP_ATTRIBUTE6, OTP_ATTRIBUTE7 OTP_ATTRIBUTE7, OTP_ATTRIBUTE8 OTP_ATTRIBUTE8, OTP_ATTRIBUTE9 OTP_ATTRIBUTE9, OTP_ATTRIBUTE10 OTP_ATTRIBUTE10, OTP_ATTRIBUTE11 OTP_ATTRIBUTE11, OTP_ATTRIBUTE12 OTP_ATTRIBUTE12, OTP_ATTRIBUTE13 OTP_ATTRIBUTE13, OTP_ATTRIBUTE14 OTP_ATTRIBUTE14, OTP_ATTRIBUTE15 OTP_ATTRIBUTE15, OTP_ATTRIBUTE16 OTP_ATTRIBUTE16, OTP_ATTRIBUTE17 OTP_ATTRIBUTE17, OTP_ATTRIBUTE18 OTP_ATTRIBUTE18, OTP_ATTRIBUTE19 OTP_ATTRIBUTE19, OTP_ATTRIBUTE20 OTP_ATTRIBUTE20, OTP_ATTRIBUTE21 OTP_ATTRIBUTE21, OTP_ATTRIBUTE22 OTP_ATTRIBUTE22, OTP_ATTRIBUTE23 OTP_ATTRIBUTE23, OTP_ATTRIBUTE24 OTP_ATTRIBUTE24, OTP_ATTRIBUTE25 OTP_ATTRIBUTE25, OTP_ATTRIBUTE26 OTP_ATTRIBUTE26, OTP_ATTRIBUTE27 OTP_ATTRIBUTE27, OTP_ATTRIBUTE28 OTP_ATTRIBUTE28, OTP_ATTRIBUTE29 OTP_ATTRIBUTE29, OTP_ATTRIBUTE30 OTP_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_OPTIP_F"

View Text - HTML Formatted

SELECT OPTIP_ID OPTIP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PGM_ID PGM_ID
, PTIP_ID PTIP_ID
, PL_TYP_ID PL_TYP_ID
, OPT_ID OPT_ID
, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID
, OTP_ATTRIBUTE_CATEGORY OTP_ATTRIBUTE_CATEGORY
, OTP_ATTRIBUTE1 OTP_ATTRIBUTE1
, OTP_ATTRIBUTE2 OTP_ATTRIBUTE2
, OTP_ATTRIBUTE3 OTP_ATTRIBUTE3
, OTP_ATTRIBUTE4 OTP_ATTRIBUTE4
, OTP_ATTRIBUTE5 OTP_ATTRIBUTE5
, OTP_ATTRIBUTE6 OTP_ATTRIBUTE6
, OTP_ATTRIBUTE7 OTP_ATTRIBUTE7
, OTP_ATTRIBUTE8 OTP_ATTRIBUTE8
, OTP_ATTRIBUTE9 OTP_ATTRIBUTE9
, OTP_ATTRIBUTE10 OTP_ATTRIBUTE10
, OTP_ATTRIBUTE11 OTP_ATTRIBUTE11
, OTP_ATTRIBUTE12 OTP_ATTRIBUTE12
, OTP_ATTRIBUTE13 OTP_ATTRIBUTE13
, OTP_ATTRIBUTE14 OTP_ATTRIBUTE14
, OTP_ATTRIBUTE15 OTP_ATTRIBUTE15
, OTP_ATTRIBUTE16 OTP_ATTRIBUTE16
, OTP_ATTRIBUTE17 OTP_ATTRIBUTE17
, OTP_ATTRIBUTE18 OTP_ATTRIBUTE18
, OTP_ATTRIBUTE19 OTP_ATTRIBUTE19
, OTP_ATTRIBUTE20 OTP_ATTRIBUTE20
, OTP_ATTRIBUTE21 OTP_ATTRIBUTE21
, OTP_ATTRIBUTE22 OTP_ATTRIBUTE22
, OTP_ATTRIBUTE23 OTP_ATTRIBUTE23
, OTP_ATTRIBUTE24 OTP_ATTRIBUTE24
, OTP_ATTRIBUTE25 OTP_ATTRIBUTE25
, OTP_ATTRIBUTE26 OTP_ATTRIBUTE26
, OTP_ATTRIBUTE27 OTP_ATTRIBUTE27
, OTP_ATTRIBUTE28 OTP_ATTRIBUTE28
, OTP_ATTRIBUTE29 OTP_ATTRIBUTE29
, OTP_ATTRIBUTE30 OTP_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_OPTIP_F"