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

TABLE: MSC.MSC_CAPACITY_PLANS

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


MSC_CAPACITY_PLANS is a generic table used by forms for querying data.
This table is used to display capacity horizontal 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_CAPACITY_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_CAPACITY_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
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
DEPARTMENT_ID NUMBER
Yes Department identifier
RESOURCE_ID NUMBER

Resource identifier
DEPARTMENT_NAME VARCHAR2 (30)
Department name
DEPARTMENT_CLASS VARCHAR2 (10)
Department class
RESOURCE_NAME VARCHAR2 (30)
Resource name
RESOURCE_TYPE VARCHAR2 (80)
Resource type
RESOURCE_GROUP_NAME VARCHAR2 (30)
Resource group name
BUCKET_TYPE NUMBER
Yes Indicate the type of bucket
BUCKET_DATE DATE
Yes Bucket date
QUANTITY1 NUMBER

Generic quantity column
QUANTITY2 NUMBER

Generic quantity column
QUANTITY3 NUMBER

Generic quantity column
QUANTITY4 NUMBER

Generic quantity column
QUANTITY5 NUMBER

Generic quantity column
QUANTITY6 NUMBER

Generic quantity column
QUANTITY7 NUMBER

Generic quantity column
QUANTITY8 NUMBER

Generic quantity column
QUANTITY9 NUMBER

Generic quantity column
QUANTITY10 NUMBER

Generic quantity column
QUANTITY11 NUMBER

Generic quantity column
QUANTITY12 NUMBER

Generic quantity column
QUANTITY13 NUMBER

Generic quantity column
QUANTITY14 NUMBER

Generic quantity column
QUANTITY15 NUMBER

Generic quantity column
QUANTITY16 NUMBER

Generic quantity column
QUANTITY17 NUMBER

Generic quantity column
QUANTITY18 NUMBER

Generic quantity column
QUANTITY19 NUMBER

Generic quantity column
QUANTITY20 NUMBER

Generic quantity column
QUANTITY21 NUMBER

Generic quantity column
QUANTITY22 NUMBER

Generic quantity column
QUANTITY23 NUMBER

Generic quantity column
QUANTITY24 NUMBER

Generic quantity column
QUANTITY25 NUMBER

Generic quantity column
QUANTITY26 NUMBER

Generic quantity column
QUANTITY27 NUMBER

Generic quantity column
QUANTITY28 NUMBER

Generic quantity column
QUANTITY29 NUMBER

Generic quantity column
QUANTITY30 NUMBER

Generic quantity column
QUANTITY31 NUMBER

Generic quantity column
QUANTITY32 NUMBER

Generic quantity column
QUANTITY33 NUMBER

Generic quantity column
QUANTITY34 NUMBER

Generic quantity column
QUANTITY35 NUMBER

Generic quantity column
QUANTITY36 NUMBER

Generic quantity column
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
,      DEPARTMENT_ID
,      RESOURCE_ID
,      DEPARTMENT_NAME
,      DEPARTMENT_CLASS
,      RESOURCE_NAME
,      RESOURCE_TYPE
,      RESOURCE_GROUP_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
FROM MSC.MSC_CAPACITY_PLANS;

Dependencies

[top of page]

MSC.MSC_CAPACITY_PLANS does not reference any database object

MSC.MSC_CAPACITY_PLANS is referenced by following:

SchemaAPPS
SynonymMSC_CAPACITY_PLANS