Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Tuesday, January 18, 2011

[WIP] Main Tables for Work In Process (WIP) Job

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'

No comments:

Post a Comment