View: PA_BUDGET_RESOURCE_LISTS_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_BUDGET_RESOURCE_LISTS_V

View Text

SELECT TO_NUMBER(NULL)
, RESOURCE_LIST_ID
, NAME
FROM PA_RESOURCE_LISTS A
WHERE NOT EXISTS (SELECT RESOURCE_LIST_ID
FROM PA_RESOURCE_LIST_ASSIGNMENTS B
WHERE A.RESOURCE_LIST_ID = B.RESOURCE_LIST_ID)
AND NVL(UNCATEGORIZED_FLAG
, 'N') = 'N' UNION SELECT A.PROJECT_ID
, A.RESOURCE_LIST_ID
, B.NAME
FROM PA_RESOURCE_LIST_ASSIGNMENTS A
, PA_RESOURCE_LISTS B
WHERE A.RESOURCE_LIST_ID = B.RESOURCE_LIST_ID
AND NVL(B.UNCATEGORIZED_FLAG
, 'N' ) = 'N'

Columns