VIEW: APPS.FII_FC_V

Source

View Text - Preformatted

SELECT flh.parent_fin_cat_id parent_id, flh.next_level_fin_cat_id id, NVL(ffvt.description,ffvt.flex_value_meaning) value, cat.FIN_CAT_TYPE_CODE type, decode(flh.parent_level, flh.child_level, cat.top_node_flag, 'N') top_node_flag FROM FII_FIN_ITEM_LEAF_HIERS flh, FND_FLEX_VALUES_TL ffvt, FII_FIN_CAT_TYPE_ASSGNS cat WHERE (flh.child_level = flh.parent_level + 1 OR flh.child_level = flh.parent_level ) AND flh.child_fin_cat_id = ffvt.flex_value_id AND ffvt.language = userenv('LANG') and flh.child_fin_cat_id = cat.FIN_CATEGORY_ID

View Text - HTML Formatted

SELECT FLH.PARENT_FIN_CAT_ID PARENT_ID
, FLH.NEXT_LEVEL_FIN_CAT_ID ID
, NVL(FFVT.DESCRIPTION
, FFVT.FLEX_VALUE_MEANING) VALUE
, CAT.FIN_CAT_TYPE_CODE TYPE
, DECODE(FLH.PARENT_LEVEL
, FLH.CHILD_LEVEL
, CAT.TOP_NODE_FLAG
, 'N') TOP_NODE_FLAG
FROM FII_FIN_ITEM_LEAF_HIERS FLH
, FND_FLEX_VALUES_TL FFVT
, FII_FIN_CAT_TYPE_ASSGNS CAT
WHERE (FLH.CHILD_LEVEL = FLH.PARENT_LEVEL + 1 OR FLH.CHILD_LEVEL = FLH.PARENT_LEVEL )
AND FLH.CHILD_FIN_CAT_ID = FFVT.FLEX_VALUE_ID
AND FFVT.LANGUAGE = USERENV('LANG')
AND FLH.CHILD_FIN_CAT_ID = CAT.FIN_CATEGORY_ID