BEN_PL_TYP_F_VL

Details

• Schema: FUSION

• Object owner: BEN

• Object type: VIEW

Columns

Name

PL_TYP_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE NAME MX_ENRL_ALWD_NUM MN_ENRL_RQD_NUM PL_TYP_STAT_CD OPT_TYP_CD IVR_IDENT NO_MX_ENRL_NUM_DFND_FLAG NO_MN_ENRL_NUM_DFND_FLAG BUSINESS_GROUP_ID PTP_ATTRIBUTE_CATEGORY PTP_ATTRIBUTE1 PTP_ATTRIBUTE2 PTP_ATTRIBUTE3 PTP_ATTRIBUTE4 PTP_ATTRIBUTE5 PTP_ATTRIBUTE6 PTP_ATTRIBUTE7 PTP_ATTRIBUTE8 PTP_ATTRIBUTE9 PTP_ATTRIBUTE10 PTP_ATTRIBUTE11 PTP_ATTRIBUTE12 PTP_ATTRIBUTE13 PTP_ATTRIBUTE14 PTP_ATTRIBUTE15 PTP_ATTRIBUTE16 PTP_ATTRIBUTE17 PTP_ATTRIBUTE18 PTP_ATTRIBUTE19 PTP_ATTRIBUTE20 PTP_ATTRIBUTE21 PTP_ATTRIBUTE22 PTP_ATTRIBUTE23 PTP_ATTRIBUTE24 PTP_ATTRIBUTE25 PTP_ATTRIBUTE26 PTP_ATTRIBUTE27 PTP_ATTRIBUTE28 PTP_ATTRIBUTE29 PTP_ATTRIBUTE30 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER OPT_DSPLY_FMT_CD COMP_TYP_CD SHORT_CODE SHORT_NAME LEGISLATION_CODE LEGISLATION_SUBGROUP GLOBAL_FLAG SS_CATEGORY_CD ADMIN_CATEGORY_CD PTP_ATTRIBUTE_NUMBER1 PTP_ATTRIBUTE_NUMBER2 PTP_ATTRIBUTE_NUMBER3 PTP_ATTRIBUTE_NUMBER4 PTP_ATTRIBUTE_NUMBER5 PTP_ATTRIBUTE_NUMBER6 PTP_ATTRIBUTE_NUMBER7 PTP_ATTRIBUTE_NUMBER8 PTP_ATTRIBUTE_NUMBER9 PTP_ATTRIBUTE_NUMBER10 PTP_ATTRIBUTE_NUMBER11 PTP_ATTRIBUTE_NUMBER12 PTP_ATTRIBUTE_NUMBER13 PTP_ATTRIBUTE_NUMBER14 PTP_ATTRIBUTE_NUMBER15 PTP_ATTRIBUTE_NUMBER16 PTP_ATTRIBUTE_NUMBER17 PTP_ATTRIBUTE_NUMBER18 PTP_ATTRIBUTE_NUMBER19 PTP_ATTRIBUTE_NUMBER20 PTP_ATTRIBUTE_DATE1 PTP_ATTRIBUTE_DATE2 PTP_ATTRIBUTE_DATE3 PTP_ATTRIBUTE_DATE4 PTP_ATTRIBUTE_DATE5 PTP_ATTRIBUTE_DATE6 PTP_ATTRIBUTE_DATE7 PTP_ATTRIBUTE_DATE8 PTP_ATTRIBUTE_DATE9 PTP_ATTRIBUTE_DATE10 PTP_ATTRIBUTE_DATE11 PTP_ATTRIBUTE_DATE12 PTP_ATTRIBUTE_DATE13 PTP_ATTRIBUTE_DATE14 PTP_ATTRIBUTE_DATE15 CARRIER_PLAN_TYPE_NAME

Query

SQL_Statement

