BEN_OIPL_F

Details

Schema: FUSION
Object owner: BEN
Object type: VIEW

Columns

Name
OIPL_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE IVR_IDENT ORDR_NUM MNDTRY_FLAG DFLT_FLAG OIPL_STAT_CD ELIG_APLS_FLAG DFLT_ENRT_DET_RL TRK_INELIG_PER_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG MNDTRY_RL DFLT_ENRT_CD PRTN_ELIG_OVRID_ALWD_FLAG DRVBL_FCTR_APLS_RTS_FLAG PER_CVRD_CD POSTELCN_EDIT_RL VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_RL AUTO_ENRT_FLAG AUTO_ENRT_MTHD_RL COP_AUTO_ENRT_FLAG RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_RL OPT_ID PL_ID ACTL_PREM_ID BUSINESS_GROUP_ID COP_ATTRIBUTE_CATEGORY COP_ATTRIBUTE1 COP_ATTRIBUTE2 COP_ATTRIBUTE3 COP_ATTRIBUTE4 COP_ATTRIBUTE5 COP_ATTRIBUTE6 COP_ATTRIBUTE7 COP_ATTRIBUTE8 COP_ATTRIBUTE9 COP_ATTRIBUTE10 COP_ATTRIBUTE11 COP_ATTRIBUTE12 COP_ATTRIBUTE13 COP_ATTRIBUTE14 COP_ATTRIBUTE15 COP_ATTRIBUTE16 COP_ATTRIBUTE17 COP_ATTRIBUTE18 COP_ATTRIBUTE19 COP_ATTRIBUTE20 COP_ATTRIBUTE21 COP_ATTRIBUTE22 COP_ATTRIBUTE23 COP_ATTRIBUTE24 COP_ATTRIBUTE25 COP_ATTRIBUTE26 COP_ATTRIBUTE27 COP_ATTRIBUTE28 COP_ATTRIBUTE29 COP_ATTRIBUTE30 COP_ATTRIBUTE_NUMBER1 COP_ATTRIBUTE_NUMBER2 COP_ATTRIBUTE_NUMBER3 COP_ATTRIBUTE_NUMBER4 COP_ATTRIBUTE_NUMBER5 COP_ATTRIBUTE_NUMBER6 COP_ATTRIBUTE_NUMBER7 COP_ATTRIBUTE_NUMBER8 COP_ATTRIBUTE_NUMBER9 COP_ATTRIBUTE_NUMBER10 COP_ATTRIBUTE_NUMBER11 COP_ATTRIBUTE_NUMBER12 COP_ATTRIBUTE_NUMBER13 COP_ATTRIBUTE_NUMBER14 COP_ATTRIBUTE_NUMBER15 COP_ATTRIBUTE_NUMBER16 COP_ATTRIBUTE_NUMBER17 COP_ATTRIBUTE_NUMBER18 COP_ATTRIBUTE_NUMBER19 COP_ATTRIBUTE_NUMBER20 COP_ATTRIBUTE_DATE1 COP_ATTRIBUTE_DATE2 COP_ATTRIBUTE_DATE3 COP_ATTRIBUTE_DATE4 COP_ATTRIBUTE_DATE5 COP_ATTRIBUTE_DATE6 COP_ATTRIBUTE_DATE7 COP_ATTRIBUTE_DATE8 COP_ATTRIBUTE_DATE9 COP_ATTRIBUTE_DATE10 COP_ATTRIBUTE_DATE11 COP_ATTRIBUTE_DATE12 COP_ATTRIBUTE_DATE13 COP_ATTRIBUTE_DATE14 COP_ATTRIBUTE_DATE15 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER URL_REF_NAME ENRT_CD ENRT_RL PCP_DSGN_CD PCP_DPNT_DSGN_CD SHORT_CODE SHORT_NAME HIDDEN_FLAG LEGISLATION_CODE LEGISLATION_SUBGROUP SUSP_IF_CTFN_NOT_PRVD_FLAG DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_RL UNSSPND_ENRT_CD UNSSPND_ENRT_RL UNSSPND_RT_CD UNSSPND_RT_RL CONFIG_NUM_1 CONFIG_NUM_2 CONFIG_NUM_3 CONFIG_NUM_4 CONFIG_NUM_5 CONFIG_CHAR_1 CONFIG_CHAR_2 CONFIG_CHAR_3 CONFIG_CHAR_4 CONFIG_CHAR_5 CONFIG_DATE_1 CONFIG_DATE_2 CONFIG_DATE_3 CONFIG_DATE_4 CONFIG_DATE_5

