VIEW: APPS.BEN_SVC_AREA_PSTL_ZIP_RNG_D

Source

View Text - Preformatted

SELECT SAZ.SVC_AREA_PSTL_ZIP_RNG_ID , SAZ.EFFECTIVE_START_DATE , SAZ.EFFECTIVE_END_DATE , PZR.FROM_VALUE || decode(nvl(to_char(PZR.TO_VALUE),'*'), '*', ' ', ' -- ' || PZR.TO_VALUE), SAZ.BUSINESS_GROUP_ID , SAZ.LAST_UPDATE_DATE, SAZ.LAST_UPDATED_BY , SAZ.LAST_UPDATE_LOGIN , SAZ.CREATED_BY , SAZ.CREATION_DATE FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ, BEN_PSTL_ZIP_RNG_F PZR WHERE PZR.PSTL_ZIP_RNG_ID = SAZ.PSTL_ZIP_RNG_ID and saz.effective_start_date BETWEEN pzr.effective_start_date (+) and pzr.effective_end_date(+)

View Text - HTML Formatted

SELECT SAZ.SVC_AREA_PSTL_ZIP_RNG_ID
, SAZ.EFFECTIVE_START_DATE
, SAZ.EFFECTIVE_END_DATE
, PZR.FROM_VALUE || DECODE(NVL(TO_CHAR(PZR.TO_VALUE)
, '*')
, '*'
, ' '
, ' -- ' || PZR.TO_VALUE)
, SAZ.BUSINESS_GROUP_ID
, SAZ.LAST_UPDATE_DATE
, SAZ.LAST_UPDATED_BY
, SAZ.LAST_UPDATE_LOGIN
, SAZ.CREATED_BY
, SAZ.CREATION_DATE
FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
, BEN_PSTL_ZIP_RNG_F PZR
WHERE PZR.PSTL_ZIP_RNG_ID = SAZ.PSTL_ZIP_RNG_ID
AND SAZ.EFFECTIVE_START_DATE BETWEEN PZR.EFFECTIVE_START_DATE (+)
AND PZR.EFFECTIVE_END_DATE(+)