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

TABLE: MSC.MSC_REGION_ITEM_ATTRIBUTES

Object Details
Object Name: MSC_REGION_ITEM_ATTRIBUTES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This table is currently not in Use.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_REGION_ITEM_ATTRIBUTES_N1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSIMULATION_SET_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnREGION_ID
Columns
Name Datatype Length Mandatory Comments
SIMULATION_SET_ID NUMBER
Yes Simulation Set Id
PLAN_ID NUMBER
Yes Plan Id
SR_INSTANCE_ID NUMBER
Yes Sr Instance Id
ORGANIZATION_ID NUMBER
Yes Organization Id
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Id
REGION_ID NUMBER
Yes Region ID
REGION_INSTANCE_ID NUMBER
Yes Region Instance ID
REGION VARCHAR2 (240) Yes Region
FORECAST_RULE_FOR_DEMANDS VARCHAR2 (240)
Forecast Rule for Demands
FORECAST_RULE_FOR_RETURNS NUMBER

Forecast Rule for Returns
END_OF_LIFE_DATE DATE

End of Life Date
LIFE_TIME_BUY_DATE DATE

Life Time Buy Date
AVG_DEMAND_BEYOND_PH NUMBER

Average Demand Beyond PH
AVG_RETURNS_BEYOND_PH NUMBER

Average Returns beyond PH
RETURN_FORECAST_TIME_FENCE NUMBER

Return Forecast Time Fence
AVERAGE_DAILY_DEMAND NUMBER

Average Daily Demand
DEFECTIVE_ITEM_COST NUMBER

Defective Item Cost
BASIS_AVG_DAILY_DEMAND VARCHAR2 (240)
Basis Average Daily Demand
STD_DEVIATION_FOR_DEMAND NUMBER

Standard Deviation for Demand
MEAN_INTER_ARRIVAL NUMBER

Mean Inter Arrival
STD_DEVIATION_INTER_ARRIVAL NUMBER

tandard Deviation Inter Arrival
STANDARD_DEVIATION NUMBER

Standard Deviation
COEFFICIENT_OF_VARIATION NUMBER

Coefficient of Variation
INTERARRIVAL_DIST_METHOD VARCHAR2 (30)
Interarrival Dist Method
UPDATED_COLUMNS_COUNT NUMBER

Updated Column Count
USER_ATTRIBUTE1 VARCHAR2 (30)
User Attribute 1
USER_ATTRIBUTE2 VARCHAR2 (30)
User Attribute 2
USER_ATTRIBUTE3 VARCHAR2 (30)
User Attribute 3
USER_ATTRIBUTE4 VARCHAR2 (30)
User Attribute 4
USER_ATTRIBUTE5 VARCHAR2 (30)
User Attribute 5
USER_ATTRIBUTE6 VARCHAR2 (30)
User Attribute 6
USER_ATTRIBUTE7 VARCHAR2 (30)
User Attribute 7
USER_ATTRIBUTE8 VARCHAR2 (30)
User Attribute 8
USER_ATTRIBUTE9 VARCHAR2 (30)
User Attribute 9
USER_ATTRIBUTE10 VARCHAR2 (30)
User Attribute 10
USER_ATTRIBUTE11 VARCHAR2 (30)
User Attribute 11
USER_ATTRIBUTE12 VARCHAR2 (30)
User Attribute 12
USER_ATTRIBUTE13 VARCHAR2 (30)
User Attribute 13
USER_ATTRIBUTE14 VARCHAR2 (30)
User Attribute 14
USER_ATTRIBUTE15 VARCHAR2 (30)
User Attribute 15
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
Query Text

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


SELECT SIMULATION_SET_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REGION_ID
,      REGION_INSTANCE_ID
,      REGION
,      FORECAST_RULE_FOR_DEMANDS
,      FORECAST_RULE_FOR_RETURNS
,      END_OF_LIFE_DATE
,      LIFE_TIME_BUY_DATE
,      AVG_DEMAND_BEYOND_PH
,      AVG_RETURNS_BEYOND_PH
,      RETURN_FORECAST_TIME_FENCE
,      AVERAGE_DAILY_DEMAND
,      DEFECTIVE_ITEM_COST
,      BASIS_AVG_DAILY_DEMAND
,      STD_DEVIATION_FOR_DEMAND
,      MEAN_INTER_ARRIVAL
,      STD_DEVIATION_INTER_ARRIVAL
,      STANDARD_DEVIATION
,      COEFFICIENT_OF_VARIATION
,      INTERARRIVAL_DIST_METHOD
,      UPDATED_COLUMNS_COUNT
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_REGION_ITEM_ATTRIBUTES;

Dependencies

[top of page]

MSC.MSC_REGION_ITEM_ATTRIBUTES does not reference any database object

MSC.MSC_REGION_ITEM_ATTRIBUTES is referenced by following:

SchemaMSC
ViewMSC_REGION_ITEM_ATTRIBUTES#