Name

OIPL_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

IVR_IDENT

ORDR_NUM

MNDTRY_FLAG

DFLT_FLAG

OIPL_STAT_CD

ELIG_APLS_FLAG

DFLT_ENRT_DET_RL

TRK_INELIG_PER_FLAG

DRVBL_FCTR_PRTN_ELIG_FLAG

MNDTRY_RL

DFLT_ENRT_CD

PRTN_ELIG_OVRID_ALWD_FLAG

DRVBL_FCTR_APLS_RTS_FLAG

PER_CVRD_CD

POSTELCN_EDIT_RL

VRFY_FMLY_MMBR_CD

VRFY_FMLY_MMBR_RL

AUTO_ENRT_FLAG

AUTO_ENRT_MTHD_RL

COP_AUTO_ENRT_FLAG

RQD_PERD_ENRT_NENRT_UOM

RQD_PERD_ENRT_NENRT_VAL

RQD_PERD_ENRT_NENRT_RL

OPT_ID

PL_ID

ACTL_PREM_ID

BUSINESS_GROUP_ID

COP_ATTRIBUTE_CATEGORY

COP_ATTRIBUTE1

COP_ATTRIBUTE2

COP_ATTRIBUTE3

COP_ATTRIBUTE4

COP_ATTRIBUTE5

COP_ATTRIBUTE6

COP_ATTRIBUTE7

COP_ATTRIBUTE8

COP_ATTRIBUTE9

COP_ATTRIBUTE10

COP_ATTRIBUTE11

COP_ATTRIBUTE12

COP_ATTRIBUTE13

COP_ATTRIBUTE14

COP_ATTRIBUTE15

COP_ATTRIBUTE16

COP_ATTRIBUTE17

COP_ATTRIBUTE18

COP_ATTRIBUTE19

COP_ATTRIBUTE20

COP_ATTRIBUTE21

COP_ATTRIBUTE22

COP_ATTRIBUTE23

COP_ATTRIBUTE24

COP_ATTRIBUTE25

COP_ATTRIBUTE26

COP_ATTRIBUTE27

COP_ATTRIBUTE28

COP_ATTRIBUTE29

COP_ATTRIBUTE30

COP_ATTRIBUTE_NUMBER1

COP_ATTRIBUTE_NUMBER2

COP_ATTRIBUTE_NUMBER3

COP_ATTRIBUTE_NUMBER4

COP_ATTRIBUTE_NUMBER5

COP_ATTRIBUTE_NUMBER6

COP_ATTRIBUTE_NUMBER7

COP_ATTRIBUTE_NUMBER8

COP_ATTRIBUTE_NUMBER9

COP_ATTRIBUTE_NUMBER10

COP_ATTRIBUTE_NUMBER11

COP_ATTRIBUTE_NUMBER12

COP_ATTRIBUTE_NUMBER13

COP_ATTRIBUTE_NUMBER14

COP_ATTRIBUTE_NUMBER15

COP_ATTRIBUTE_NUMBER16

COP_ATTRIBUTE_NUMBER17

COP_ATTRIBUTE_NUMBER18

COP_ATTRIBUTE_NUMBER19

COP_ATTRIBUTE_NUMBER20

COP_ATTRIBUTE_DATE1

COP_ATTRIBUTE_DATE2

COP_ATTRIBUTE_DATE3

COP_ATTRIBUTE_DATE4

COP_ATTRIBUTE_DATE5

COP_ATTRIBUTE_DATE6

COP_ATTRIBUTE_DATE7

COP_ATTRIBUTE_DATE8

COP_ATTRIBUTE_DATE9

