VIEW: APPS.WIP_SALES_ORDER_LINES_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))