VIEW: APPS.PA_GANTT_COLUMNS_V

Source

View Text - Preformatted

SELECT GC.ROWID ,GC.GANTT_COLUMN_ID ,GC.GANTT_VIEW_ID ,GC.DISPLAY_SEQUENCE ,GC.GANTT_COLUMN_NAME ,LKP.MEANING ,GC.RECORD_VERSION_NUMBER ,GC.CREATION_DATE ,GC.CREATED_BY ,GC.LAST_UPDATE_DATE ,GC.LAST_UPDATED_BY ,GC.LAST_UPDATE_LOGIN ,GC.ATTRIBUTE_CATEGORY ,GC.ATTRIBUTE1 ,GC.ATTRIBUTE2 ,GC.ATTRIBUTE3 ,GC.ATTRIBUTE4 ,GC.ATTRIBUTE5 ,GC.ATTRIBUTE6 ,GC.ATTRIBUTE7 ,GC.ATTRIBUTE8 ,GC.ATTRIBUTE9 ,GC.ATTRIBUTE10 ,GC.ATTRIBUTE11 ,GC.ATTRIBUTE12 ,GC.ATTRIBUTE13 ,GC.ATTRIBUTE14 ,GC.ATTRIBUTE15 FROM PA_GANTT_COLUMNS GC, PA_LOOKUPS LKP WHERE LKP.lookup_type = 'PA_GANTT_TEXT_CODE' and LKP.lookup_code = GC.gantt_column_name

View Text - HTML Formatted

SELECT GC.ROWID
, GC.GANTT_COLUMN_ID
, GC.GANTT_VIEW_ID
, GC.DISPLAY_SEQUENCE
, GC.GANTT_COLUMN_NAME
, LKP.MEANING
, GC.RECORD_VERSION_NUMBER
, GC.CREATION_DATE
, GC.CREATED_BY
, GC.LAST_UPDATE_DATE
, GC.LAST_UPDATED_BY
, GC.LAST_UPDATE_LOGIN
, GC.ATTRIBUTE_CATEGORY
, GC.ATTRIBUTE1
, GC.ATTRIBUTE2
, GC.ATTRIBUTE3
, GC.ATTRIBUTE4
, GC.ATTRIBUTE5
, GC.ATTRIBUTE6
, GC.ATTRIBUTE7
, GC.ATTRIBUTE8
, GC.ATTRIBUTE9
, GC.ATTRIBUTE10
, GC.ATTRIBUTE11
, GC.ATTRIBUTE12
, GC.ATTRIBUTE13
, GC.ATTRIBUTE14
, GC.ATTRIBUTE15
FROM PA_GANTT_COLUMNS GC
, PA_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'PA_GANTT_TEXT_CODE'
AND LKP.LOOKUP_CODE = GC.GANTT_COLUMN_NAME