[Home] [Help]
View: BEN_PSTL_ZIP_RNG_D
View Text
SELECT RZR.PSTL_ZIP_RNG_ID
, RZR.EFFECTIVE_START_DATE
, RZR.EFFECTIVE_END_DATE
, RZR.FROM_VALUE
, RZR.TO_VALUE
, RZR.BUSINESS_GROUP_ID
, RZR.RZR_ATTRIBUTE_CATEGORY
, RZR.LAST_UPDATE_DATE
, FUSER.USER_NAME
, RZR.LAST_UPDATE_LOGIN
, RZR.CREATED_BY
, RZR.CREATION_DATE
, RZR.OBJECT_VERSION_NUMBER
FROM BEN_PSTL_ZIP_RNG_F RZR
, FND_USER FUSER
WHERE FUSER.USER_ID (+)=RZR.LAST_UPDATED_BY
Columns
Name |
PSTL_ZIP_RNG_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
FROM_VALUE |
TO_VALUE |
BUSINESS_GROUP_ID |
RZR_ATTRIBUTE_CATEGORY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
OBJECT_VERSION_NUMBER |