View: PAFV_RESOURCE_LIST_ASGN

Product:	PA - Projects
Description:	Business view to show information about the resource lists assigned to the projects.
Implementation/DBA Data:	APPS.PAFV_RESOURCE_LIST_ASGN

View Text

SELECT PRLA.RESOURCE_LIST_ASSIGNMENT_ID
, PRLA.RESOURCE_LIST_ID
, PRL.NAME
, PRLA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PRLA.LAST_UPDATE_DATE
, PRLA.LAST_UPDATED_BY
, PRLA.CREATION_DATE
, PRLA.CREATED_BY
FROM PA_RESOURCE_LIST_ASSIGNMENTS PRLA
, PA_PROJECTS_ALL PPA
, PA_RESOURCE_LISTS_ALL_BG PRL
WHERE PRLA.PROJECT_ID = PPA.PROJECT_ID AND PRLA.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns