VIEW: APPS.FII_FINANCIAL_DIMENSIONS_V

Source

View Text - Preformatted

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(frd.dimension_short_name, 'ENI_ITEM_VBH_CAT', frd.dbi_enabled_flag, decode(bd.enabled, 'T', 'Y', 'N')) 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'

View Text - HTML Formatted

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(FRD.DIMENSION_SHORT_NAME
, 'ENI_ITEM_VBH_CAT'
, FRD.DBI_ENABLED_FLAG
, DECODE(BD.ENABLED
, 'T'
, 'Y'
, 'N')) 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'