Skip to content
[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 |
APPS.BEN_SVC_AREA_PSTL_ZIP_RNG_D