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_AP_SALES_ORDERS_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MD.INVENTORY_ITEM_ID
, MD.ORGANIZATION_ID
, MD.PRIMARY_UOM_QUANTITY
, MD.RESERVATION_TYPE
, MD.RESERVATION_QUANTITY
, MD.DEMAND_SOURCE_TYPE
, MD.DEMAND_SOURCE_HEADER_ID
, MD.COMPLETED_QUANTITY
, MD.SUBINVENTORY
, MD.DEMAND_CLASS
, MD.REQUIREMENT_DATE
, MD.DEMAND_SOURCE_LINE
, MD.DEMAND_SOURCE_DELIVERY
, MD.DEMAND_SOURCE_NAME
, MD.PARENT_DEMAND_ID
, MD.DEMAND_ID
FROM MTL_DEMAND MD
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
WHERE MD.AVAILABLE_TO_ATP= 1
AND MD.ORGANIZATION_ID= MP.ORGANIZATION_ID
AND MD.INVENTORY_ITEM_ID= MSIK.INVENTORY_ITEM_ID
AND MD.ORGANIZATION_ID= MSIK.ORGANIZATION_ID

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
PRIMARY_UOM_QUANTITY
RESERVATION_TYPE
RESERVATION_QUANTITY
DEMAND_SOURCE_TYPE
DEMAND_SOURCE_HEADER_ID
COMPLETED_QUANTITY
SUBINVENTORY
DEMAND_CLASS
REQUIREMENT_DATE
DEMAND_SOURCE_LINE
DEMAND_SOURCE_DELIVERY
DEMAND_SOURCE_NAME
PARENT_DEMAND_ID
DEMAND_ID