COP_ATTRIBUTE_DATE10

COP_ATTRIBUTE_DATE11

COP_ATTRIBUTE_DATE12

COP_ATTRIBUTE_DATE13

COP_ATTRIBUTE_DATE14

COP_ATTRIBUTE_DATE15

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

URL_REF_NAME

ENRT_CD

ENRT_RL

PCP_DSGN_CD

PCP_DPNT_DSGN_CD

SHORT_CODE

SHORT_NAME

HIDDEN_FLAG

LEGISLATION_CODE

LEGISLATION_SUBGROUP

SUSP_IF_CTFN_NOT_PRVD_FLAG

DFLT_TO_ASN_PNDG_CTFN_CD

DFLT_TO_ASN_PNDG_CTFN_RL

UNSSPND_ENRT_CD

UNSSPND_ENRT_RL

UNSSPND_RT_CD

UNSSPND_RT_RL

CONFIG_NUM_1

CONFIG_NUM_2

CONFIG_NUM_3

CONFIG_NUM_4

CONFIG_NUM_5

CONFIG_CHAR_1

CONFIG_CHAR_2

CONFIG_CHAR_3

CONFIG_CHAR_4

CONFIG_CHAR_5

CONFIG_DATE_1

CONFIG_DATE_2

CONFIG_DATE_3

CONFIG_DATE_4

CONFIG_DATE_5

Query

