VIEW: APPS.OKC_XPRT_BUS_VARIABLES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)