[Home] [Help]
View: WIP_PCB_DEPT_RESOURCES_V
View Text
SELECT BD.ORGANIZATION_ID
, BD.DEPARTMENT_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID WITH READ ONLY
Columns
Name |
ORGANIZATION_ID |
DEPARTMENT_ID |
RESOURCE_ID |
RESOURCE_CODE |