View: PA_ADW_LOWEST_RLMEM_B_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_ADW_LOWEST_RLMEM_B_V

View Text

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'

Columns