SQL_Statement
SELECT OIPL.OIPL_ID, OIPL.EFFECTIVE_START_DATE, OIPL.EFFECTIVE_END_DATE, OIPL.IVR_IDENT, OIPL.ORDR_NUM, OIPL.MNDTRY_FLAG, OIPL.DFLT_FLAG, OIPL.OIPL_STAT_CD, OIPL.ELIG_APLS_FLAG, OIPL.DFLT_ENRT_DET_RL, OIPL.TRK_INELIG_PER_FLAG, OIPL.DRVBL_FCTR_PRTN_ELIG_FLAG, OIPL.MNDTRY_RL, OIPL.DFLT_ENRT_CD, OIPL.PRTN_ELIG_OVRID_ALWD_FLAG, OIPL.DRVBL_FCTR_APLS_RTS_FLAG, OIPL.PER_CVRD_CD, OIPL.POSTELCN_EDIT_RL, OIPL.VRFY_FMLY_MMBR_CD, OIPL.VRFY_FMLY_MMBR_RL, OIPL.AUTO_ENRT_FLAG, OIPL.AUTO_ENRT_MTHD_RL, OIPL.COP_AUTO_ENRT_FLAG, OIPL.RQD_PERD_ENRT_NENRT_UOM, OIPL.RQD_PERD_ENRT_NENRT_VAL, OIPL.RQD_PERD_ENRT_NENRT_RL, OIPL.OPT_ID, OIPL.PL_ID, OIPL.ACTL_PREM_ID, OIPL.BUSINESS_GROUP_ID, OIPL.COP_ATTRIBUTE_CATEGORY, OIPL.COP_ATTRIBUTE1, OIPL.COP_ATTRIBUTE2, OIPL.COP_ATTRIBUTE3, OIPL.COP_ATTRIBUTE4, OIPL.COP_ATTRIBUTE5, OIPL.COP_ATTRIBUTE6, OIPL.COP_ATTRIBUTE7, OIPL.COP_ATTRIBUTE8, OIPL.COP_ATTRIBUTE9, OIPL.COP_ATTRIBUTE10, OIPL.COP_ATTRIBUTE11, OIPL.COP_ATTRIBUTE12, OIPL.COP_ATTRIBUTE13, OIPL.COP_ATTRIBUTE14, OIPL.COP_ATTRIBUTE15, OIPL.COP_ATTRIBUTE16, OIPL.COP_ATTRIBUTE17, OIPL.COP_ATTRIBUTE18, OIPL.COP_ATTRIBUTE19, OIPL.COP_ATTRIBUTE20, OIPL.COP_ATTRIBUTE21, OIPL.COP_ATTRIBUTE22, OIPL.COP_ATTRIBUTE23, OIPL.COP_ATTRIBUTE24, OIPL.COP_ATTRIBUTE25, OIPL.COP_ATTRIBUTE26, OIPL.COP_ATTRIBUTE27, OIPL.COP_ATTRIBUTE28, OIPL.COP_ATTRIBUTE29, OIPL.COP_ATTRIBUTE30, OIPL.COP_ATTRIBUTE_NUMBER1, OIPL.COP_ATTRIBUTE_NUMBER2, OIPL.COP_ATTRIBUTE_NUMBER3, OIPL.COP_ATTRIBUTE_NUMBER4, OIPL.COP_ATTRIBUTE_NUMBER5, OIPL.COP_ATTRIBUTE_NUMBER6, OIPL.COP_ATTRIBUTE_NUMBER7, OIPL.COP_ATTRIBUTE_NUMBER8, OIPL.COP_ATTRIBUTE_NUMBER9, OIPL.COP_ATTRIBUTE_NUMBER10, OIPL.COP_ATTRIBUTE_NUMBER11, OIPL.COP_ATTRIBUTE_NUMBER12, OIPL.COP_ATTRIBUTE_NUMBER13, OIPL.COP_ATTRIBUTE_NUMBER14, OIPL.COP_ATTRIBUTE_NUMBER15, OIPL.COP_ATTRIBUTE_NUMBER16, OIPL.COP_ATTRIBUTE_NUMBER17, OIPL.COP_ATTRIBUTE_NUMBER18, OIPL.COP_ATTRIBUTE_NUMBER19, OIPL.COP_ATTRIBUTE_NUMBER20, OIPL.COP_ATTRIBUTE_DATE1, OIPL.COP_ATTRIBUTE_DATE2, OIPL.COP_ATTRIBUTE_DATE3, OIPL.COP_ATTRIBUTE_DATE4, OIPL.COP_ATTRIBUTE_DATE5, OIPL.COP_ATTRIBUTE_DATE6, OIPL.COP_ATTRIBUTE_DATE7, OIPL.COP_ATTRIBUTE_DATE8, OIPL.COP_ATTRIBUTE_DATE9, OIPL.COP_ATTRIBUTE_DATE10, OIPL.COP_ATTRIBUTE_DATE11, OIPL.COP_ATTRIBUTE_DATE12, OIPL.COP_ATTRIBUTE_DATE13, OIPL.COP_ATTRIBUTE_DATE14, OIPL.COP_ATTRIBUTE_DATE15, OIPL.LAST_UPDATE_DATE, OIPL.LAST_UPDATED_BY, OIPL.LAST_UPDATE_LOGIN, OIPL.CREATED_BY, OIPL.CREATION_DATE, OIPL.OBJECT_VERSION_NUMBER, OIPL.URL_REF_NAME, OIPL.ENRT_CD, OIPL.ENRT_RL, OIPL.PCP_DSGN_CD, OIPL.PCP_DPNT_DSGN_CD, OIPL.SHORT_CODE, OIPL.SHORT_NAME, OIPL.HIDDEN_FLAG, OIPL.LEGISLATION_CODE, OIPL.LEGISLATION_SUBGROUP, OIPL.SUSP_IF_CTFN_NOT_PRVD_FLAG, OIPL.DFLT_TO_ASN_PNDG_CTFN_CD, OIPL.DFLT_TO_ASN_PNDG_CTFN_RL, OIPL.UNSSPND_ENRT_CD, OIPL.UNSSPND_ENRT_RL, OIPL.UNSSPND_RT_CD, OIPL.UNSSPND_RT_RL, OIPL.CONFIG_NUM_1, OIPL.CONFIG_NUM_2, OIPL.CONFIG_NUM_3, OIPL.CONFIG_NUM_4, OIPL.CONFIG_NUM_5, OIPL.CONFIG_CHAR_1, NVL(TL.CONFIG_CHAR_2,OIPL.CONFIG_CHAR_2) CONFIG_CHAR_2, OIPL.CONFIG_CHAR_3, OIPL.CONFIG_CHAR_4, OIPL.CONFIG_CHAR_5, OIPL.CONFIG_DATE_1, OIPL.CONFIG_DATE_2, OIPL.CONFIG_DATE_3, OIPL.CONFIG_DATE_4, OIPL.CONFIG_DATE_5 FROM BEN_OIPL_F OIPL ,BEN_OIPL_F_TL TL WHERE OIPL.OIPL_ID = TL.OIPL_ID (+) AND OIPL.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE (+) AND TL.LANGUAGE (+) = USERENV('LANG')

