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


VIEW: INV.MTL_SEASONALITY_INDICES#

Object Details
Object Name: MTL_SEASONALITY_INDICES#
Object Type: VIEW
Owner: INV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_RULE_ID NUMBER
Yes
PERIOD_NUM NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

SEASONALITY_INDEX NUMBER
Yes
PERIOD_TYPE_CODE NUMBER

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# references the following:

SchemaINV
TableMTL_SEASONALITY_INDICES
INV.MTL_SEASONALITY_INDICES# is referenced by following:

SchemaAPPS
SynonymMTL_SEASONALITY_INDICES