[Home] [Help]
| Product: | FII - Financial Intelligence (Obsolete) |
|---|---|
| Description: | This view is based on the view BISBV_DIMENSIONS and the table FII_FINANCIAL_DIMENSIONS. It will contain information about the Financial Dimensions. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DECODE(FRD.DIMENSION_SHORT_NAME
, 'FII_COMPANIES'
, 1
, 'HRI_CL_ORGCC'
, 2
, 'FII_LOB'
, 3
, 'GL_FII_FIN_ITEM'
, 4
, 'ENI_ITEM_VBH_CAT'
, 5
, 'FII_USER_DEFINED_1'
, 6
, 'FII_USER_DEFINED_2'
, 7) LINE_NUMBER
, BD.DIMENSION_LEVEL_NAME DIMENSION_NAME
, BD.DIMENSION_LEVEL_SHORT_NAME DIMENSION_SHORT_NAME
, BD.DESCRIPTION DESCRIPTION
, FRD.SYSTEM_ENABLED_FLAG SYSTEM_ENABLED_FLAG
, DECODE(BD.ENABLED
, 'T'
, 'Y'
, 'F'
, 'N'
, BD.ENABLED) DBI_ENABLED_FLAG
, DECODE(FRD.DIMENSION_SHORT_NAME
, 'ENI_ITEM_VBH_CAT'
, ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID(401
, 'MCAT'
, ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID)
, FRD.MASTER_VALUE_SET_ID) MASTER_VALUE_SET_ID
, FRD.DBI_HIER_TOP_NODE DBI_HIER_TOP_NODE
, FRD.DBI_HIER_TOP_NODE_ID DBI_HIER_TOP_NODE_ID
, DECODE(FRD.DIMENSION_SHORT_NAME
, 'GL_FII_FIN_ITEM'
, 'N'
, 'Y') ALLOW_UPDATE_MAPPING_FLAG
, BD.DIMENSION_LEVEL_NAME DIMENSION_DISPLAY_NAME
, DECODE(FRD.DIMENSION_SHORT_NAME
, 'ENI_ITEM_VBH_CAT'
, NVL(FFVS.FLEX_VALUE_SET_NAME
, LOOK2.MEANING)
, FFVS.FLEX_VALUE_SET_NAME) MASTER_VALUE_SET_NAME
, FRD.INCL_MASTER_VS_LEAF_NODES_FLAG INCL_MASTER_VS_LEAF_NODES_FLAG
FROM FII_FINANCIAL_DIMENSIONS FRD
, BISFV_LEVELS_CUSTOMIZATIONS_V BD
, FND_FLEX_VALUE_SETS FFVS
, FND_LOOKUP_VALUES_VL LOOK2
WHERE FRD.DIMENSION_SHORT_NAME = BD.DIMENSION_LEVEL_SHORT_NAME
AND FRD.DIMENSION_SHORT_NAME IN ( 'FII_COMPANIES'
, 'HRI_CL_ORGCC'
, 'GL_FII_FIN_ITEM'
, 'FII_LOB'
, 'ENI_ITEM_VBH_CAT'
, 'FII_USER_DEFINED_1'
, 'FII_USER_DEFINED_2')
AND DECODE(FRD.DIMENSION_SHORT_NAME
, 'ENI_ITEM_VBH_CAT'
, ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID(401
, 'MCAT'
, ENI_DENORM_HRCHY.GET_CATEGORY_SET_ID)
, FRD.MASTER_VALUE_SET_ID) = FFVS.FLEX_VALUE_SET_ID(+)
AND LOOK2.LOOKUP_TYPE = 'FII_LITERAL'
AND LOOK2.LOOKUP_CODE = 'N/A'