SELECT PLTYP.PL_TYP_ID, PLTYP.EFFECTIVE_START_DATE, PLTYP.EFFECTIVE_END_DATE, NVL(TL.NAME, PLTYP.NAME) NAME, PLTYP.MX_ENRL_ALWD_NUM, PLTYP.MN_ENRL_RQD_NUM, PLTYP.PL_TYP_STAT_CD, PLTYP.OPT_TYP_CD, PLTYP.IVR_IDENT, PLTYP.NO_MX_ENRL_NUM_DFND_FLAG, PLTYP.NO_MN_ENRL_NUM_DFND_FLAG, PLTYP.BUSINESS_GROUP_ID, PLTYP.PTP_ATTRIBUTE_CATEGORY, PLTYP.PTP_ATTRIBUTE1, PLTYP.PTP_ATTRIBUTE2, PLTYP.PTP_ATTRIBUTE3, PLTYP.PTP_ATTRIBUTE4, PLTYP.PTP_ATTRIBUTE5, PLTYP.PTP_ATTRIBUTE6, PLTYP.PTP_ATTRIBUTE7, PLTYP.PTP_ATTRIBUTE8, PLTYP.PTP_ATTRIBUTE9, PLTYP.PTP_ATTRIBUTE10, PLTYP.PTP_ATTRIBUTE11, PLTYP.PTP_ATTRIBUTE12, PLTYP.PTP_ATTRIBUTE13, PLTYP.PTP_ATTRIBUTE14, PLTYP.PTP_ATTRIBUTE15, PLTYP.PTP_ATTRIBUTE16, PLTYP.PTP_ATTRIBUTE17, PLTYP.PTP_ATTRIBUTE18, PLTYP.PTP_ATTRIBUTE19, PLTYP.PTP_ATTRIBUTE20, PLTYP.PTP_ATTRIBUTE21, PLTYP.PTP_ATTRIBUTE22, PLTYP.PTP_ATTRIBUTE23, PLTYP.PTP_ATTRIBUTE24, PLTYP.PTP_ATTRIBUTE25, PLTYP.PTP_ATTRIBUTE26, PLTYP.PTP_ATTRIBUTE27, PLTYP.PTP_ATTRIBUTE28, PLTYP.PTP_ATTRIBUTE29, PLTYP.PTP_ATTRIBUTE30, PLTYP.LAST_UPDATE_DATE, PLTYP.LAST_UPDATED_BY, PLTYP.LAST_UPDATE_LOGIN, PLTYP.CREATED_BY, PLTYP.CREATION_DATE, PLTYP.OBJECT_VERSION_NUMBER, PLTYP.OPT_DSPLY_FMT_CD, PLTYP.COMP_TYP_CD, PLTYP.SHORT_CODE, PLTYP.SHORT_NAME, PLTYP.LEGISLATION_CODE, PLTYP.LEGISLATION_SUBGROUP, PLTYP.GLOBAL_FLAG, PLTYP.SS_CATEGORY_CD, PLTYP.ADMIN_CATEGORY_CD, PLTYP.PTP_ATTRIBUTE_NUMBER1, PLTYP.PTP_ATTRIBUTE_NUMBER2, PLTYP.PTP_ATTRIBUTE_NUMBER3, PLTYP.PTP_ATTRIBUTE_NUMBER4, PLTYP.PTP_ATTRIBUTE_NUMBER5, PLTYP.PTP_ATTRIBUTE_NUMBER6, PLTYP.PTP_ATTRIBUTE_NUMBER7, PLTYP.PTP_ATTRIBUTE_NUMBER8, PLTYP.PTP_ATTRIBUTE_NUMBER9, PLTYP.PTP_ATTRIBUTE_NUMBER10, PLTYP.PTP_ATTRIBUTE_NUMBER11, PLTYP.PTP_ATTRIBUTE_NUMBER12, PLTYP.PTP_ATTRIBUTE_NUMBER13, PLTYP.PTP_ATTRIBUTE_NUMBER14, PLTYP.PTP_ATTRIBUTE_NUMBER15, PLTYP.PTP_ATTRIBUTE_NUMBER16, PLTYP.PTP_ATTRIBUTE_NUMBER17, PLTYP.PTP_ATTRIBUTE_NUMBER18, PLTYP.PTP_ATTRIBUTE_NUMBER19, PLTYP.PTP_ATTRIBUTE_NUMBER20, PLTYP.PTP_ATTRIBUTE_DATE1, PLTYP.PTP_ATTRIBUTE_DATE2, PLTYP.PTP_ATTRIBUTE_DATE3, PLTYP.PTP_ATTRIBUTE_DATE4, PLTYP.PTP_ATTRIBUTE_DATE5, PLTYP.PTP_ATTRIBUTE_DATE6, PLTYP.PTP_ATTRIBUTE_DATE7, PLTYP.PTP_ATTRIBUTE_DATE8, PLTYP.PTP_ATTRIBUTE_DATE9, PLTYP.PTP_ATTRIBUTE_DATE10, PLTYP.PTP_ATTRIBUTE_DATE11, PLTYP.PTP_ATTRIBUTE_DATE12, PLTYP.PTP_ATTRIBUTE_DATE13, PLTYP.PTP_ATTRIBUTE_DATE14, PLTYP.PTP_ATTRIBUTE_DATE15, PLTYP.CARRIER_PLAN_TYPE_NAME FROM BEN_PL_TYP_F PLTYP, BEN_PL_TYP_F_TL TL WHERE PLTYP.PL_TYP_ID = TL.PL_TYP_ID(+) AND PLTYP.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE(+) AND TL.LANGUAGE(+) = USERENV('LANG')