View: PAFV_RESOURCE_LIST_RESOURCES

Product:	PA - Projects
Description:	Business view to show information about the resources used in the resource lists.
Implementation/DBA Data:	APPS.PAFV_RESOURCE_LIST_RESOURCES

View Text

SELECT PRLM.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, '_LA:PRLM.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PRLM.TRACK_AS_LABOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PRLM.PARENT_MEMBER_ID
, PRLM.RESOURCE_ID
, PR.NAME
, PRLM.RESOURCE_LIST_ID
, PRLA.NAME
, PRT.NAME
, PRLM.LAST_UPDATE_DATE
, PRLM.LAST_UPDATED_BY
, PRLM.CREATION_DATE
, PRLM.CREATED_BY
FROM PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
, PA_RESOURCE_TYPES PRT
, PA_RESOURCE_LISTS_ALL_BG PRLA
WHERE PRLM.RESOURCE_LIST_ID = PRLA.RESOURCE_LIST_ID AND PRLM.RESOURCE_ID = PR.RESOURCE_ID
AND PR.RESOURCE_TYPE_ID = PRT.RESOURCE_TYPE_ID
AND PRT.RESOURCE_TYPE_CODE NOT IN ('UNCATEGORIZED'
, 'UNCLASSIFIED') WITH READ ONLY

Columns