MSC_SUB_INVENTORIES

MSC_SUB_INVENTORIES stores information about the netting type of each subinventory defined in Oracle Inventory. Each subinventory will have an entry in MSC_SUB_INVENTORIES and NETTING_TYPE will indicate whether or not that subinventory should be considered nettable by the planning process. . This table stores data collected from source applications.

Details

Schema: FUSION
Object owner: MSC
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSC_SUB_INVENTORIES_PK	PLAN_ID, ORGANIZATION_ID, SUB_INVENTORY_CODE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PLAN_ID	NUMBER		18	Yes	This value indicates the plan identifier for the record.
ORGANIZATION_ID	NUMBER		18	Yes	Organization identifier in the Planning system.
SUB_INVENTORY_CODE	VARCHAR2	10		Yes	This value indicates the Sub inventory code.
NETTING_TYPE	NUMBER		18		Subinventory netting code. Nettable inventory(1), Nonnettable inventory(2)
SR_INSTANCE_ID	NUMBER		18	Yes	Source application instance identifier	Obsolete
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ATTRIBUTE_CATEGORY	VARCHAR2	30			Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
DISABLE_DATE	DATE				Disable date of the sub inventories.
ATTRIBUTE13	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15	VARCHAR2	150			Descriptive Flexfield: segment of the user descriptive flexfield.
REFRESH_NUMBER	NUMBER				Refresh identifier populated by the collection program.
DESCRIPTION	VARCHAR2	200			Describe the application instance
INVENTORY_ATP_CODE	NUMBER				Inventory available to promise code
INCLUDE_NON_NETTABLE	NUMBER				Indicates whether to include non nettable
LOCATION_ID	NUMBER				Location id generated on destination side.
PAR_ENABLED	NUMBER				Indicates whether Sub Inventory is PAR Enabled or not.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_SUB_INVENTORIES	msc_parameters	ORGANIZATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_SUB_INVENTORIES_U1	Unique	Default	PLAN_ID, ORGANIZATION_ID, SUB_INVENTORY_CODE