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

TABLE: CSP.CSP_SUP_DEM_SUB_TEMP

Object Details
Object Name: CSP_SUP_DEM_SUB_TEMP
Object Type: TABLE
Owner: CSP
Subobject Name:
Status: VALID

Temporary Table Details

CSP.CSP_SUP_DEM_SUB_TEMP 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
CSP_SUP_DEM_SUB_TEMP_N1 NORMAL NONUNIQUE Tablespace ColumnINVENTORY_ITEM_ID
ColumnSUBINVENTORY_CODE
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
PARTS_LOOP_ID NUMBER

HIERARCHY_NODE_ID NUMBER

PLANNING_PARAMETERS_ID NUMBER

LEVEL_ID VARCHAR2 (200)
ORGANIZATION_ID NUMBER

SUBINVENTORY_CODE VARCHAR2 (10)
INVENTORY_ITEM_ID NUMBER
Yes
INTERORG_TRANSF_IN NUMBER

INTERORG_TRANSF_OUT NUMBER

INTRANSIT_MOVE_ORDERS NUMBER

MOVE_ORDERS_IN NUMBER

MOVE_ORDERS_OUT NUMBER

ONHAND_GOOD NUMBER

ONHAND_BAD NUMBER

PURCHASE_ORDERS NUMBER

REQUISITIONS NUMBER

SALES_ORDERS NUMBER

WORK_ORDERS NUMBER

EXCESS_QUANTITY NUMBER

Query Text

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


SELECT PARTS_LOOP_ID
,      HIERARCHY_NODE_ID
,      PLANNING_PARAMETERS_ID
,      LEVEL_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      INTERORG_TRANSF_IN
,      INTERORG_TRANSF_OUT
,      INTRANSIT_MOVE_ORDERS
,      MOVE_ORDERS_IN
,      MOVE_ORDERS_OUT
,      ONHAND_GOOD
,      ONHAND_BAD
,      PURCHASE_ORDERS
,      REQUISITIONS
,      SALES_ORDERS
,      WORK_ORDERS
,      EXCESS_QUANTITY
FROM CSP.CSP_SUP_DEM_SUB_TEMP;

Dependencies

[top of page]

CSP.CSP_SUP_DEM_SUB_TEMP does not reference any database object

CSP.CSP_SUP_DEM_SUB_TEMP is referenced by following:

SchemaAPPS
Materialized ViewCSP_SUP_DEM_SUB_MV
SynonymCSP_SUP_DEM_SUB_TEMP