VIEW: APPS.PA_QRY_RESOURCE_LISTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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