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_SEASONALITY_INDICES

Object Details

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

MTL_SEASONALITY_INDICES maintains the initial seasonality indices for
for each calendar period. There could be 12 or 13 calendar periods in
a year. The number of calendar periods in a year depends on if users
compile the calendar by the 445 weekly quarter pattern, 544 weekly
quarter pattern, 13 period calendar, or regular calendar months.
.
.
A seasonality index is an indication of the degree of seasonal
variation for a product. An index is an estimate of how much the
demand during the season will be above or below the average demand for
the product. For example, 0.8 means 80 percent of the average demand
for a particular season.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_SEASONALITY_INDICES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORECAST_RULE_ID PERIOD_NUM

Columns

Name	Datatype	Mandatory	Comments
FORECAST_RULE_ID	NUMBER	Yes	Identifier for forecast rule
PERIOD_NUM	NUMBER	Yes	Seasonality period number
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
SEASONALITY_INDEX	NUMBER	Yes	Seasonality factor
PERIOD_TYPE_CODE	NUMBER		Period bucket type

Query Text

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


SELECT FORECAST_RULE_ID
,      PERIOD_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SEASONALITY_INDEX
,      PERIOD_TYPE_CODE
FROM INV.MTL_SEASONALITY_INDICES;

Dependencies

[top of page]

INV.MTL_SEASONALITY_INDICES does not reference any database object

INV.MTL_SEASONALITY_INDICES is referenced by following:

APPS: MTL_SEASONALITY_INDICES