VIEW: APPS.FII_COST_CENTER_VALUES_V

Source

View Text - Preformatted

SELECT distinct FlexVal.flex_value_id id, FlexVal.flex_value value, FlexVal.description, C.is_leaf_flag FROM FND_FLEX_VALUES_VL FlexVal, FII_FINANCIAL_DIMENSIONS FDim, FII_COST_CTR_HIERARCHIES C WHERE FDim.master_value_set_id = FlexVal.flex_value_set_id AND FDim.dimension_short_name = 'HRI_CL_ORGCC' AND FlexVal.flex_value_id = C.parent_cc_id

View Text - HTML Formatted

SELECT DISTINCT FLEXVAL.FLEX_VALUE_ID ID
, FLEXVAL.FLEX_VALUE VALUE
, FLEXVAL.DESCRIPTION
, C.IS_LEAF_FLAG
FROM FND_FLEX_VALUES_VL FLEXVAL
, FII_FINANCIAL_DIMENSIONS FDIM
, FII_COST_CTR_HIERARCHIES C
WHERE FDIM.MASTER_VALUE_SET_ID = FLEXVAL.FLEX_VALUE_SET_ID
AND FDIM.DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC'
AND FLEXVAL.FLEX_VALUE_ID = C.PARENT_CC_ID