VIEW: APPS.PA_RESOURCE_LIST_GROUPS_V

Source

View Text - Preformatted

SELECT RL.NAME , RL.RESOURCE_LIST_ID , RLM.ALIAS , RLM.RESOURCE_LIST_MEMBER_ID , RLM.SORT_ORDER , RLM.ENABLED_FLAG FROM PA_RESOURCE_LISTS RL, PA_RESOURCE_LIST_MEMBERS RLM WHERE RL.GROUP_RESOURCE_TYPE_ID <> 0 AND RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID and nvl(rlm.migration_code, '-99') <> 'N' AND RLM.PARENT_MEMBER_ID IS NULL AND RLM.DISPLAY_FLAG = 'Y'

View Text - HTML Formatted

SELECT RL.NAME
, RL.RESOURCE_LIST_ID
, RLM.ALIAS
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.SORT_ORDER
, RLM.ENABLED_FLAG
FROM PA_RESOURCE_LISTS RL
, PA_RESOURCE_LIST_MEMBERS RLM
WHERE RL.GROUP_RESOURCE_TYPE_ID <> 0
AND RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID
AND NVL(RLM.MIGRATION_CODE
, '-99') <> 'N'
AND RLM.PARENT_MEMBER_ID IS NULL
AND RLM.DISPLAY_FLAG = 'Y'