[Home] [Help]
View: PA_PMC_RESOURCE_LISTS_V
Product: | PA - Projects |
Description: | This view is being used by WebConnect to retrieve all the resource lists. |
Implementation/DBA Data: |
APPS.PA_PMC_RESOURCE_LISTS_V
|
View Text
SELECT RL.RESOURCE_LIST_NAME
, RL.RESOURCE_LIST_ID
, RL.GROUPED_BY_RESOURCE_TYPE
, RL.GROUPED_BY_RESOURCE_TYPE_NAME
, RL.GROUPED_BY_RESOURCE_TYPE_ID
, RL.DESCRIPTION
, RL.START_DATE
, RL.END_DATE
FROM PA_QRY_RESOURCE_LISTS_V RL
Columns
Name |
RESOURCE_LIST_NAME |
RESOURCE_LIST_ID |
GROUPED_BY_RESOURCE_TYPE |
GROUPED_BY_RESOURCE_TYPE_NAME |
GROUPED_BY_RESOURCE_TYPE_ID |
DESCRIPTION |
START_DATE |
END_DATE |