View: PA_RESOURCE_LISTS_ACTIVE_V

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

View Text

SELECT A.RESOURCE_LIST_ID
, A.NAME
, A.PUBLIC_FLAG
, A.GROUP_RESOURCE_TYPE_ID
, A.RESOURCE_LIST_TYPE
, A.MIGRATION_CODE
, A.BUSINESS_GROUP_ID
FROM PA_RESOURCE_LISTS A
WHERE A.PUBLIC_FLAG = 'Y'
AND A.UNCATEGORIZED_FLAG = 'N'
AND TRUNC(SYSDATE) BETWEEN A.START_DATE_ACTIVE
AND NVL(A.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND EXISTS (SELECT 'X'
FROM PA_RESOURCE_LIST_MEMBERS B
WHERE A.RESOURCE_LIST_ID = B.RESOURCE_LIST_ID
AND B.ENABLED_FLAG = 'Y'
AND B.DISPLAY_FLAG = 'Y' )

Columns