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

MATERIALIZED VIEW: APPS.DDR_R_MFG_ITEM_CLS_DN_MV

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

DDR_R_MFG_ITEM_CLASS
DDR_R_MFG_ITEM_CLASS
DDR_R_MFG_ITEM_DIV
DDR_R_MFG_ITEM_DIV
DDR_R_MFG_ITEM_GRP
DDR_R_MFG_ITEM_GRP
DDR_R_ORG
DDR_R_ORG

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CLS_ROWID ROWID (10)
GRP_ROWID ROWID (10)
DIV_ROWID ROWID (10)
ORG_ROWID ROWID (10)
MFG_ORG_CD VARCHAR2 (30) Yes
MFG_ORG_NAME VARCHAR2 (40)
MFG_ITEM_CLASS_ID NUMBER
Yes
MFG_CLASS_CD VARCHAR2 (30) Yes
MFG_CLASS_NAME VARCHAR2 (40)
MFG_ITEM_GRP_ID NUMBER
Yes
MFG_GRP_CD VARCHAR2 (30) Yes
MFG_GRP_NAME VARCHAR2 (40)
MFG_ITEM_DIV_ID NUMBER
Yes
MFG_DIV_CD VARCHAR2 (30) Yes
MFG_DIV_NAME VARCHAR2 (40)
MFG_ITEM_CMPNY_ID NUMBER

Query Text

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


SELECT CLS_ROWID
,      GRP_ROWID
,      DIV_ROWID
,      ORG_ROWID
,      MFG_ORG_CD
,      MFG_ORG_NAME
,      MFG_ITEM_CLASS_ID
,      MFG_CLASS_CD
,      MFG_CLASS_NAME
,      MFG_ITEM_GRP_ID
,      MFG_GRP_CD
,      MFG_GRP_NAME
,      MFG_ITEM_DIV_ID
,      MFG_DIV_CD
,      MFG_DIV_NAME
,      MFG_ITEM_CMPNY_ID
FROM APPS.DDR_R_MFG_ITEM_CLS_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_MFG_ITEM_CLS_DN_MV references the following:

SchemaAPPS
SynonymDDR_R_MFG_ITEM_CLASS
TableDDR_R_MFG_ITEM_CLS_DN_MV
SynonymDDR_R_MFG_ITEM_DIV
SynonymDDR_R_MFG_ITEM_GRP
SynonymDDR_R_ORG
SchemaDDR
TableDDR_R_MFG_ITEM_CLASS
TableDDR_R_MFG_ITEM_DIV
TableDDR_R_MFG_ITEM_GRP
TableDDR_R_ORG

APPS.DDR_R_MFG_ITEM_CLS_DN_MV is not referenced by any database object