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

TABLE: MSC.MSC_INT_ASCP_KPI

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

Temporary Table Details

MSC.MSC_INT_ASCP_KPI 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
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

ORGANIZATIONID NUMBER

INSTANCEID NUMBER

ITEMID NUMBER

DEPARTMENTID NUMBER

SCENARIONAME VARCHAR2 (100)
PERIODTYPE VARCHAR2 (32)
PERIODEND VARCHAR2 (32)
TRANSPORTATIONMODE VARCHAR2 (100)
TOTALCOST NUMBER

TRANSPORTATIONCOST NUMBER

PRODUCTIONCOST NUMBER

SUPPLYCOST NUMBER

INVENTORYCOST NUMBER

DEMANDCOST NUMBER

OTHERCOST NUMBER

ZONEID NUMBER

DEMANDFILLRATE NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

Query Text

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


SELECT PLAN_ID
,      ORGANIZATIONID
,      INSTANCEID
,      ITEMID
,      DEPARTMENTID
,      SCENARIONAME
,      PERIODTYPE
,      PERIODEND
,      TRANSPORTATIONMODE
,      TOTALCOST
,      TRANSPORTATIONCOST
,      PRODUCTIONCOST
,      SUPPLYCOST
,      INVENTORYCOST
,      DEMANDCOST
,      OTHERCOST
,      ZONEID
,      DEMANDFILLRATE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
FROM MSC.MSC_INT_ASCP_KPI;

Dependencies

[top of page]

MSC.MSC_INT_ASCP_KPI does not reference any database object

MSC.MSC_INT_ASCP_KPI is referenced by following:

SchemaAPPS
SynonymMSC_INT_ASCP_KPI