Oracle Work In Process (WIP)

Oracle Work in Process is a complete production management system.

On a balance sheet, work in progress is considered to be an asset because money has been spent towards a completed product. Because the product has not been completed, however, WIP is valued lower. 

Tables:

WIP_DISCRETE_JOBS_V - work order main info

WIP_REQUIREMENT_OPERATIONS - material and resource requirements

SELECT * FROM apps.WIP_DISCRETE_JOBS_V 
WHERE WIP_ENTITY_NAME = '277409'; -- Work Order / Job

SELECT * FROM apps.WIP_REQUIREMENT_OPERATIONS WHERE WIP_ENTITY_ID = 288002;

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';

Issue #1 - Item / Component does not show up in the WIP Component Issue screen / LOV
Solution - One of the prerequisites for this is that the item should’ve the ‘BOM Allowed’ flag enabled.