[Home] [Help]
View: 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
Name |
RESOURCE_LIST_MEMBER_ID |
PARENT_MEMBER_ID |
NAME |
ALIAS |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
ADW_NOTIFY_FLAG |