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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MRP.MRP_FORECAST_UPDATES

Object Details

Object Name:	MRP_FORECAST_UPDATES
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_FORECAST_UPDATES
Subobject Name:
Status:	VALID

MRP_FORECAST_UPDATES tracks forecast consumptions. Each entry
represents a consumption that took place for a particular forecast
entry, as a result of the entry of a sales order.
.
TRANSACTION_ID identifies the specific entry in MRP_FORECAST_DATES
that was consumed. The UPDATE_SALES_ORDER stores the identifier of
the sales order that generated the consumption. The
SALES_ORDER_SCHEDULE_DATE stores the date for that sales order. The
FORECAST_UPDATE_DATE and UPDATE_QUANTITY store the date of the
forecast that was consumed and the quantity of the sales order that
was applied to consume the forecast.
.
This table is populated during forecast consumption, which is
performed by the Planning Manager.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_FORECAST_UPDATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID FORECAST_DESIGNATOR INVENTORY_ITEM_ID UPDATE_SALES_ORDER SALES_ORDER_SCHEDULE_DATE
MRP_FORECAST_UPDATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MRP_FORECAST_UPDATES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
FORECAST_DESIGNATOR	VARCHAR2	(10)	Yes	Item forecast identifier
UPDATE_SALES_ORDER	NUMBER		Yes	Update sales order
SALES_ORDER_SCHEDULE_DATE	DATE		Yes	Updated schedule date
FORECAST_UPDATE_DATE	DATE		Yes	Forecast date revised
SALES_ORDER_QUANTITY	NUMBER		Yes	Sales order quantity
DEMAND_CLASS	VARCHAR2	(30)		Demand class identifier
UPDATE_QUANTITY	NUMBER		Yes	Forecast quantity consumed by sales order
CUSTOMER_ID	NUMBER			Forecast customer identifier
SHIP_ID	NUMBER			Forecast ship code identifier
BILL_ID	NUMBER			Forecast billing address identifier
LINE_NUM	VARCHAR2	(30)		Line number of sales order
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
UPDATE_SEQ_NUM	NUMBER			Update sequence number

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

MRP.MRP_FORECAST_UPDATES does not reference any database object

MRP.MRP_FORECAST_UPDATES is referenced by following:

APPS: MRP_FORECAST_UPDATES