[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 |
APPS.PABV_RESOURCE_LIST_RESOURCES