VIEW: APPS.PA_PROJECT_CLASSES_V

Source

View Text - Preformatted

SELECT CLASS.ROWID ROW_ID , CLASS.PROJECT_ID , CLASS.CLASS_CATEGORY , CLASS.CLASS_CODE , CLASS.LAST_UPDATE_DATE , CLASS.LAST_UPDATED_BY , CLASS.CREATION_DATE , CLASS.CREATED_BY , CLASS.LAST_UPDATE_LOGIN , CODE.DESCRIPTION CODE_DESCRIPTION , CLASS.CODE_PERCENTAGE , CLASS.OBJECT_ID , CLASS.OBJECT_TYPE , CLASS.ATTRIBUTE_CATEGORY , CLASS.ATTRIBUTE1 , CLASS.ATTRIBUTE2 , CLASS.ATTRIBUTE3 , CLASS.ATTRIBUTE4 , CLASS.ATTRIBUTE5 , CLASS.ATTRIBUTE6 , CLASS.ATTRIBUTE7 , CLASS.ATTRIBUTE8 , CLASS.ATTRIBUTE9 , CLASS.ATTRIBUTE10 , CLASS.ATTRIBUTE11 , CLASS.ATTRIBUTE12 , CLASS.ATTRIBUTE13 , CLASS.ATTRIBUTE14 , CLASS.ATTRIBUTE15 , CLASS.RECORD_VERSION_NUMBER  FROM PA_PROJECT_CLASSES CLASS,PA_CLASS_CODES CODE WHERE CLASS.CLASS_CATEGORY = CODE.CLASS_CATEGORY AND CLASS.CLASS_CODE = CODE.CLASS_CODE

View Text - HTML Formatted

SELECT CLASS.ROWID ROW_ID
, CLASS.PROJECT_ID
, CLASS.CLASS_CATEGORY
, CLASS.CLASS_CODE
, CLASS.LAST_UPDATE_DATE
, CLASS.LAST_UPDATED_BY
, CLASS.CREATION_DATE
, CLASS.CREATED_BY
, CLASS.LAST_UPDATE_LOGIN
, CODE.DESCRIPTION CODE_DESCRIPTION
, CLASS.CODE_PERCENTAGE
, CLASS.OBJECT_ID
, CLASS.OBJECT_TYPE
, CLASS.ATTRIBUTE_CATEGORY
, CLASS.ATTRIBUTE1
, CLASS.ATTRIBUTE2
, CLASS.ATTRIBUTE3
, CLASS.ATTRIBUTE4
, CLASS.ATTRIBUTE5
, CLASS.ATTRIBUTE6
, CLASS.ATTRIBUTE7
, CLASS.ATTRIBUTE8
, CLASS.ATTRIBUTE9
, CLASS.ATTRIBUTE10
, CLASS.ATTRIBUTE11
, CLASS.ATTRIBUTE12
, CLASS.ATTRIBUTE13
, CLASS.ATTRIBUTE14
, CLASS.ATTRIBUTE15
, CLASS.RECORD_VERSION_NUMBER
FROM PA_PROJECT_CLASSES CLASS
, PA_CLASS_CODES CODE
WHERE CLASS.CLASS_CATEGORY = CODE.CLASS_CATEGORY
AND CLASS.CLASS_CODE = CODE.CLASS_CODE