Product: | BIS - Applications BIS |
---|---|
Description: | EDW_WH_CFIG_PARAMETERS_V |
Implementation/DBA Data: | Not implemented in this database |
SELECT CFG.OPTION_PK_KEY
, CFG.OBJECT_ID
, CFG.OBJECT_NAME
, CFG.OBJECT_TYPE
, CFG.OBJECT_SUBTYPE
, CFG.OPTION_CODE
, CFG.OPTION_TYPE
, FLK.MEANING OPTION_NAME
, CFG.OPTION_VALUE
, CFG.CREATION_DATE
, CFG.CREATED_BY
, CFG.LAST_UPDATE_DATE
, CFG.LAST_UPDATED_BY
, CFG.LAST_UPDATE_LOGIN
, REL.RELATION_LONG_NAME OBJECT_LONGNAME
FROM EDW_WH_CFIG_PARAMETERS CFG
, EDW_RELATIONS_MD_V REL
, FND_LOOKUP_VALUES_VL FLK
WHERE FLK.LOOKUP_TYPE='EDW_OPTION_LOOKUP'AND FLK.ENABLED_FLAG='Y'
AND FLK.LOOKUP_CODE=CFG.OPTION_CODE
AND CFG.OBJECT_NAME=REL.RELATION_NAME