VIEW: APPS.ZPB_LAB_ATTRIBS_V

Source

View Text - Preformatted

SELECT attrib.epb_id OBJECT_AW_NAE, dims.aw_name DIMENSION, attrib.label OBJECT_LABEL, 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, nvl(femb.attribute_required_flag, 'N') ATTRIBUTE_REQUIRED_FLAG from zpb_attributes_vl attrib, zpb_dimensions_vl dims, zpb_current_user_v currUser, fem_dim_attributes_b femb 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 femb.attribute_id (+) = attrib.fem_attribute_id

View Text - HTML Formatted

SELECT ATTRIB.EPB_ID OBJECT_AW_NAE
, DIMS.AW_NAME DIMENSION
, ATTRIB.LABEL OBJECT_LABEL
, 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
, NVL(FEMB.ATTRIBUTE_REQUIRED_FLAG
, 'N') ATTRIBUTE_REQUIRED_FLAG
FROM ZPB_ATTRIBUTES_VL ATTRIB
, ZPB_DIMENSIONS_VL DIMS
, ZPB_CURRENT_USER_V CURRUSER
, FEM_DIM_ATTRIBUTES_B FEMB
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 FEMB.ATTRIBUTE_ID (+) = ATTRIB.FEM_ATTRIBUTE_ID