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: INV.MTL_DEMAND_HISTORIES

Object Details

Object Name:	MTL_DEMAND_HISTORIES
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_DEMAND_HISTORIES
Subobject Name:
Status:	VALID

MTL_DEMAND_HISTORIES stores summarized transaction history from
MTL_MATERIAL_TRANSACTIONS. This summarized history serves as the
input for forecasting future material usage.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_DEMAND_HISTORIES_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	INVENTORY_ITEM_ID PERIOD_TYPE ORGANIZATION_ID PERIOD_START_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
PERIOD_START_DATE	DATE		Yes	Demand/usage previous period starting date
PERIOD_TYPE	NUMBER		Yes	Period used to summarized demand
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
STD_WIP_USAGE	NUMBER		Yes	Quantity issued to WIP jobs during period
CLOSED_FLAG	VARCHAR2	(1)		Flag calendar periods that have been summarized and "frozen"
SALES_ORDER_DEMAND	NUMBER		Yes	Quantity shipped during period
MISCELLANEOUS_ISSUE	NUMBER		Yes	Quantity issued to accounts, account aliases, and user-defined during period
INTERORG_ISSUE	NUMBER		Yes	Quantity issued to intransit and inter-organization transactions during period
C_COLUMN1	VARCHAR2	(240)		(not currently used)
C_COLUMN2	VARCHAR2	(240)		(not currently used)
C_COLUMN3	VARCHAR2	(240)		(not currently used)
C_COLUMN4	VARCHAR2	(240)		(not currently used)
C_COLUMN5	VARCHAR2	(240)		(not currently used)
N_COLUMN1	NUMBER			(not currently used)
N_COLUMN2	NUMBER			(not currently used)
N_COLUMN3	NUMBER			(not currently used)
N_COLUMN4	NUMBER			(not currently used)
N_COLUMN5	NUMBER			(not currently used)
D_COLUMN1	DATE			(not currently used)
D_COLUMN2	DATE			(not currently used)
D_COLUMN3	DATE			(not currently used)
D_COLUMN4	DATE			(not currently used)
D_COLUMN5	DATE			(not currently used)
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_START_DATE
,      PERIOD_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STD_WIP_USAGE
,      CLOSED_FLAG
,      SALES_ORDER_DEMAND
,      MISCELLANEOUS_ISSUE
,      INTERORG_ISSUE
,      C_COLUMN1
,      C_COLUMN2
,      C_COLUMN3
,      C_COLUMN4
,      C_COLUMN5
,      N_COLUMN1
,      N_COLUMN2
,      N_COLUMN3
,      N_COLUMN4
,      N_COLUMN5
,      D_COLUMN1
,      D_COLUMN2
,      D_COLUMN3
,      D_COLUMN4
,      D_COLUMN5
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM INV.MTL_DEMAND_HISTORIES;

Dependencies

[top of page]

INV.MTL_DEMAND_HISTORIES does not reference any database object

INV.MTL_DEMAND_HISTORIES is referenced by following:

INV: MTL_DEMAND_HISTORIES#