eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_RHX_SALES_ORDERS_V

Product:	MRP - Master Scheduling/MRP
Description:	An Integration Toolkit view supporting information regarding the sales order demand for planned items.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
, ITEMS.ITEM_NUMBER
, DEM.DEMAND_SOURCE_HEADER_ID
, DEM.DEMAND_SOURCE_LINE
, MIN( DEM.REQUIREMENT_DATE)
, SO.SEGMENT1 || ':' || SO.SEGMENT2 || ':' || SO.SEGMENT3
, DEM.UOM_CODE
, SUM( DEM.PRIMARY_UOM_QUANTITY)
, SUM( DEM.COMPLETED_QUANTITY)
, SUM(DEM.RESERVATION_QUANTITY)
, DEM.DEMAND_SOURCE_TYPE
, MIN(DEM.MRP_DATE)
, SUM( DEM.MRP_QUANTITY)
, DEM.DEMAND_CLASS
, DEM.USER_LINE_NUM
, DEM.USER_LINE_NUM
, DEM.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, DEM.RESERVATION_TYPE
, DEM.SHIP_TO_SITE_USE_ID
, DEM.BILL_TO_SITE_USE_ID
, SL.ATTRIBUTE1
, SL.ATTRIBUTE2
, SL.ATTRIBUTE3
, SL.ATTRIBUTE4
, SL.ATTRIBUTE5
, SL.ATTRIBUTE6
, SL.ATTRIBUTE7
, SL.ATTRIBUTE8
, SL.ATTRIBUTE9
, SL.ATTRIBUTE10
, SL.ATTRIBUTE11
, SL.ATTRIBUTE12
, SL.ATTRIBUTE13
, SL.ATTRIBUTE14
, SL.ATTRIBUTE15
FROM RA_CUSTOMERS CUST
, MTL_SALES_ORDERS SO
, MTL_DEMAND_OMOE DEM
, MRP_RHX_PLANNED_ITEMS_V ITEMS
, OE_ORDER_LINES_ALL SL
WHERE CUST.CUSTOMER_ID = DEM.CUSTOMER_ID
AND DEM.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND DEM.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND DEM.DEMAND_SOURCE_HEADER_ID = SO.SALES_ORDER_ID
AND DEM.PRIMARY_UOM_QUANTITY > NVL(DEM.COMPLETED_QUANTITY
, 0)
AND DEM.AVAILABLE_TO_MRP = 1
AND DEM.CUSTOMER_ID IS NOT NULL
AND DEM.PARENT_DEMAND_ID IS NOT NULL
AND DEM.SHIP_TO_SITE_USE_ID IS NOT NULL
AND DEM.BILL_TO_SITE_USE_ID IS NOT NULL
AND DEM.DEMAND_SOURCE_TYPE IN (2
, 8)
AND SL.LINE_ID = DEM.DEMAND_SOURCE_LINE
AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT' GROUP BY ITEMS.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
, ITEMS.ITEM_NUMBER
, DEM.DEMAND_SOURCE_HEADER_ID
, DEM.DEMAND_SOURCE_LINE
, SO.SEGMENT1 || ':' || SO.SEGMENT2 || ':' || SO.SEGMENT3
, DEM.UOM_CODE
, DEM.DEMAND_SOURCE_TYPE
, DEM.DEMAND_CLASS
, DEM.USER_LINE_NUM
, DEM.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, DEM.RESERVATION_TYPE
, DEM.SHIP_TO_SITE_USE_ID
, DEM.BILL_TO_SITE_USE_ID
, SL.ATTRIBUTE1
, SL.ATTRIBUTE2
, SL.ATTRIBUTE3
, SL.ATTRIBUTE4
, SL.ATTRIBUTE5
, SL.ATTRIBUTE6
, SL.ATTRIBUTE7
, SL.ATTRIBUTE8
, SL.ATTRIBUTE9
, SL.ATTRIBUTE10
, SL.ATTRIBUTE11
, SL.ATTRIBUTE12
, SL.ATTRIBUTE13
, SL.ATTRIBUTE14
, SL.ATTRIBUTE15

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
ITEM_NUMBER
SALES_ORDER_ID
LINE_ID
REQUIREMENT_DATE
SALES_ORDER_NUMBER
UOM_CODE
PRIMARY_UOM_QUANTITY
COMPLETED_QUANTITY
RESERVATION_QUANTITY
DEMAND_SOURCE_TYPE
MRP_DATE
MRP_QUANTITY
DEMAND_CLASS
LINE_NUMBER
USER_DELIVERY
CUSTOMER_ID
CUSTOMER_NAME
RESERVATION_TYPE
SHIP_TO_SITE_USE_ID
BILL_TO_SITE_USE_ID
SO_LINE_ATTRIBUTE1
SO_LINE_ATTRIBUTE2
SO_LINE_ATTRIBUTE3
SO_LINE_ATTRIBUTE4
SO_LINE_ATTRIBUTE5
SO_LINE_ATTRIBUTE6
SO_LINE_ATTRIBUTE7
SO_LINE_ATTRIBUTE8
SO_LINE_ATTRIBUTE9
SO_LINE_ATTRIBUTE10
SO_LINE_ATTRIBUTE11
SO_LINE_ATTRIBUTE12
SO_LINE_ATTRIBUTE13
SO_LINE_ATTRIBUTE14
SO_LINE_ATTRIBUTE15