FND Design Data [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: ViewAPPS.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