[Home] [Help]
View: WIP_PCB_RES_INST_EQUIPMENTS_V
View Text
SELECT BD.ORGANIZATION_ID
, BD.DEPARTMENT_ID
, BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BREQ.INSTANCE_ID
, MSIK.CONCATENATED_SEGMENTS
, MSN.SERIAL_NUMBER
, MSIK.CONCATENATED_SEGMENTS || ':' || MSN.SERIAL_NUMBER "NODE_LABEL"
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, BOM_RESOURCE_EQUIPMENTS BREQ
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_SERIAL_NUMBERS MSN
WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID
AND BD.DEPARTMENT_ID = BDR.DEPARTMENT_ID
AND BREQ.RESOURCE_ID = BDR.RESOURCE_ID
AND BR.RESOURCE_TYPE = 1
AND MSIK.INVENTORY_ITEM_ID = BREQ.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = BREQ.ORGANIZATION_ID
AND MSN.INVENTORY_ITEM_ID = BREQ.INVENTORY_ITEM_ID WITH READ ONLY
Columns
Name |
ORGANIZATION_ID |
DEPARTMENT_ID |
RESOURCE_ID |
RESOURCE_CODE |
INSTANCE_ID |
INSTANCE_NAME |
SERIAL_NUMBER |
NODE_LABEL |