[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | Displays all list elements |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PXP.PROJECT_ID
, PXP.PROJECT_NAME
, PXP.PROJECT_NUMBER
, PXP.PROGRESS_STATUS_CODE
, PXP.PROGRESS_STATUS
, PXP.TAG
, PXP.COMPANY_ID
, PXP.COMPANY_NAME
, PXP.PROJECT_MANAGER_ID
, PXP.PROJECT_MANAGER_NAME
, PXP.PROJECT_MANAGER_USER_ID
, PXP.PROJECT_MANAGER_USER_NAME
, PXP.START_DATE
, PXP.END_DATE
, PCLE.LIST_ID
, PCLE.LIST_ELEMENT_ID
, PCLE.DISPLAY_ORDER
, PCLE.RECORD_VERSION_NUMBER
, PCLE.LAST_UPDATE_DATE
, PCLE.LAST_UPDATED_BY
, PCLE.CREATION_DATE
, PCLE.CREATED_BY
, PCLE.LAST_UPDATE_LOGIN
, PCLE.ATTRIBUTE_CATEGORY
, PCLE.ATTRIBUTE1
, PCLE.ATTRIBUTE2
, PCLE.ATTRIBUTE3
, PCLE.ATTRIBUTE4
, PCLE.ATTRIBUTE5
, PCLE.ATTRIBUTE6
, PCLE.ATTRIBUTE7
, PCLE.ATTRIBUTE8
, PCLE.ATTRIBUTE9
, PCLE.ATTRIBUTE10
, PCLE.ATTRIBUTE11
, PCLE.ATTRIBUTE12
, PCLE.ATTRIBUTE13
, PCLE.ATTRIBUTE14
, PCLE.ATTRIBUTE15
FROM PA_XC_PROJECT_DETAILS_V PXP
, PA_CONFIG_LIST_ELEMENTS PCLE
WHERE PXP.PROJECT_ID = PCLE.LIST_ELEMENT_ID (+)