VIEW: APPS.BEN_SVC_AREA_PSTL_ZIP_RNG

Source

View Text - Preformatted

SELECT 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 FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ WHERE SAZ.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND SAZ.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT 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
FROM BEN_SVC_AREA_PSTL_ZIP_RNG_F SAZ
WHERE SAZ.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND SAZ.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))