[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | An Integration Toolkit view supporting the information regarding the history of sales orders for the planned items. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
, ITEMS.ITEM_NUMBER
, LINES.LINE_ID
, LINES.LINE_NUMBER
, SOH.HEADER_ID
, SOH.ORDER_NUMBER || ':' || SOH.ORDER_TYPE_ID || ':' || FND_PROFILE.VALUE('OE_SOURCE_CODE')
, LINES.ORDER_QUANTITY_UOM
, LINES.ORDERED_QUANTITY
, LINES.CANCELLED_QUANTITY
, LINES.DEMAND_CLASS_CODE
, LINES.SCHEDULE_SHIP_DATE
, LINES.SHIP_SET_ID
, WSHSDV.SHIPPED_QUANTITY
, LINES.REQUEST_DATE
, LINES.SHIP_TO_ORG_ID
, DECODE(LINES.ATO_LINE_ID
, NULL
, 'N'
, 'Y')
, LINES.OPTION_FLAG
, LINES.SHIP_MODEL_COMPLETE_FLAG
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, LINES.SHIPPED_QUANTITY
, LINES.ACTUAL_SHIPMENT_DATE
, SOH.SOLD_TO_ORG_ID
, CUST.CUSTOMER_NAME
FROM RA_CUSTOMERS CUST
, WSH_SHIPPING_DETAILS_V WSHSDV
, OE_ORDER_LINES_ALL LINES
, OE_ORDER_HEADERS_ALL SOH
, MRP_RHX_PLANNED_ITEMS_V ITEMS
WHERE CUST.CUSTOMER_ID = SOH.SOLD_TO_ORG_ID
AND WSHSDV.ORDER_HEADER_ID = SOH.HEADER_ID
AND WSHSDV.ORDER_LINE_ID = LINES.LINE_ID
AND LINES.SHIPPED_QUANTITY IS NOT NULL
AND NVL(WSHSDV.SHIPPED_QUANTITY
, 0) > 0
AND SOH.HEADER_ID = LINES.HEADER_ID
AND WSHSDV.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND WSHSDV.WAREHOUSE_ID = ITEMS.ORGANIZATION_ID
AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'