Product: | WIP - Work in Process |
---|---|
Description: | This view is used to retrieve sales orders that are not reserved. |
Implementation/DBA Data: | APPS.WIP_OPEN_DEMANDS_V |
SELECT OWODV.ORGANIZATION_ID
, OWODV.DEMAND_SOURCE_HEADER_ID
, OWODV.DEMAND_ORDER_HEADER_ID
, OWODV.DEMAND_SOURCE_LINE_ID
, OWODV.DEMAND_SOURCE_LINE_NUMBER
, OWODV.REQUIREMENT_DATE
, OWODV.INVENTORY_ITEM_ID
, OWODV.DEMAND_CLASS_CODE
, OWODV.DEMAND_UOM_CODE
, OWODV.DEMAND_OPEN_QUANTITY
, /* 10 */ MSI.PRIMARY_UOM_CODE
, INV_CONVERT.INV_UM_CONVERT(OWODV.INVENTORY_ITEM_ID
, 6
, OWODV.DEMAND_OPEN_QUANTITY
, OWODV.DEMAND_UOM_CODE
, MSI.PRIMARY_UOM_CODE
, NULL
, NULL)
, MSI.REPLENISH_TO_ORDER_FLAG /* 13 */
FROM OE_WIP_OPEN_DEMANDS_V OWODV
, MTL_SYSTEM_ITEMS MSI
WHERE MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND MSI.BOM_ITEM_TYPE = 4 /* STANDARD */
AND MSI.ORGANIZATION_ID = OWODV.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = OWODV.INVENTORY_ITEM_ID