SQL_Statement

SELECT

OIPL.OIPL_ID,

OIPL.EFFECTIVE_START_DATE,

OIPL.EFFECTIVE_END_DATE,

OIPL.IVR_IDENT,

OIPL.ORDR_NUM,

OIPL.MNDTRY_FLAG,

OIPL.DFLT_FLAG,

OIPL.OIPL_STAT_CD,

OIPL.ELIG_APLS_FLAG,

OIPL.DFLT_ENRT_DET_RL,

OIPL.TRK_INELIG_PER_FLAG,

OIPL.DRVBL_FCTR_PRTN_ELIG_FLAG,

OIPL.MNDTRY_RL,

OIPL.DFLT_ENRT_CD,

OIPL.PRTN_ELIG_OVRID_ALWD_FLAG,

OIPL.DRVBL_FCTR_APLS_RTS_FLAG,

OIPL.PER_CVRD_CD,

OIPL.POSTELCN_EDIT_RL,

OIPL.VRFY_FMLY_MMBR_CD,

OIPL.VRFY_FMLY_MMBR_RL,

OIPL.AUTO_ENRT_FLAG,

OIPL.AUTO_ENRT_MTHD_RL,

OIPL.COP_AUTO_ENRT_FLAG,

OIPL.RQD_PERD_ENRT_NENRT_UOM,

OIPL.RQD_PERD_ENRT_NENRT_VAL,

OIPL.RQD_PERD_ENRT_NENRT_RL,

OIPL.OPT_ID,

OIPL.PL_ID,

OIPL.ACTL_PREM_ID,

OIPL.BUSINESS_GROUP_ID,

OIPL.COP_ATTRIBUTE_CATEGORY,

OIPL.COP_ATTRIBUTE1,

OIPL.COP_ATTRIBUTE2,

OIPL.COP_ATTRIBUTE3,

OIPL.COP_ATTRIBUTE4,

OIPL.COP_ATTRIBUTE5,

OIPL.COP_ATTRIBUTE6,

OIPL.COP_ATTRIBUTE7,

OIPL.COP_ATTRIBUTE8,

OIPL.COP_ATTRIBUTE9,

OIPL.COP_ATTRIBUTE10,

OIPL.COP_ATTRIBUTE11,

OIPL.COP_ATTRIBUTE12,

OIPL.COP_ATTRIBUTE13,

OIPL.COP_ATTRIBUTE14,

OIPL.COP_ATTRIBUTE15,

OIPL.COP_ATTRIBUTE16,

OIPL.COP_ATTRIBUTE17,

OIPL.COP_ATTRIBUTE18,

OIPL.COP_ATTRIBUTE19,

OIPL.COP_ATTRIBUTE20,

OIPL.COP_ATTRIBUTE21,

OIPL.COP_ATTRIBUTE22,

OIPL.COP_ATTRIBUTE23,

OIPL.COP_ATTRIBUTE24,

OIPL.COP_ATTRIBUTE25,

OIPL.COP_ATTRIBUTE26,

OIPL.COP_ATTRIBUTE27,

OIPL.COP_ATTRIBUTE28,

OIPL.COP_ATTRIBUTE29,

OIPL.COP_ATTRIBUTE30,

OIPL.COP_ATTRIBUTE_NUMBER1,

OIPL.COP_ATTRIBUTE_NUMBER2,

OIPL.COP_ATTRIBUTE_NUMBER3,

OIPL.COP_ATTRIBUTE_NUMBER4,

OIPL.COP_ATTRIBUTE_NUMBER5,

