VIEW: APPS.ZPB_MD_LABELS_V

Source

View Text - Preformatted

SELECT OBJECT_TYPE, DIMENSION, HIERARCHY, OBJECT_SHORT_LABEL, OBJECT_LONG_LABEL, OBJECT_PLURAL_SHORT_LABEL, OBJECT_PLURAL_LONG_LABEL, OBJECT_SHAR_CWM_NAME, OBJECT_CWM_NAME, OBJECT_AW_NAME, DIMENSION_ID, DISPLAY_ORDER from ( (select 'DIMENSION' OBJECT_TYPE, dims.aw_name DIMENSION, ' ' HIERARCHY, dims.name OBJECT_SHORT_LABEL, dims.long_name OBJECT_LONG_LABEL, dims.plural_name OBJECT_PLURAL_SHORT_LABEL, dims.plural_long_name OBJECT_PLURAL_LONG_LABEL, dims.shar_cwm_name OBJECT_SHAR_CWM_NAME, dims.pers_cwm_name OBJECT_CWM_NAME, dims.aw_name OBJECT_AW_NAME, dims.dimension_id DIMENSION_ID, 0 DISPLAY_ORDER from zpb_dimensions_vl dims where dims.is_data_dim='YES' and dims.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id')) UNION (select 'HIERARCHY' OBJECT_TYPE, dims.aw_name DIMENSION, hier.epb_id HIERARCHY, hier.name OBJECT_SHORT_LABEL, hier.long_name OBJECT_LONG_LABEL, hier.plural_name OBJECT_PLURAL_SHORT_LABEL, hier.plural_long_name OBJECT_PLURAL_LONG_LABEL, hier.shar_cwm_name OBJECT_SHAR_CWM_NAME, hier.pers_cwm_name OBJECT_CWM_NAME, hier.epb_id OBJECT_AW_NAME, dims.dimension_id DIMENSION_ID, 0 DISPLAY_ORDER from zpb_hierarchies_vl hier, zpb_dimensions_vl dims where hier.dimension_id = dims.dimension_id and dims.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id') and dims.is_data_dim = 'YES') UNION (select 'LEVEL' OBJECT_TYPE, dims.aw_name DIMENSION, hier.epb_id HIERARCHY, lev.name OBJECT_SHORT_LABEL, lev.long_name OBJECT_LONG_LABEL, lev.plural_name OBJECT_PLURAL_SHORT_LABEL, lev.plural_long_name OBJECT_PLURAL_LONG_LABEL, lev.shar_cwm_name OBJECT_SHAR_CWM_NAME, lev.pers_cwm_name OBJECT_CWM_NAME, lev.epb_id OBJECT_AW_NAE, dims.dimension_id DIMENSION_ID, hier_level.level_order DISPLAY_ORDER from zpb_levels_vl lev, zpb_dimensions_vl dims, zpb_hier_level hier_level, zpb_hierarchies hier where hier.dimension_id = dims.dimension_id and dims.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id') and dims.is_data_dim = 'YES' and lev.level_id = hier_level.level_id and hier_level.hier_id = hier.hierarchy_id) UNION (select 'ATTRIBUTE' OBJECT_TYPE, dims.aw_name DIMENSION, ' ' HIERARCHY, attrib.name OBJECT_SHORT_LABEL, attrib.long_name OBJECT_LONG_LABEL, attrib.plural_name OBJECT_PLURAL_SHORT_LABEL, attrib.plural_long_name OBJECT_PLURAL_LONG_LABEL, attrib.shar_cwm_name OBJECT_SHAR_CWM_NAME, attrib.pers_cwm_name OBJECT_CWM_NAME, attrib.epb_id OBJECT_AW_NAE, dims.dimension_id DIMENSION_ID, 0 DISPLAY_ORDER from zpb_attributes_vl attrib, zpb_dimensions_vl dims where attrib.dimension_id = dims.dimension_id and dims.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id') and dims.is_data_dim = 'YES') UNION (select 'MEASURE' OBJECT_TYPE, ' ' DIMENSION, ' ' HIERARCHY, meas.name OBJECT_SHORT_LABEL, meas.name OBJECT_LONG_LABEL, meas.name OBJECT_PLURAL_SHORT_LABEL, meas.name OBJECT_PLURAL_LONG_LABEL, meas.cwm_name OBJECT_SHAR_CWM_NAME, meas.cwm_name OBJECT_CWM_NAME, meas.aw_name OBJECT_AW_NAE, 0 DIMENSION_ID, 0 DISPLAY_ORDER from zpb_measures meas, zpb_cubes cube where meas.cube_id = cube.cube_id and cube.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id') and meas.type = 'SHARED_VIEW_DATA') )

View Text - HTML Formatted

SELECT OBJECT_TYPE
, DIMENSION
, HIERARCHY
, OBJECT_SHORT_LABEL
, OBJECT_LONG_LABEL
, OBJECT_PLURAL_SHORT_LABEL
, OBJECT_PLURAL_LONG_LABEL
, OBJECT_SHAR_CWM_NAME
, OBJECT_CWM_NAME
, OBJECT_AW_NAME
, DIMENSION_ID
, DISPLAY_ORDER
FROM ( (SELECT 'DIMENSION' OBJECT_TYPE
, DIMS.AW_NAME DIMENSION
, ' ' HIERARCHY
, DIMS.NAME OBJECT_SHORT_LABEL
, DIMS.LONG_NAME OBJECT_LONG_LABEL
, DIMS.PLURAL_NAME OBJECT_PLURAL_SHORT_LABEL
, DIMS.PLURAL_LONG_NAME OBJECT_PLURAL_LONG_LABEL
, DIMS.SHAR_CWM_NAME OBJECT_SHAR_CWM_NAME
, DIMS.PERS_CWM_NAME OBJECT_CWM_NAME
, DIMS.AW_NAME OBJECT_AW_NAME
, DIMS.DIMENSION_ID DIMENSION_ID
, 0 DISPLAY_ORDER
FROM ZPB_DIMENSIONS_VL DIMS
WHERE DIMS.IS_DATA_DIM='YES'
AND DIMS.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')) UNION (SELECT 'HIERARCHY' OBJECT_TYPE
, DIMS.AW_NAME DIMENSION
, HIER.EPB_ID HIERARCHY
, HIER.NAME OBJECT_SHORT_LABEL
, HIER.LONG_NAME OBJECT_LONG_LABEL
, HIER.PLURAL_NAME OBJECT_PLURAL_SHORT_LABEL
, HIER.PLURAL_LONG_NAME OBJECT_PLURAL_LONG_LABEL
, HIER.SHAR_CWM_NAME OBJECT_SHAR_CWM_NAME
, HIER.PERS_CWM_NAME OBJECT_CWM_NAME
, HIER.EPB_ID OBJECT_AW_NAME
, DIMS.DIMENSION_ID DIMENSION_ID
, 0 DISPLAY_ORDER
FROM ZPB_HIERARCHIES_VL HIER
, ZPB_DIMENSIONS_VL DIMS
WHERE HIER.DIMENSION_ID = DIMS.DIMENSION_ID
AND DIMS.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')
AND DIMS.IS_DATA_DIM = 'YES') UNION (SELECT 'LEVEL' OBJECT_TYPE
, DIMS.AW_NAME DIMENSION
, HIER.EPB_ID HIERARCHY
, LEV.NAME OBJECT_SHORT_LABEL
, LEV.LONG_NAME OBJECT_LONG_LABEL
, LEV.PLURAL_NAME OBJECT_PLURAL_SHORT_LABEL
, LEV.PLURAL_LONG_NAME OBJECT_PLURAL_LONG_LABEL
, LEV.SHAR_CWM_NAME OBJECT_SHAR_CWM_NAME
, LEV.PERS_CWM_NAME OBJECT_CWM_NAME
, LEV.EPB_ID OBJECT_AW_NAE
, DIMS.DIMENSION_ID DIMENSION_ID
, HIER_LEVEL.LEVEL_ORDER DISPLAY_ORDER
FROM ZPB_LEVELS_VL LEV
, ZPB_DIMENSIONS_VL DIMS
, ZPB_HIER_LEVEL HIER_LEVEL
, ZPB_HIERARCHIES HIER
WHERE HIER.DIMENSION_ID = DIMS.DIMENSION_ID
AND DIMS.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')
AND DIMS.IS_DATA_DIM = 'YES'
AND LEV.LEVEL_ID = HIER_LEVEL.LEVEL_ID
AND HIER_LEVEL.HIER_ID = HIER.HIERARCHY_ID) UNION (SELECT 'ATTRIBUTE' OBJECT_TYPE
, DIMS.AW_NAME DIMENSION
, ' ' HIERARCHY
, ATTRIB.NAME OBJECT_SHORT_LABEL
, ATTRIB.LONG_NAME OBJECT_LONG_LABEL
, ATTRIB.PLURAL_NAME OBJECT_PLURAL_SHORT_LABEL
, ATTRIB.PLURAL_LONG_NAME OBJECT_PLURAL_LONG_LABEL
, ATTRIB.SHAR_CWM_NAME OBJECT_SHAR_CWM_NAME
, ATTRIB.PERS_CWM_NAME OBJECT_CWM_NAME
, ATTRIB.EPB_ID OBJECT_AW_NAE
, DIMS.DIMENSION_ID DIMENSION_ID
, 0 DISPLAY_ORDER
FROM ZPB_ATTRIBUTES_VL ATTRIB
, ZPB_DIMENSIONS_VL DIMS
WHERE ATTRIB.DIMENSION_ID = DIMS.DIMENSION_ID
AND DIMS.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')
AND DIMS.IS_DATA_DIM = 'YES') UNION (SELECT 'MEASURE' OBJECT_TYPE
, ' ' DIMENSION
, ' ' HIERARCHY
, MEAS.NAME OBJECT_SHORT_LABEL
, MEAS.NAME OBJECT_LONG_LABEL
, MEAS.NAME OBJECT_PLURAL_SHORT_LABEL
, MEAS.NAME OBJECT_PLURAL_LONG_LABEL
, MEAS.CWM_NAME OBJECT_SHAR_CWM_NAME
, MEAS.CWM_NAME OBJECT_CWM_NAME
, MEAS.AW_NAME OBJECT_AW_NAE
, 0 DIMENSION_ID
, 0 DISPLAY_ORDER
FROM ZPB_MEASURES MEAS
, ZPB_CUBES CUBE
WHERE MEAS.CUBE_ID = CUBE.CUBE_ID
AND CUBE.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')
AND MEAS.TYPE = 'SHARED_VIEW_DATA') )