VIEW: APPS.OKC_BUS_VARIABLES_SEARCH_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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