VIEW: APPS.ZPB_LAB_DIMS_V

Source

View Text - Preformatted

SELECT dims.aw_name OBJECT_AW_NAME, 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.dimension_id DIMENSION_ID, dims.epb_id EPB_ID from zpb_dimensions_vl dims, zpb_current_user_v currUser where dims.is_data_dim='YES' and dims.bus_area_id = currUser.business_area_id

View Text - HTML Formatted

SELECT DIMS.AW_NAME OBJECT_AW_NAME
, 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.DIMENSION_ID DIMENSION_ID
, DIMS.EPB_ID EPB_ID
FROM ZPB_DIMENSIONS_VL DIMS
, ZPB_CURRENT_USER_V CURRUSER
WHERE DIMS.IS_DATA_DIM='YES'
AND DIMS.BUS_AREA_ID = CURRUSER.BUSINESS_AREA_ID