[Home] [Help]
View: PA_RES_LISTS_IT
Product: | PA - Projects |
Description: | View of resource lists for the business group in implementation options for Oracle Project Analysis Collection Pack |
Implementation/DBA Data: |
APPS.PA_RES_LISTS_IT
|
View Text
SELECT RESOURCE_LIST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, NAME
, DESCRIPTION
, USER_COL1
, USER_COL2
, USER_COL3
, USER_COL4
, USER_COL5
, USER_COL6
, USER_COL7
, USER_COL8
, USER_COL9
, USER_COL10
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, STATUS_CODE
, BUSINESS_GROUP_ID
FROM PA_RES_LISTS_IT_ALL_BG
WHERE BUSINESS_GROUP_ID = PA_UTILS.BUSINESS_GROUP_ID
Columns
Name |
RESOURCE_LIST_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
NAME |
DESCRIPTION |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
STATUS_CODE |
BUSINESS_GROUP_ID |