VIEW: MRP.MRP_FORECAST_UPDATES#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, FORECAST_DESIGNATOR FORECAST_DESIGNATOR, UPDATE_SALES_ORDER UPDATE_SALES_ORDER, SALES_ORDER_SCHEDULE_DATE SALES_ORDER_SCHEDULE_DATE, FORECAST_UPDATE_DATE FORECAST_UPDATE_DATE, SALES_ORDER_QUANTITY SALES_ORDER_QUANTITY, DEMAND_CLASS DEMAND_CLASS, UPDATE_QUANTITY UPDATE_QUANTITY, CUSTOMER_ID CUSTOMER_ID, SHIP_ID SHIP_ID, BILL_ID BILL_ID, LINE_NUM LINE_NUM, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, UPDATE_SEQ_NUM UPDATE_SEQ_NUM from "MRP"."MRP_FORECAST_UPDATES"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, FORECAST_DESIGNATOR FORECAST_DESIGNATOR
, UPDATE_SALES_ORDER UPDATE_SALES_ORDER
, SALES_ORDER_SCHEDULE_DATE SALES_ORDER_SCHEDULE_DATE
, FORECAST_UPDATE_DATE FORECAST_UPDATE_DATE
, SALES_ORDER_QUANTITY SALES_ORDER_QUANTITY
, DEMAND_CLASS DEMAND_CLASS
, UPDATE_QUANTITY UPDATE_QUANTITY
, CUSTOMER_ID CUSTOMER_ID
, SHIP_ID SHIP_ID
, BILL_ID BILL_ID
, LINE_NUM LINE_NUM
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UPDATE_SEQ_NUM UPDATE_SEQ_NUM
FROM "MRP"."MRP_FORECAST_UPDATES"