DBA Data[Home] [Help]

VIEW: APPS.BEN_ELIG_TBCO_USE_PRTE_D

Source

View Text - Preformatted

SELECT ETU.ELIG_TBCO_USE_PRTE_ID , ETU.EFFECTIVE_START_DATE , ETU.EFFECTIVE_END_DATE , ETU.BUSINESS_GROUP_ID , ETU.ELIGY_PRFL_ID , ETU.EXCLD_FLAG , ETU.ORDR_NUM , ETU.USES_TBCO_FLAG , ETU.CRITERIA_SCORE, ETU.CRITERIA_WEIGHT , ETU.LAST_UPDATE_DATE , ETU.LAST_UPDATED_BY , ETU.LAST_UPDATE_LOGIN , ETU.CREATED_BY , ETU.CREATION_DATE , ETU.OBJECT_VERSION_NUMBER FROM BEN_ELIG_TBCO_USE_PRTE_F ETU, FND_USER_VIEW FUSER WHERE FUSER.USER_ID(+) = ETU.LAST_UPDATED_BY
View Text - HTML Formatted

SELECT ETU.ELIG_TBCO_USE_PRTE_ID
, ETU.EFFECTIVE_START_DATE
, ETU.EFFECTIVE_END_DATE
, ETU.BUSINESS_GROUP_ID
, ETU.ELIGY_PRFL_ID
, ETU.EXCLD_FLAG
, ETU.ORDR_NUM
, ETU.USES_TBCO_FLAG
, ETU.CRITERIA_SCORE
, ETU.CRITERIA_WEIGHT
, ETU.LAST_UPDATE_DATE
, ETU.LAST_UPDATED_BY
, ETU.LAST_UPDATE_LOGIN
, ETU.CREATED_BY
, ETU.CREATION_DATE
, ETU.OBJECT_VERSION_NUMBER
FROM BEN_ELIG_TBCO_USE_PRTE_F ETU
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID(+) = ETU.LAST_UPDATED_BY