VIEW: APPS.ZPB_LAB_LEVELS_V

Source

View Text - Preformatted

SELECT lev.epb_id OBJECT_AW_NAME, dims.aw_name DIMENSION, hier.epb_id HIERARCHY, hier_level.level_order DISPLAY_ORDER, 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, dims.dimension_id DIMENSION_ID, hier.hierarchy_id HIERARCHY_ID, lev.level_id LEVEL_ID from zpb_levels_vl lev, zpb_dimensions_vl dims, zpb_hier_level hier_level, zpb_hierarchies hier, zpb_current_user_v currUser where hier.dimension_id = dims.dimension_id and hier.hier_type = 'LEVEL_BASED' and dims.bus_area_id = currUser.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

View Text - HTML Formatted

SELECT LEV.EPB_ID OBJECT_AW_NAME
, DIMS.AW_NAME DIMENSION
, HIER.EPB_ID HIERARCHY
, HIER_LEVEL.LEVEL_ORDER DISPLAY_ORDER
, 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
, DIMS.DIMENSION_ID DIMENSION_ID
, HIER.HIERARCHY_ID HIERARCHY_ID
, LEV.LEVEL_ID LEVEL_ID
FROM ZPB_LEVELS_VL LEV
, ZPB_DIMENSIONS_VL DIMS
, ZPB_HIER_LEVEL HIER_LEVEL
, ZPB_HIERARCHIES HIER
, ZPB_CURRENT_USER_V CURRUSER
WHERE HIER.DIMENSION_ID = DIMS.DIMENSION_ID
AND HIER.HIER_TYPE = 'LEVEL_BASED'
AND DIMS.BUS_AREA_ID = CURRUSER.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