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


TABLE: APPS.CSP_USAGE_REG_MV

Object Details
Object Name: CSP_USAGE_REG_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLANNING_PARAMETERS_ID NUMBER (35)
INVENTORY_ITEM_ID NUMBER (35) Yes
QUANTITY NUMBER

PERIOD_START_DATE DATE
Yes
LEVEL_ID VARCHAR2 (200)
Query Text

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


SELECT PLANNING_PARAMETERS_ID
,      INVENTORY_ITEM_ID
,      QUANTITY
,      PERIOD_START_DATE
,      LEVEL_ID
FROM APPS.CSP_USAGE_REG_MV;

Dependencies

[top of page]

APPS.CSP_USAGE_REG_MV does not reference any database object

APPS.CSP_USAGE_REG_MV is referenced by following:

SchemaAPPS
ViewCSP_REGION_ITEMS_V
ViewCSP_REG_USAGE_DETAILS_V
Materialized ViewCSP_USAGE_REG_MV
ViewCSP_USAGE_REG_ORG_SUBINV_V