VIEW: APPS.ZPB_BUSAREA_LEVELS_VL

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.VERSION_ID, A.LEVEL_ID, A.HIERARCHY_ID, A.LOGICAL_DIM_ID, B.DIMENSION_ID, B.DIMENSION_GROUP_NAME NAME, B.DESCRIPTION, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN from ZPB_BUSAREA_LEVELS A, FEM_DIMENSION_GRPS_VL B WHERE A.LEVEL_ID = B.DIMENSION_GROUP_ID

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.VERSION_ID
, A.LEVEL_ID
, A.HIERARCHY_ID
, A.LOGICAL_DIM_ID
, B.DIMENSION_ID
, B.DIMENSION_GROUP_NAME NAME
, B.DESCRIPTION
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM ZPB_BUSAREA_LEVELS A
, FEM_DIMENSION_GRPS_VL B
WHERE A.LEVEL_ID = B.DIMENSION_GROUP_ID