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'
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'
|
|
|