eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	MSC.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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SUPPLIER_PLANS_N1	NORMAL	NONUNIQUE		QUERY_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	(300)		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:

APPS: MSC_SUPPLIER_PLANS