[Home] [Help]
View: OKC_XPRT_BUS_VARIABLES_V
View Text
SELECT BV.VARIABLE_CODE VARIABLE_CODE
, BV.VARIABLE_NAME VARIABLE_NAME
, BV.DESCRIPTION DESCRIPTION
, BV.XPRT_VALUE_SET_NAME VALUE_SET_NAME
, BV.VARIABLE_DATATYPE
, VS.LONGLIST_FLAG LONGLIST_FLAG
, VS.VALIDATION_TYPE VALIDATION_TYPE
, VS.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
FROM OKC_BUS_VARIABLES_V BV
, FND_FLEX_VALUE_SETS VS
WHERE VARIABLE_TYPE = 'S'
AND CONTRACT_EXPERT_YN='Y'
AND VARIABLE_DATATYPE<>'D'
AND BV.XPRT_VALUE_SET_NAME=VS.FLEX_VALUE_SET_NAME(+)
Columns
Name |
VARIABLE_CODE |
VARIABLE_NAME |
DESCRIPTION |
VALUE_SET_NAME |
VARIABLE_DATATYPE |
LONGLIST_FLAG |
VALIDATION_TYPE |
FLEX_VALUE_SET_ID |