VIEW: APPS.BEN_PSTL_ZIP_RT_D

Source

View Text - Preformatted

SELECT PZR.PSTL_ZIP_RT_ID , PZR.EFFECTIVE_START_DATE , PZR.EFFECTIVE_END_DATE , PZR.EXCLD_FLAG , PZR.ORDR_NUM , PRNG.FROM_VALUE||'-'||PRNG.TO_VALUE , VPR.NAME , PZR.LAST_UPDATE_DATE , FUSER.USER_NAME FROM BEN_PSTL_ZIP_RT_F PZR ,FND_USER FUSER ,BEN_PSTL_ZIP_RNG_F PRNG ,BEN_VRBL_RT_PRFL_F VPR WHERE FUSER.USER_ID (+) = PZR.LAST_UPDATED_BY AND PRNG.PSTL_ZIP_RNG_ID = PZR.PSTL_ZIP_RNG_ID AND PZR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID AND pzr.effective_start_date BETWEEN prng.effective_start_date (+) and prng.effective_end_date(+) AND pzr.effective_start_date BETWEEN vpr.effective_start_date (+) and vpr.effective_end_date(+)

View Text - HTML Formatted

SELECT PZR.PSTL_ZIP_RT_ID
, PZR.EFFECTIVE_START_DATE
, PZR.EFFECTIVE_END_DATE
, PZR.EXCLD_FLAG
, PZR.ORDR_NUM
, PRNG.FROM_VALUE||'-'||PRNG.TO_VALUE
, VPR.NAME
, PZR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PSTL_ZIP_RT_F PZR
, FND_USER FUSER
, BEN_PSTL_ZIP_RNG_F PRNG
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID (+) = PZR.LAST_UPDATED_BY
AND PRNG.PSTL_ZIP_RNG_ID = PZR.PSTL_ZIP_RNG_ID
AND PZR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID
AND PZR.EFFECTIVE_START_DATE BETWEEN PRNG.EFFECTIVE_START_DATE (+)
AND PRNG.EFFECTIVE_END_DATE(+)
AND PZR.EFFECTIVE_START_DATE BETWEEN VPR.EFFECTIVE_START_DATE (+)
AND VPR.EFFECTIVE_END_DATE(+)