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

TABLE: MSC.MSC_SUPPLIER_PLANS

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


MSC_SUPPLIER_PLANS is a generic table used by forms for querying data.
This table is used to display supplier plan information in the Planner
Workbench. QUERY_ID is the query identifier used while populating
the table. The QUANTITY columns contain generic data used in the PL/SQL
procedure to select data.


Temporary Table Details

MSC.MSC_SUPPLIER_PLANS 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$TRANSACTION. 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_SUPPLIER_PLANS_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
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
ORGANIZATION_ID NUMBER

Organization identifier
SR_INSTANCE_ID NUMBER

Source application instance identifier
SUPPLIER_ID NUMBER
Yes Supplier identifer
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SUPPLIER_NAME VARCHAR2 (100)
Supplier name
ITEM_NAME VARCHAR2 (250)
Item name
BUCKET_TYPE NUMBER
Yes Bucket type
BUCKET_DATE DATE
Yes Bucket date
QUANTITY1 NUMBER

Generic quantiy column
QUANTITY2 NUMBER

Generic quantiy column
QUANTITY3 NUMBER

Generic quantiy column
QUANTITY4 NUMBER

Generic quantiy column
QUANTITY5 NUMBER

Generic quantiy column
QUANTITY6 NUMBER

Generic quantiy column
QUANTITY7 NUMBER

Generic quantiy column
QUANTITY8 NUMBER

Generic quantiy column
QUANTITY9 NUMBER

Generic quantiy column
QUANTITY10 NUMBER

Generic quantiy column
QUANTITY11 NUMBER

Generic quantiy column
QUANTITY12 NUMBER

Generic quantiy column
QUANTITY13 NUMBER

Generic quantiy column
QUANTITY14 NUMBER

Generic quantiy column
QUANTITY15 NUMBER

Generic quantiy column
QUANTITY16 NUMBER

Generic quantiy column
QUANTITY17 NUMBER

Generic quantiy column
QUANTITY18 NUMBER

Generic quantiy column
QUANTITY19 NUMBER

Generic quantiy column
QUANTITY20 NUMBER

Generic quantiy column
QUANTITY21 NUMBER

Generic quantiy column
QUANTITY22 NUMBER

Generic quantiy column
QUANTITY23 NUMBER

Generic quantiy column
QUANTITY24 NUMBER

Generic quantiy column
QUANTITY25 NUMBER

Generic quantiy column
QUANTITY26 NUMBER

Generic quantiy column
QUANTITY27 NUMBER

Generic quantiy column
QUANTITY28 NUMBER

Generic quantiy column
QUANTITY29 NUMBER

Generic quantiy column
QUANTITY30 NUMBER

Generic quantiy column
QUANTITY31 NUMBER

Generic quantiy column
QUANTITY32 NUMBER

Generic quantiy column
QUANTITY33 NUMBER

Generic quantiy column
QUANTITY34 NUMBER

Generic quantiy column
QUANTITY35 NUMBER

Generic quantiy column
QUANTITY36 NUMBER

Generic quantiy column
SUPPLIER_SITE_ID NUMBER

Supplier Site Id
Query Text

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


SELECT QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      SUPPLIER_ID
,      INVENTORY_ITEM_ID
,      SUPPLIER_NAME
,      ITEM_NAME
,      BUCKET_TYPE
,      BUCKET_DATE
,      QUANTITY1
,      QUANTITY2
,      QUANTITY3
,      QUANTITY4
,      QUANTITY5
,      QUANTITY6
,      QUANTITY7
,      QUANTITY8
,      QUANTITY9
,      QUANTITY10
,      QUANTITY11
,      QUANTITY12
,      QUANTITY13
,      QUANTITY14
,      QUANTITY15
,      QUANTITY16
,      QUANTITY17
,      QUANTITY18
,      QUANTITY19
,      QUANTITY20
,      QUANTITY21
,      QUANTITY22
,      QUANTITY23
,      QUANTITY24
,      QUANTITY25
,      QUANTITY26
,      QUANTITY27
,      QUANTITY28
,      QUANTITY29
,      QUANTITY30
,      QUANTITY31
,      QUANTITY32
,      QUANTITY33
,      QUANTITY34
,      QUANTITY35
,      QUANTITY36
,      SUPPLIER_SITE_ID
FROM MSC.MSC_SUPPLIER_PLANS;

Dependencies

[top of page]

MSC.MSC_SUPPLIER_PLANS does not reference any database object

MSC.MSC_SUPPLIER_PLANS is referenced by following:

SchemaAPPS
SynonymMSC_SUPPLIER_PLANS