View: WIP_SALES_ORDER_LINES_V

Product:	WIP - Work in Process
Description:	Sales order lines
Implementation/DBA Data:	APPS.WIP_SALES_ORDER_LINES_V

View Text

SELECT MD.DEMAND_SOURCE_LINE
, MD.USER_LINE_NUM
, MD.DEMAND_SOURCE_DELIVERY
, MD.USER_DELIVERY
, MD.REQUIREMENT_DATE
, MD.PRIMARY_UOM_QUANTITY
, MD.LINE_ITEM_QUANTITY / MD.PRIMARY_UOM_QUANTITY UOM_CONVERSION_RATE
, MD.UOM_CODE
, MD.INVENTORY_ITEM_ID
, MD.DEMAND_CLASS
, MD.SUBINVENTORY
, MD.DEMAND_SOURCE_HEADER_ID
, MD.ORGANIZATION_ID
FROM MTL_DEMAND MD
, MTL_SYSTEM_ITEMS MSI
WHERE MD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MD.ORGANIZATION_ID
AND MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.BOM_ITEM_TYPE = 4
AND MD.RESERVATION_TYPE = 1
AND MD.ROW_STATUS_FLAG = 1
AND MD.PARENT_DEMAND_ID IS NOT NULL
AND MD.COMPLETED_QUANTITY < MD.PRIMARY_UOM_QUANTITY
AND MD.PRIMARY_UOM_QUANTITY > 0
AND MD.SUPPLY_GROUP_ID IS NULL
AND MD.DEMAND_SOURCE_TYPE = 2
AND MD.SUPPLY_SOURCE_HEADER_ID IS NULL
AND ((MD.CONFIG_STATUS = 20
AND MD.DEMAND_TYPE = 4) OR (MD.CONFIG_STATUS = 20
AND NVL(MD.DEMAND_TYPE
, 6) = 6))

Columns