VIEW: APPS.FII_FC_TYPE_ASSGNS_V

Source

View Text - Preformatted

SELECT FIN_CAT_TYPE_CODE, FIN_CATEGORY_ID, TOP_NODE_FLAG FROM FII_FIN_CAT_TYPE_ASSGNS UNION ALL SELECT v.LOOKUP_CODE FIN_CAT_TYPE_CODE, d.DBI_HIER_TOP_NODE_ID FIN_CATEGORY_ID, NULL TOP_NODE_FLAG FROM FII_FINANCIAL_DIMENSIONS d, FND_LOOKUP_VALUES_VL v WHERE d.DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM' AND v.LOOKUP_TYPE like 'FII_FIN_CAT_TYPE_CODE'

View Text - HTML Formatted

SELECT FIN_CAT_TYPE_CODE
, FIN_CATEGORY_ID
, TOP_NODE_FLAG
FROM FII_FIN_CAT_TYPE_ASSGNS UNION ALL SELECT V.LOOKUP_CODE FIN_CAT_TYPE_CODE
, D.DBI_HIER_TOP_NODE_ID FIN_CATEGORY_ID
, NULL TOP_NODE_FLAG
FROM FII_FINANCIAL_DIMENSIONS D
, FND_LOOKUP_VALUES_VL V
WHERE D.DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM'
AND V.LOOKUP_TYPE LIKE 'FII_FIN_CAT_TYPE_CODE'