This view is based on table FII_FIN_CAT_TYPE_ASSGNS. It stores Financial Category type assignments.
Implementation/DBA Data:
Not implemented in this database
View Text
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'