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

MATERIALIZED VIEW: APPS.CSP_SUP_DEM_RH_MV

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

CSP_REP_HIERARCHIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

HIERARCHY_NODE_ID NUMBER

NODE_NAME VARCHAR2 (30) Yes
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

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      HIERARCHY_NODE_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
FROM APPS.CSP_SUP_DEM_RH_MV;

Dependencies

[top of page]

APPS.CSP_SUP_DEM_RH_MV references the following:

SchemaAPPS
SynonymCSP_REP_HIERARCHIES
TableCSP_SUP_DEM_RH_MV
SynonymCSP_SUP_DEM_RH_TEMP
SchemaCSP
TableCSP_REP_HIERARCHIES
TableCSP_SUP_DEM_RH_TEMP

APPS.CSP_SUP_DEM_RH_MV is not referenced by any database object