VIEW: APPS.BEN_SVC_AREA_PSTL_ZIP_RNG_V1

Source

View Text - Preformatted

SELECT SAZ.ROWID ROW_ID , SAZ.SVC_AREA_PSTL_ZIP_RNG_ID , SAZ.EFFECTIVE_START_DATE , SAZ.EFFECTIVE_END_DATE , SAZ.SVC_AREA_ID , SAZ.PSTL_ZIP_RNG_ID , SAZ.BUSINESS_GROUP_ID , SAZ.SAZ_ATTRIBUTE_CATEGORY , SAZ.SAZ_ATTRIBUTE1 , SAZ.SAZ_ATTRIBUTE2 , SAZ.SAZ_ATTRIBUTE3 , SAZ.SAZ_ATTRIBUTE4 , SAZ.SAZ_ATTRIBUTE5 , SAZ.SAZ_ATTRIBUTE6 , SAZ.SAZ_ATTRIBUTE7 , SAZ.SAZ_ATTRIBUTE8 , SAZ.SAZ_ATTRIBUTE9 , SAZ.SAZ_ATTRIBUTE10 , SAZ.SAZ_ATTRIBUTE11 , SAZ.SAZ_ATTRIBUTE12 , SAZ.SAZ_ATTRIBUTE13 , SAZ.SAZ_ATTRIBUTE14 , SAZ.SAZ_ATTRIBUTE15 , SAZ.SAZ_ATTRIBUTE16 , SAZ.SAZ_ATTRIBUTE17 , SAZ.SAZ_ATTRIBUTE18 , SAZ.SAZ_ATTRIBUTE19 , SAZ.SAZ_ATTRIBUTE20 , SAZ.SAZ_ATTRIBUTE21 , SAZ.SAZ_ATTRIBUTE22 , SAZ.SAZ_ATTRIBUTE23 , SAZ.SAZ_ATTRIBUTE24 , SAZ.SAZ_ATTRIBUTE25 , SAZ.SAZ_ATTRIBUTE26 , SAZ.SAZ_ATTRIBUTE27 , SAZ.SAZ_ATTRIBUTE28 , SAZ.SAZ_ATTRIBUTE29 , SAZ.SAZ_ATTRIBUTE30 , SAZ.LAST_UPDATE_DATE , SAZ.LAST_UPDATED_BY , SAZ.LAST_UPDATE_LOGIN , SAZ.CREATED_BY , SAZ.CREATION_DATE , SAZ.OBJECT_VERSION_NUMBER, RZR.FROM_VALUE, RZR.TO_VALUE, RZR.FROM_VALUE || decode(nvl(RZR.TO_VALUE, '*'), '*', ' ', ' -- ' ||TO_VALUE) PSTL_ZIP_RNG_ID_NAME FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ, BEN_PSTL_ZIP_RNG_F RZR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND RZR.PSTL_ZIP_RNG_ID = SAZ.PSTL_ZIP_RNG_ID AND SE.EFFECTIVE_DATE BETWEEN SAZ.EFFECTIVE_START_DATE AND SAZ.EFFECTIVE_END_DATE AND SE.EFFECTIVE_DATE BETWEEN RZR.EFFECTIVE_START_DATE AND RZR.EFFECTIVE_END_DATE AND RZR.BUSINESS_GROUP_ID = SAZ.BUSINESS_GROUP_ID

View Text - HTML Formatted

SELECT SAZ.ROWID ROW_ID
, SAZ.SVC_AREA_PSTL_ZIP_RNG_ID
, SAZ.EFFECTIVE_START_DATE
, SAZ.EFFECTIVE_END_DATE
, SAZ.SVC_AREA_ID
, SAZ.PSTL_ZIP_RNG_ID
, SAZ.BUSINESS_GROUP_ID
, SAZ.SAZ_ATTRIBUTE_CATEGORY
, SAZ.SAZ_ATTRIBUTE1
, SAZ.SAZ_ATTRIBUTE2
, SAZ.SAZ_ATTRIBUTE3
, SAZ.SAZ_ATTRIBUTE4
, SAZ.SAZ_ATTRIBUTE5
, SAZ.SAZ_ATTRIBUTE6
, SAZ.SAZ_ATTRIBUTE7
, SAZ.SAZ_ATTRIBUTE8
, SAZ.SAZ_ATTRIBUTE9
, SAZ.SAZ_ATTRIBUTE10
, SAZ.SAZ_ATTRIBUTE11
, SAZ.SAZ_ATTRIBUTE12
, SAZ.SAZ_ATTRIBUTE13
, SAZ.SAZ_ATTRIBUTE14
, SAZ.SAZ_ATTRIBUTE15
, SAZ.SAZ_ATTRIBUTE16
, SAZ.SAZ_ATTRIBUTE17
, SAZ.SAZ_ATTRIBUTE18
, SAZ.SAZ_ATTRIBUTE19
, SAZ.SAZ_ATTRIBUTE20
, SAZ.SAZ_ATTRIBUTE21
, SAZ.SAZ_ATTRIBUTE22
, SAZ.SAZ_ATTRIBUTE23
, SAZ.SAZ_ATTRIBUTE24
, SAZ.SAZ_ATTRIBUTE25
, SAZ.SAZ_ATTRIBUTE26
, SAZ.SAZ_ATTRIBUTE27
, SAZ.SAZ_ATTRIBUTE28
, SAZ.SAZ_ATTRIBUTE29
, SAZ.SAZ_ATTRIBUTE30
, SAZ.LAST_UPDATE_DATE
, SAZ.LAST_UPDATED_BY
, SAZ.LAST_UPDATE_LOGIN
, SAZ.CREATED_BY
, SAZ.CREATION_DATE
, SAZ.OBJECT_VERSION_NUMBER
, RZR.FROM_VALUE
, RZR.TO_VALUE
, RZR.FROM_VALUE || DECODE(NVL(RZR.TO_VALUE
, '*')
, '*'
, ' '
, ' -- ' ||TO_VALUE) PSTL_ZIP_RNG_ID_NAME
FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
, BEN_PSTL_ZIP_RNG_F RZR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND RZR.PSTL_ZIP_RNG_ID = SAZ.PSTL_ZIP_RNG_ID
AND SE.EFFECTIVE_DATE BETWEEN SAZ.EFFECTIVE_START_DATE
AND SAZ.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN RZR.EFFECTIVE_START_DATE
AND RZR.EFFECTIVE_END_DATE
AND RZR.BUSINESS_GROUP_ID = SAZ.BUSINESS_GROUP_ID