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

TABLE: APPS.CSP_SUP_DEM_PN_MV

Object Details
Object Name: CSP_SUP_DEM_PN_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_SUP_DEM_PN_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPLANNING_PARAMETERS_ID
ColumnINVENTORY_ITEM_ID
CSP_SUP_DEM_PN_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnLEVEL_ID
ColumnINVENTORY_ITEM_ID
CSP_SUP_DEM_PN_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPARENT_NODE_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

PLANNING_PARAMETERS_ID NUMBER (35) Yes
LEVEL_ID VARCHAR2 (200)
NODE_NAME VARCHAR2 (50)
PARENT_NODE_ID NUMBER (35)
PURCHASE_ORDERS NUMBER

SALES_ORDERS NUMBER

REQUISITIONS NUMBER

INTERORG_TRANSF_IN NUMBER

ONHAND_GOOD NUMBER

ONHAND_BAD NUMBER

INTRANSIT_MOVE_ORDERS NUMBER

INTERORG_TRANSF_OUT NUMBER

MOVE_ORDERS_IN NUMBER

MOVE_ORDERS_OUT NUMBER

WORK_ORDERS NUMBER

EXCESS_QUANTITY NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PLANNING_PARAMETERS_ID
,      LEVEL_ID
,      NODE_NAME
,      PARENT_NODE_ID
,      PURCHASE_ORDERS
,      SALES_ORDERS
,      REQUISITIONS
,      INTERORG_TRANSF_IN
,      ONHAND_GOOD
,      ONHAND_BAD
,      INTRANSIT_MOVE_ORDERS
,      INTERORG_TRANSF_OUT
,      MOVE_ORDERS_IN
,      MOVE_ORDERS_OUT
,      WORK_ORDERS
,      EXCESS_QUANTITY
FROM APPS.CSP_SUP_DEM_PN_MV;

Dependencies

[top of page]

APPS.CSP_SUP_DEM_PN_MV does not reference any database object

APPS.CSP_SUP_DEM_PN_MV is referenced by following:

SchemaAPPS
Materialized ViewCSP_SUP_DEM_PN_MV
ViewCSP_SUP_DEM_PN_V