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

TABLE: MSC.MSC_SOURCING_TRANSACTIONS

Object Details
Object Name: MSC_SOURCING_TRANSACTIONS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_SOURCING_TRANSACTIONS
Subobject Name:
Status: VALID

Temporary Table Details

MSC.MSC_SOURCING_TRANSACTIONS 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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
MSC_SOURCING_TRANSACTIONS_N1 NORMAL NONUNIQUE Tablespace ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_TYPE
ColumnTRANSACTION_DATE
ColumnTRANSACTION_QTY
MSC_SOURCING_TRANSACTIONS_N2 NORMAL NONUNIQUE Tablespace ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnSOURCE_ORG_ID
ColumnTRANSACTION_TYPE
ColumnTRANSACTION_DATE
ColumnTRANSACTION_QTY
MSC_SOURCING_TRANSACTIONS_N3 NORMAL NONUNIQUE Tablespace ColumnINVENTORY_ITEM_ID
ColumnSUPPLIER_ID
ColumnSUPPLIER_SITE_ID
ColumnTRANSACTION_TYPE
ColumnTRANSACTION_DATE
ColumnTRANSACTION_QTY
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

SOURCE_ORG_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

TRANSACTION_DATE DATE
Yes
TRANSACTION_QTY NUMBER

TRANSACTION_TYPE NUMBER
Yes
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      TRANSACTION_DATE
,      TRANSACTION_QTY
,      TRANSACTION_TYPE
FROM MSC.MSC_SOURCING_TRANSACTIONS;

Dependencies

[top of page]

MSC.MSC_SOURCING_TRANSACTIONS does not reference any database object

MSC.MSC_SOURCING_TRANSACTIONS is referenced by following:

SchemaAPPS
SynonymMSC_SOURCING_TRANSACTIONS