View: OKC_BUS_VARIABLES_SEARCH_V

Product:	OKC - Contracts Core
Description:	Variables view definition used in Variables Search
Implementation/DBA Data:	APPS.OKC_BUS_VARIABLES_SEARCH_V

View Text

SELECT BVTL.VARIABLE_CODE
, BVTL.VARIABLE_NAME
, BVB.VARIABLE_TYPE
, BVTL.DESCRIPTION
, IM.MEANING
, VTM.MEANING
, DECODE((SELECT ARV.VARIABLE_CODE
FROM OKC_ARTICLE_VARIABLES ARV
WHERE ARV.VARIABLE_CODE = BVB.VARIABLE_CODE
AND ROWNUM < 2 )
, NULL
, 'N'
, 'Y')
, BVB.DISABLED_YN
, BVB.EXTERNAL_YN
, BVB.VALUE_SET_ID
, FVS.FLEX_VALUE_SET_NAME AS VALUESET_NAME
, AAV.APPLICATION_NAME
, BVB.VARIABLE_DEFAULT_VALUE
, DM.MEANING VARIABLE_DATATYPE
, BVB.APPLICATION_ID
, BVB.XPRT_VALUE_SET_NAME
, BVB.CONTRACT_EXPERT_YN
, BVB.LINE_LEVEL_FLAG
, BVB.DATE_PUBLISHED
, BVB.PROCEDURE_NAME
, BVB.VARIABLE_SOURCE
, DECODE (BVB.MRV_FLAG
, 'Y'
, OKC_MRV_UTIL.GETTEMPLATENAME(BVB.MRV_TMPL_CODE)
, NULL) TEMPLATE_NAME
, BVB.CLM_SOURCE
, BVB.MRV_FLAG
, DECODE(BVB.MRV_FLAG
, 'Y'
, OKC_MRV_UTIL.GETATTRIBUTEGROUPDISPNAME(BVB.CLM_REF1)
, NULL) ATTRIBUTE_GROUP_NAME
FROM FND_LOOKUPS DM
, FND_APPLICATION_VL AAV
, FND_FLEX_VALUE_SETS FVS
, FND_LOOKUPS IM
, FND_LOOKUPS VTM
, OKC_BUS_VARIABLES_TL BVTL
, OKC_BUS_VARIABLES_B BVB
WHERE BVB.VARIABLE_CODE = BVTL.VARIABLE_CODE
AND BVTL.LANGUAGE = USERENV('LANG')
AND IM.LOOKUP_TYPE = 'OKC_ARTICLE_INTENT'
AND IM.LOOKUP_CODE = BVB.VARIABLE_INTENT
AND VTM.LOOKUP_TYPE = 'OKC_ART_VAR_TYPE'
AND VTM.LOOKUP_CODE = BVB.VARIABLE_TYPE
AND DM.LOOKUP_TYPE (+) = 'OKC_ART_VAR_DATATYPE'
AND DM.LOOKUP_CODE (+)= BVB.VARIABLE_DATATYPE
AND BVB.VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID(+)
AND BVB.APPLICATION_ID = AAV.APPLICATION_ID(+)

Columns