[Home] [Help]
View: WIP_ON_DISCRETE_JOBS_V
View Text
SELECT WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.ORGANIZATION_ID
, WDJ.PRIMARY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, WDJ.START_QUANTITY
, WDJ.LOT_NUMBER
, WDJ.QUANTITY_COMPLETED
FROM WIP_ENTITIES WE
, MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_DISCRETE_JOBS WDJ
WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
Columns
Name |
WIP_ENTITY_ID |
WIP_ENTITY_NAME |
ORGANIZATION_ID |
PRIMARY_ITEM_ID |
CONCATENATED_SEGMENTS |
START_QUANTITY |
LOT_NUMBER |
QUANTITY_COMPLETED |