VIEW: APPS.PA_ADW_LOWEST_RLMEM_B_V

Source

View Text - Preformatted

SELECT PRLM.RESOURCE_LIST_MEMBER_ID , NVL(PRLM.PARENT_MEMBER_ID,PRLM.RESOURCE_LIST_MEMBER_ID) PARENT_MEMBER_ID , PR.NAME || ' (' || PTRM.NAME || ')' , PRLM.ALIAS || ' (' || PTRM.ALIAS || ')' , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRLM.ADW_NOTIFY_FLAG FROM PA_RESOURCE_LIST_MEMBERS PRLM, PA_RESOURCES PR, PA_ADW_TOP_RLMEM_B_V PTRM WHERE PR.RESOURCE_ID = PRLM.RESOURCE_ID AND PTRM.RESOURCE_LIST_MEMBER_ID = PRLM.PARENT_MEMBER_ID AND NOT EXISTS ( SELECT 'Yes' FROM PA_RESOURCE_LIST_MEMBERS PRLMC WHERE PRLMC.PARENT_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID ) UNION SELECT PTRM.RESOURCE_LIST_MEMBER_ID, PTRM.RESOURCE_LIST_MEMBER_ID, PTRM.NAME || ' (' || PLC.MEANING || ')', PTRM.ALIAS || ' (' || PLC.MEANING || ')', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, PTRM.ADW_NOTIFY_FLAG FROM PA_ADW_TOP_RLMEM_B_V PTRM, PA_LOOKUPS PLC WHERE PLC.LOOKUP_TYPE = 'ADW RESOURCE NAME' AND PLC.LOOKUP_CODE = 'CHILD'

View Text - HTML Formatted

SELECT PRLM.RESOURCE_LIST_MEMBER_ID
, NVL(PRLM.PARENT_MEMBER_ID
, PRLM.RESOURCE_LIST_MEMBER_ID) PARENT_MEMBER_ID
, PR.NAME || ' (' || PTRM.NAME || ')'
, PRLM.ALIAS || ' (' || PTRM.ALIAS || ')'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PRLM.ADW_NOTIFY_FLAG
FROM PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
, PA_ADW_TOP_RLMEM_B_V PTRM
WHERE PR.RESOURCE_ID = PRLM.RESOURCE_ID
AND PTRM.RESOURCE_LIST_MEMBER_ID = PRLM.PARENT_MEMBER_ID
AND NOT EXISTS ( SELECT 'YES'
FROM PA_RESOURCE_LIST_MEMBERS PRLMC
WHERE PRLMC.PARENT_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID ) UNION SELECT PTRM.RESOURCE_LIST_MEMBER_ID
, PTRM.RESOURCE_LIST_MEMBER_ID
, PTRM.NAME || ' (' || PLC.MEANING || ')'
, PTRM.ALIAS || ' (' || PLC.MEANING || ')'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PTRM.ADW_NOTIFY_FLAG
FROM PA_ADW_TOP_RLMEM_B_V PTRM
, PA_LOOKUPS PLC
WHERE PLC.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLC.LOOKUP_CODE = 'CHILD'