VIEW: APPS.ZPB_OS_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT dim_tl1.name domain_dimension, attrib.attribute_id attribute_id, attrib.name attribute_name, attrib.type atribute_type, attrib.label attribute_label, tab.table_name olap_dim_table_name, columns.column_name olap_dim_table_column_name, dim_tl2.name range_dimension from zpb_attributes_vl attrib, zpb_attr_table_col attrib_table_col, zpb_columns columns, zpb_dimensions_vl dim_tl1, zpb_dimensions_vl dim_tl2, zpb_tables tab WHERE dim_tl1.dimension_id = attrib.dimension_Id and attrib_table_col.attribute_id = attrib.attribute_id and attrib_table_col.table_id = dim_tl1.shar_table_id and attrib_table_col.column_id = columns.column_id and dim_tl2.dimension_id = attrib.range_dim_id and dim_tl1.shar_table_id = tab.table_id and dim_tl1.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id')

View Text - HTML Formatted

SELECT DIM_TL1.NAME DOMAIN_DIMENSION
, ATTRIB.ATTRIBUTE_ID ATTRIBUTE_ID
, ATTRIB.NAME ATTRIBUTE_NAME
, ATTRIB.TYPE ATRIBUTE_TYPE
, ATTRIB.LABEL ATTRIBUTE_LABEL
, TAB.TABLE_NAME OLAP_DIM_TABLE_NAME
, COLUMNS.COLUMN_NAME OLAP_DIM_TABLE_COLUMN_NAME
, DIM_TL2.NAME RANGE_DIMENSION
FROM ZPB_ATTRIBUTES_VL ATTRIB
, ZPB_ATTR_TABLE_COL ATTRIB_TABLE_COL
, ZPB_COLUMNS COLUMNS
, ZPB_DIMENSIONS_VL DIM_TL1
, ZPB_DIMENSIONS_VL DIM_TL2
, ZPB_TABLES TAB
WHERE DIM_TL1.DIMENSION_ID = ATTRIB.DIMENSION_ID
AND ATTRIB_TABLE_COL.ATTRIBUTE_ID = ATTRIB.ATTRIBUTE_ID
AND ATTRIB_TABLE_COL.TABLE_ID = DIM_TL1.SHAR_TABLE_ID
AND ATTRIB_TABLE_COL.COLUMN_ID = COLUMNS.COLUMN_ID
AND DIM_TL2.DIMENSION_ID = ATTRIB.RANGE_DIM_ID
AND DIM_TL1.SHAR_TABLE_ID = TAB.TABLE_ID
AND DIM_TL1.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')