[Home] [Help]
View: BEN_PRMRY_CARE_PRVDR_D
View Text
SELECT DISTINCT PPR.ROWID ROW_ID
, PPR.PRMRY_CARE_PRVDR_ID
, PPR.EFFECTIVE_START_DATE
, PPR.EFFECTIVE_END_DATE
, PPR.NAME
, PPR.EXT_IDENT
, PRMRY_CARE_PRVDR_TYP.MEANING
, DECODE(PPR.PRTT_ENRT_RSLT_ID
, NULL
, DPNT_PL.NAME
, PL.NAME)
, PPR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PRMRY_CARE_PRVDR_F PPR
, FND_USER_VIEW FUSER
, BEN_PRTT_ENRT_RSLT_F PRTT_ENRT_RSLT
, BEN_ELIG_CVRD_DPNT_F ELIG_CVRD_DPNT
, BEN_PRTT_ENRT_RSLT_F DPNT_RSLT
, BEN_PL_F PL
, BEN_PL_F DPNT_PL
, HR_LOOKUPS PRMRY_CARE_PRVDR_TYP
WHERE FUSER.USER_ID (+)= PPR.LAST_UPDATED_BY
AND PRTT_ENRT_RSLT.PRTT_ENRT_RSLT_ID(+) = PPR.PRTT_ENRT_RSLT_ID
AND PRTT_ENRT_RSLT.PL_ID = PL.PL_ID(+)
AND ELIG_CVRD_DPNT.ELIG_CVRD_DPNT_ID(+) = PPR.ELIG_CVRD_DPNT_ID
AND ELIG_CVRD_DPNT.PRTT_ENRT_RSLT_ID = DPNT_RSLT.PRTT_ENRT_RSLT_ID(+)
AND DPNT_RSLT.PL_ID = DPNT_PL.PL_ID(+)
AND PRMRY_CARE_PRVDR_TYP.LOOKUP_CODE (+)= PPR.PRMRY_CARE_PRVDR_TYP_CD
AND PRMRY_CARE_PRVDR_TYP.LOOKUP_TYPE (+)= 'PRMRY_CARE_PRVDR_TYP'
Columns
Name |
ROW_ID |
PRMRY_CARE_PRVDR_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
NAME |
EXT_IDENT |
PRMRY_CARE_PRVDR_TYP_MEANING |
PLAN_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |