Product: | EC - e-Commerce Gateway |
---|---|
Description: | View on FND_PROFILE_OPTIONS_VL and FND_PROFILE_OPTIONS_VALUES tables |
Implementation/DBA Data: | APPS.ECE_PROFILE_OPTIONS |
SELECT FPO.PROFILE_OPTION_ID
, FPO.APPLICATION_ID
, FPO.PROFILE_OPTION_NAME
, FPO.USER_PROFILE_OPTION_NAME
, FPO.DESCRIPTION
, FPO.SQL_VALIDATION
, FPOV.PROFILE_OPTION_VALUE
, FPO.CREATION_DATE
, FPO.CREATED_BY
, FPO.LAST_UPDATE_DATE
, FPO.LAST_UPDATED_BY
, FPO.LAST_UPDATE_LOGIN
, FPO.START_DATE_ACTIVE
, FPO.END_DATE_ACTIVE
, FPO.WRITE_ALLOWED_FLAG
, FPO.READ_ALLOWED_FLAG
, FPO.USER_CHANGEABLE_FLAG
, FPO.USER_VISIBLE_FLAG
, FPO.SITE_ENABLED_FLAG
, FPO.SITE_UPDATE_ALLOWED_FLAG
, FPO.APP_ENABLED_FLAG
, FPO.APP_UPDATE_ALLOWED_FLAG
, FPO.RESP_ENABLED_FLAG
, FPO.RESP_UPDATE_ALLOWED_FLAG
, FPO.USER_ENABLED_FLAG
, FPO.USER_UPDATE_ALLOWED_FLAG
FROM FND_PROFILE_OPTIONS_VL FPO
, FND_PROFILE_OPTION_VALUES FPOV
WHERE FPO.PROFILE_OPTION_NAME LIKE 'ECE_%'
AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID (+)
AND FPOV.LEVEL_ID (+) = 10001
AND FPOV.APPLICATION_ID=175