WIP_DISCRETE_JOBS_V - work order main info
WIP_REQUIREMENT_OPERATIONS - material and resource requirements
Sample codes:
SELECT MSI.SEGMENT1 AS "PART NO", WDJ.WIP_ENTITY_NAME, WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED
FROM WIP_REQUIREMENT_OPERATIONS WRO, WIP_DISCRETE_JOBS_V WDJ,
MTL_SYSTEM_ITEMS MSI
WHERE WRO.REQUIRED_QUANTITY-WRO.QUANTITY_ISSUED>0
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND WRO.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND WRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'
WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED
FROM WIP_REQUIREMENT_OPERATIONS WRO, WIP_DISCRETE_JOBS_V WDJ,
MTL_SYSTEM_ITEMS MSI
WHERE WRO.REQUIRED_QUANTITY-WRO.
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.
AND WRO.ORGANIZATION_ID=MSI.
AND WRO.INVENTORY_ITEM_ID=MSI.
AND WRO.WIP_ENTITY_ID=WDJ.WIP_
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'
No comments:
Post a Comment