View: PA_RESOURCE_LIST_ASSIGNMENTS_V

Product:	PA - Projects
Description:	Resource list assignments to self service budget and workplan.
Implementation/DBA Data:	APPS.PA_RESOURCE_LIST_ASSIGNMENTS_V

View Text

SELECT DISTINCT RESOURCE_LIST_ID
, PROJECT_ID
, PA_FIN_PLAN_UTILS.IS_WP_RESOURCE_LIST(PROJECT_ID
, RESOURCE_LIST_ID) USED_FOR_WP_FLAG
, PA_FIN_PLAN_UTILS.IS_FP_RESOURCE_LIST(PROJECT_ID
, RESOURCE_LIST_ID) USED_FOR_FP_FLAG
FROM PA_PROJ_FP_OPTIONS A
, PA_RESOURCE_LISTS_ALL_BG B
WHERE (A.COST_RESOURCE_LIST_ID = B.RESOURCE_LIST_ID OR A.REVENUE_RESOURCE_LIST_ID = B.RESOURCE_LIST_ID OR A.ALL_RESOURCE_LIST_ID = B.RESOURCE_LIST_ID)

Columns