DBA Data[Home] [Help]

VIEW: APPS.ZPB_BUSAREA_CONDITIONS_V

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.VERSION_ID, A.ATTRIBUTE_ID, A.LOGICAL_DIM_ID, B.DIMENSION_ID, B.ATTRIBUTE_VALUE_COLUMN_NAME, B.ATTRIBUTE_VARCHAR_LABEL, A.VALUE, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.VALUE_SET_ID, A.OPERATION from ZPB_BUSAREA_CONDITIONS A, FEM_DIM_ATTRIBUTES_B B WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.VERSION_ID
, A.ATTRIBUTE_ID
, A.LOGICAL_DIM_ID
, B.DIMENSION_ID
, B.ATTRIBUTE_VALUE_COLUMN_NAME
, B.ATTRIBUTE_VARCHAR_LABEL
, A.VALUE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.VALUE_SET_ID
, A.OPERATION
FROM ZPB_BUSAREA_CONDITIONS A
, FEM_DIM_ATTRIBUTES_B B
WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID