[Home] [Help]
View: PAFV_RESOURCE_LISTS
Product: | PA - Projects |
Description: | Business view to show information about the resource lists. |
Implementation/DBA Data: |
APPS.PAFV_RESOURCE_LISTS
|
View Text
SELECT PRL.RESOURCE_LIST_ID
, PRL.NAME
, PRL.DESCRIPTION
, PRL.START_DATE_ACTIVE
, PRL.END_DATE_ACTIVE
, PRL.BUSINESS_GROUP_ID
, PBG.NAME
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATED_BY
, PRL.CREATION_DATE
, PRL.CREATED_BY
FROM PA_RESOURCE_LISTS_ALL_BG PRL
, PER_BUSINESS_GROUPS PBG
WHERE PRL.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID(+)
AND PRL.UNCATEGORIZED_FLAG <> 'Y' WITH READ ONLY
Columns
Name |
RESOURCE_LIST_ID |
NAME |
DESCRIPTION |
START_EFFECTVE_DATE |
END_EFFECTIVE_DATE |
BUSINESS_GROUP_ID |
BUSINESS_GROUP_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |