VIEW: APPS.BEN_DSGN_RQMT_D

Source

View Text - Preformatted

SELECT DDR.ROWID ROW_ID , DDR.DSGN_RQMT_ID , DDR.EFFECTIVE_START_DATE , DDR.EFFECTIVE_END_DATE , DDR.MN_DPNTS_RQD_NUM , DDR.MX_DPNTS_ALWD_NUM , NO_MN_NUM_DFND.MEANING , NO_MX_NUM_DFND.MEANING , CVR_ALL_ELIG.MEANING , OPT2.NAME , PL.NAME , OPT.NAME , GRP_RLSHP.MEANING , DSGN_TYP.MEANING , DDR.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_DSGN_RQMT_F DDR, FND_USER FUSER ,BEN_OIPL_F OIPL ,BEN_PL_F PL ,BEN_OPT_F OPT ,BEN_OPT_F OPT2 ,HR_LOOKUPS GRP_RLSHP ,HR_LOOKUPS DSGN_TYP ,HR_LOOKUPS NO_MN_NUM_DFND ,HR_LOOKUPS NO_MX_NUM_DFND ,HR_LOOKUPS CVR_ALL_ELIG WHERE FUSER.USER_ID (+)= DDR .LAST_UPDATED_BY AND OIPL.OIPL_ID (+)= DDR .OIPL_ID AND OIPL.OPT_ID = OPT2.OPT_ID(+) AND PL.PL_ID (+)= DDR .PL_ID AND OPT.OPT_ID (+)= DDR .OPT_ID AND GRP_RLSHP.LOOKUP_CODE (+)= DDR .GRP_RLSHP_CD AND GRP_RLSHP.LOOKUP_TYPE (+)= 'BEN_GRP_RLSHP' AND DSGN_TYP.LOOKUP_CODE (+)= DDR .DSGN_TYP_CD AND DSGN_TYP.LOOKUP_TYPE (+)= 'BEN_DSGN_TYP' AND NO_MN_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MN_NUM_DFND_FLAG AND NO_MN_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MX_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MX_NUM_DFND_FLAG AND NO_MX_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO' AND CVR_ALL_ELIG.LOOKUP_CODE (+)= DDR .CVR_ALL_ELIG_FLAG AND CVR_ALL_ELIG.LOOKUP_TYPE (+)= 'YES_NO'

View Text - HTML Formatted

SELECT DDR.ROWID ROW_ID
, DDR.DSGN_RQMT_ID
, DDR.EFFECTIVE_START_DATE
, DDR.EFFECTIVE_END_DATE
, DDR.MN_DPNTS_RQD_NUM
, DDR.MX_DPNTS_ALWD_NUM
, NO_MN_NUM_DFND.MEANING
, NO_MX_NUM_DFND.MEANING
, CVR_ALL_ELIG.MEANING
, OPT2.NAME
, PL.NAME
, OPT.NAME
, GRP_RLSHP.MEANING
, DSGN_TYP.MEANING
, DDR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_DSGN_RQMT_F DDR
, FND_USER FUSER
, BEN_OIPL_F OIPL
, BEN_PL_F PL
, BEN_OPT_F OPT
, BEN_OPT_F OPT2
, HR_LOOKUPS GRP_RLSHP
, HR_LOOKUPS DSGN_TYP
, HR_LOOKUPS NO_MN_NUM_DFND
, HR_LOOKUPS NO_MX_NUM_DFND
, HR_LOOKUPS CVR_ALL_ELIG
WHERE FUSER.USER_ID (+)= DDR .LAST_UPDATED_BY
AND OIPL.OIPL_ID (+)= DDR .OIPL_ID
AND OIPL.OPT_ID = OPT2.OPT_ID(+)
AND PL.PL_ID (+)= DDR .PL_ID
AND OPT.OPT_ID (+)= DDR .OPT_ID
AND GRP_RLSHP.LOOKUP_CODE (+)= DDR .GRP_RLSHP_CD
AND GRP_RLSHP.LOOKUP_TYPE (+)= 'BEN_GRP_RLSHP'
AND DSGN_TYP.LOOKUP_CODE (+)= DDR .DSGN_TYP_CD
AND DSGN_TYP.LOOKUP_TYPE (+)= 'BEN_DSGN_TYP'
AND NO_MN_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MN_NUM_DFND_FLAG
AND NO_MN_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_NUM_DFND.LOOKUP_CODE (+)= DDR .NO_MX_NUM_DFND_FLAG
AND NO_MX_NUM_DFND.LOOKUP_TYPE (+)= 'YES_NO'
AND CVR_ALL_ELIG.LOOKUP_CODE (+)= DDR .CVR_ALL_ELIG_FLAG
AND CVR_ALL_ELIG.LOOKUP_TYPE (+)= 'YES_NO'