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

MATERIALIZED VIEW: APPS.CSP_USAGE_ORG_MV

Object Details
Object Name: CSP_USAGE_ORG_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: CSP_USAGE_ORG_MV
Updatable: N
Rewrite Enabled: Y
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

CSP_PLANNING_PARAMETERS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (35) Yes
INVENTORY_ITEM_ID NUMBER (35) Yes
PERIOD_START_DATE DATE
Yes
QUANTITY NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PERIOD_START_DATE
,      QUANTITY
FROM APPS.CSP_USAGE_ORG_MV;

Dependencies

[top of page]

APPS.CSP_USAGE_ORG_MV references the following:

SchemaAPPS
SynonymCSP_PLANNING_PARAMETERS
SynonymCSP_USAGE_HISTORIES
TableCSP_USAGE_ORG_MV
SynonymCSP_USG_TRANSACTION_TYPES
SchemaCSP
TableCSP_PLANNING_PARAMETERS
TableCSP_USAGE_HISTORIES
TableCSP_USG_TRANSACTION_TYPES

APPS.CSP_USAGE_ORG_MV is not referenced by any database object