View: PA_QRY_RESOURCE_LISTS_V

Product:	PA - Projects
Description:	This view displays all the valid Resource Lists that have been defined
Implementation/DBA Data:	APPS.PA_QRY_RESOURCE_LISTS_V

View Text

SELECT RL.NAME
, RL.RESOURCE_LIST_ID
, RG.RESOURCE_GROUP
, RG.RESOURCE_GROUP_NAME
, RL.GROUP_RESOURCE_TYPE_ID
, RL.DESCRIPTION
, RL.START_DATE_ACTIVE
, RL.END_DATE_ACTIVE
, RL.CONTROL_FLAG
FROM PA_RESOURCE_LISTS RL
, PA_RESOURCE_GROUPS_VALID_V RG
WHERE NVL(RL.UNCATEGORIZED_FLAG
, 'N') <> 'Y'
AND RL.GROUP_RESOURCE_TYPE_ID = RG.GROUP_RESOURCE_TYPE_ID

Columns