View: WIP_OPEN_DEMANDS_V

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

View Text

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

Columns