VIEW: APPS.ZPB_LAB_ATTRIBS_SCOPE_V

Source

View Text - Preformatted

SELECT attrib.epb_id OBJECT_AW_NAE, dims.aw_name DIMENSION, 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, dims.dimension_id DIMENSION_ID from zpb_attributes_vl attrib, zpb_dimensions_vl dims, zpb_current_user_v currUser, zpb_attribute_scope attrScope where attrib.dimension_id = dims.dimension_id and dims.bus_area_id = currUser.business_area_id and dims.is_data_dim = 'YES' and attrib.type = 'DIMENSION_ATTRIBUTE' and attrib.attribute_id = attrScope.attribute_id and attrScope.user_id = FND_GLOBAL.USER_ID

View Text - HTML Formatted

SELECT ATTRIB.EPB_ID OBJECT_AW_NAE
, DIMS.AW_NAME DIMENSION
, 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
, DIMS.DIMENSION_ID DIMENSION_ID
FROM ZPB_ATTRIBUTES_VL ATTRIB
, ZPB_DIMENSIONS_VL DIMS
, ZPB_CURRENT_USER_V CURRUSER
, ZPB_ATTRIBUTE_SCOPE ATTRSCOPE
WHERE ATTRIB.DIMENSION_ID = DIMS.DIMENSION_ID
AND DIMS.BUS_AREA_ID = CURRUSER.BUSINESS_AREA_ID
AND DIMS.IS_DATA_DIM = 'YES'
AND ATTRIB.TYPE = 'DIMENSION_ATTRIBUTE'
AND ATTRIB.ATTRIBUTE_ID = ATTRSCOPE.ATTRIBUTE_ID
AND ATTRSCOPE.USER_ID = FND_GLOBAL.USER_ID