VIEW: APPS.ZPB_LAB_VIEWS_V

Source

View Text - Preformatted

SELECT meas.aw_name OBJECT_AW_NAE, 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.type OBJECT_TYPE, meas.instance_id OBJECT_INSTANCE_ID from zpb_measures meas, zpb_cubes cube, zpb_current_user_v currUser where meas.cube_id = cube.cube_id and cube.bus_area_id = currUser.business_area_id and meas.type in ('SHARED_VIEW_DATA', 'SHARED_VIEW_CALC')

View Text - HTML Formatted

SELECT MEAS.AW_NAME OBJECT_AW_NAE
, 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.TYPE OBJECT_TYPE
, MEAS.INSTANCE_ID OBJECT_INSTANCE_ID
FROM ZPB_MEASURES MEAS
, ZPB_CUBES CUBE
, ZPB_CURRENT_USER_V CURRUSER
WHERE MEAS.CUBE_ID = CUBE.CUBE_ID
AND CUBE.BUS_AREA_ID = CURRUSER.BUSINESS_AREA_ID
AND MEAS.TYPE IN ('SHARED_VIEW_DATA'
, 'SHARED_VIEW_CALC')