View: OKC_XPRT_BUS_VARIABLES_V

Product:	OKC - Contracts Core
Description:	View for contract expert business variables
Implementation/DBA Data:	APPS.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