OIPL.COP_ATTRIBUTE_NUMBER6,

OIPL.COP_ATTRIBUTE_NUMBER7,

OIPL.COP_ATTRIBUTE_NUMBER8,

OIPL.COP_ATTRIBUTE_NUMBER9,

OIPL.COP_ATTRIBUTE_NUMBER10,

OIPL.COP_ATTRIBUTE_NUMBER11,

OIPL.COP_ATTRIBUTE_NUMBER12,

OIPL.COP_ATTRIBUTE_NUMBER13,

OIPL.COP_ATTRIBUTE_NUMBER14,

OIPL.COP_ATTRIBUTE_NUMBER15,

OIPL.COP_ATTRIBUTE_NUMBER16,

OIPL.COP_ATTRIBUTE_NUMBER17,

OIPL.COP_ATTRIBUTE_NUMBER18,

OIPL.COP_ATTRIBUTE_NUMBER19,

OIPL.COP_ATTRIBUTE_NUMBER20,

OIPL.COP_ATTRIBUTE_DATE1,

OIPL.COP_ATTRIBUTE_DATE2,

OIPL.COP_ATTRIBUTE_DATE3,

OIPL.COP_ATTRIBUTE_DATE4,

OIPL.COP_ATTRIBUTE_DATE5,

OIPL.COP_ATTRIBUTE_DATE6,

OIPL.COP_ATTRIBUTE_DATE7,

OIPL.COP_ATTRIBUTE_DATE8,

OIPL.COP_ATTRIBUTE_DATE9,

OIPL.COP_ATTRIBUTE_DATE10,

OIPL.COP_ATTRIBUTE_DATE11,

OIPL.COP_ATTRIBUTE_DATE12,

OIPL.COP_ATTRIBUTE_DATE13,

OIPL.COP_ATTRIBUTE_DATE14,

OIPL.COP_ATTRIBUTE_DATE15,

OIPL.LAST_UPDATE_DATE,

OIPL.LAST_UPDATED_BY,

OIPL.LAST_UPDATE_LOGIN,

OIPL.CREATED_BY,

OIPL.CREATION_DATE,

OIPL.OBJECT_VERSION_NUMBER,

OIPL.URL_REF_NAME,

OIPL.ENRT_CD,

OIPL.ENRT_RL,

OIPL.PCP_DSGN_CD,

OIPL.PCP_DPNT_DSGN_CD,

OIPL.SHORT_CODE,

OIPL.SHORT_NAME,

OIPL.HIDDEN_FLAG,

OIPL.LEGISLATION_CODE,

OIPL.LEGISLATION_SUBGROUP,

OIPL.SUSP_IF_CTFN_NOT_PRVD_FLAG,

OIPL.DFLT_TO_ASN_PNDG_CTFN_CD,

OIPL.DFLT_TO_ASN_PNDG_CTFN_RL,

OIPL.UNSSPND_ENRT_CD,

OIPL.UNSSPND_ENRT_RL,

OIPL.UNSSPND_RT_CD,

OIPL.UNSSPND_RT_RL,

OIPL.CONFIG_NUM_1,

OIPL.CONFIG_NUM_2,

OIPL.CONFIG_NUM_3,

OIPL.CONFIG_NUM_4,

OIPL.CONFIG_NUM_5,

OIPL.CONFIG_CHAR_1,

NVL(TL.CONFIG_CHAR_2,OIPL.CONFIG_CHAR_2) CONFIG_CHAR_2,

OIPL.CONFIG_CHAR_3,

OIPL.CONFIG_CHAR_4,

OIPL.CONFIG_CHAR_5,

OIPL.CONFIG_DATE_1,

OIPL.CONFIG_DATE_2,

OIPL.CONFIG_DATE_3,

OIPL.CONFIG_DATE_4,

OIPL.CONFIG_DATE_5

FROM BEN_OIPL_F OIPL

,BEN_OIPL_F_TL TL

WHERE OIPL.OIPL_ID = TL.OIPL_ID (+)

AND OIPL.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE (+)

AND TL.LANGUAGE (+) = USERENV('LANG')