SELECT A.ROWID ROW_ID, A.VERSION_ID, A.ATTRIBUTE_ID, A.LOGICAL_DIM_ID, B.DIMENSION_ID, B.ATTRIBUTE_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_ATTRIBUTES A, FEM_DIM_ATTRIBUTES_VL B WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
SELECT A.ROWID ROW_ID
, A.VERSION_ID
, A.ATTRIBUTE_ID
, A.LOGICAL_DIM_ID
, B.DIMENSION_ID
, B.ATTRIBUTE_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_ATTRIBUTES A
, FEM_DIM_ATTRIBUTES_VL B
WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
|
|
|