[Home] [Help]
View: BEN_SVC_AREA_PSTL_ZIP_RNG_D
View Text
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
Columns
Name |
SVC_AREA_PSTL_ZIP_RNG_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
POSTAL_ZIP_RANGE |
BUSINESS_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |