VIEW: APPS.PA_RESOURCE_LISTS_ACTIVE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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