Product: | PA - Projects |
---|---|
Description: | PA_GANTT_COLUMNS_V is the view giving the Gantt columns |
Implementation/DBA Data: |
![]() |
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