[Home] [Help]
View: PABV_RESOURCE_LIST_RESOURCES
View Text
SELECT PRLM.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, '_LA:PRLM.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:PRLM.TRACK_AS_LABOR_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PRLM.PARENT_MEMBER_ID
, PRLM.RESOURCE_ID
, PRLM.RESOURCE_LIST_ID
, PRLM.LAST_UPDATE_DATE
, PRLM.LAST_UPDATED_BY
, PRLM.CREATION_DATE
, PRLM.CREATED_BY
FROM PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
, PA_RESOURCE_LISTS_ALL_BG PRLA
, PA_RESOURCE_TYPES PRT
WHERE PRLM.RESOURCE_LIST_ID = PRLA.RESOURCE_LIST_ID
AND PRLM.RESOURCE_ID = PR.RESOURCE_ID
AND PR.RESOURCE_TYPE_ID = PRT.RESOURCE_TYPE_ID
AND PRT.RESOURCE_TYPE_CODE NOT IN ('UNCATEGORIZED'
, 'UNCLASSIFIED') WITH READ ONLY
Columns
Name |
RESOURCE_LIST_MEMBER_ID |
ALIAS |
"_LA:ENABLED_FLAG" |
"_LA:TRACK_AS_LABOR_FLAG" |
PARENT_MEMBER_ID |
RESOURCE_ID |
RESOURCE_LIST_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |