[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_INT_COMPONENT_ITEM

Object Details

Object Name:	MSC_INT_COMPONENT_ITEM
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_INT_COMPONENT_ITEM
Subobject Name:
Status:	VALID

Temporary Table Details

MSC.MSC_INT_COMPONENT_ITEM is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: MSC_COMPONENT_ITEM_PK

1. OI__ITEM_ID
2. OI__BILL_SEQUENCE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_COMPONENT_ITEM_PK	NORMAL	UNIQUE		OI__ITEM_ID OI__BILL_SEQUENCE_ID

Columns

Query Text

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

SELECT OI__ITEM_ID
,      OI__BILL_SEQUENCE_ID
FROM MSC.MSC_INT_COMPONENT_ITEM;

Dependencies

[top of page]

MSC.MSC_INT_COMPONENT_ITEM does not reference any database object

MSC.MSC_INT_COMPONENT_ITEM is referenced by following:

APPS

MSC_INT_COMPONENT_ITEM