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.MRP_ATP_SUPPLY_DEMAND#

Source

View Text - Preformatted


select SOURCE_IDENTIFIER1 SOURCE_IDENTIFIER1, SOURCE_IDENTIFIER2 SOURCE_IDENTIFIER2, SOURCE_IDENTIFIER3 SOURCE_IDENTIFIER3, SOURCE_IDENTIFIER4 SOURCE_IDENTIFIER4, ORGANIZATION_ID ORGANIZATION_ID, PLAN_ID PLAN_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, FROM_LOCATION_ID FROM_LOCATION_ID, TO_LOCATION_ID TO_LOCATION_ID, SHIP_METHOD SHIP_METHOD, UOM UOM, SUPPLY_DEMAND_DATE SUPPLY_DEMAND_DATE, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE, SUPPLY_DEMAND_QUANTITY SUPPLY_DEMAND_QUANTITY, RESERVATION_QUANTITY RESERVATION_QUANTITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, DEMAND_CLASS DEMAND_CLASS, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE, PRODUCT_FAMILY_ITEM_ID PRODUCT_FAMILY_ITEM_ID, WEIGHT_CAPACITY WEIGHT_CAPACITY, VOLUME_CAPACITY VOLUME_CAPACITY, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, REFRESH_NUMBER REFRESH_NUMBER from "MRP"."MRP_ATP_SUPPLY_DEMAND"

View Text - HTML Formatted

SELECT SOURCE_IDENTIFIER1 SOURCE_IDENTIFIER1
, SOURCE_IDENTIFIER2 SOURCE_IDENTIFIER2
, SOURCE_IDENTIFIER3 SOURCE_IDENTIFIER3
, SOURCE_IDENTIFIER4 SOURCE_IDENTIFIER4
, ORGANIZATION_ID ORGANIZATION_ID
, PLAN_ID PLAN_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, FROM_LOCATION_ID FROM_LOCATION_ID
, TO_LOCATION_ID TO_LOCATION_ID
, SHIP_METHOD SHIP_METHOD
, UOM UOM
, SUPPLY_DEMAND_DATE SUPPLY_DEMAND_DATE
, SUPPLY_DEMAND_SOURCE_TYPE SUPPLY_DEMAND_SOURCE_TYPE
, SUPPLY_DEMAND_QUANTITY SUPPLY_DEMAND_QUANTITY
, RESERVATION_QUANTITY RESERVATION_QUANTITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, DEMAND_CLASS DEMAND_CLASS
, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE
, PRODUCT_FAMILY_ITEM_ID PRODUCT_FAMILY_ITEM_ID
, WEIGHT_CAPACITY WEIGHT_CAPACITY
, VOLUME_CAPACITY VOLUME_CAPACITY
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, REFRESH_NUMBER REFRESH_NUMBER
FROM "MRP"."MRP_ATP_SUPPLY_DEMAND"