VIEW: APPS.ZPB_LAB_VIEWS_SCOPE_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.epb_id EPB_ID from zpb_measures meas, zpb_cubes cube, zpb_current_user_v currUser, zpb_metascope_controlledcalcs MscopeContrlCalcs where meas.cube_id = cube.cube_id and cube.bus_area_id = currUser.business_area_id and (cube.name like currUser.personal_aw || '_%' or cube.name like 'ZPBDATA%') and meas.type in ('SHARED_VIEW_DATA', 'APPROVER_DATA', 'PERSONAL_CALC', 'PERSONAL_DATA', 'PERSONAL_INPUT_LEVEL', 'PERSONAL_TARGET', 'SHARED_VIEW_CALC') and meas.INSTANCE_ID = MscopeContrlCalcs.INSTANCE_ID (+) and MscopeContrlCalcs.ID (+) = FND_GLOBAL.USER_ID and meas.INSTANCE_ID not in (select instance_ac_id from zpb_measure_scope where restriction_type = 'FULLREST' and instance_ac_id not in (select business_process_entity_id from zpb_measure_scope_exempt_users where user_id= FND_GLOBAL.USER_ID and business_process_entity_type='I'))

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.EPB_ID EPB_ID
FROM ZPB_MEASURES MEAS
, ZPB_CUBES CUBE
, ZPB_CURRENT_USER_V CURRUSER
, ZPB_METASCOPE_CONTROLLEDCALCS MSCOPECONTRLCALCS
WHERE MEAS.CUBE_ID = CUBE.CUBE_ID
AND CUBE.BUS_AREA_ID = CURRUSER.BUSINESS_AREA_ID
AND (CUBE.NAME LIKE CURRUSER.PERSONAL_AW || '_%' OR CUBE.NAME LIKE 'ZPBDATA%')
AND MEAS.TYPE IN ('SHARED_VIEW_DATA'
, 'APPROVER_DATA'
, 'PERSONAL_CALC'
, 'PERSONAL_DATA'
, 'PERSONAL_INPUT_LEVEL'
, 'PERSONAL_TARGET'
, 'SHARED_VIEW_CALC')
AND MEAS.INSTANCE_ID = MSCOPECONTRLCALCS.INSTANCE_ID (+)
AND MSCOPECONTRLCALCS.ID (+) = FND_GLOBAL.USER_ID
AND MEAS.INSTANCE_ID NOT IN (SELECT INSTANCE_AC_ID
FROM ZPB_MEASURE_SCOPE
WHERE RESTRICTION_TYPE = 'FULLREST'
AND INSTANCE_AC_ID NOT IN (SELECT BUSINESS_PROCESS_ENTITY_ID
FROM ZPB_MEASURE_SCOPE_EXEMPT_USERS
WHERE USER_ID= FND_GLOBAL.USER_ID
AND BUSINESS_PROCESS_ENTITY_TYPE='I'))