[Home] [Help]
View: PA_ADW_TOP_RLMEM_B_V
View Text
SELECT PRLM.RESOURCE_LIST_MEMBER_ID
, PRLM.RESOURCE_LIST_ID
, PR.NAME
, PRLM.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_RES_LISTS_B_V PRL
WHERE PR.RESOURCE_ID = PRLM.RESOURCE_ID
AND PRLM.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND NVL(PRLM.PARENT_MEMBER_ID
, 0 ) = 0
Columns
Name |
RESOURCE_LIST_MEMBER_ID |
RESOURCE_LIST_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 |