Skip to content

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

MATERIALIZED VIEW: APPS.DDR_BS_CLS_DAY_MV

Object Details
Object Name: DDR_BS_CLS_DAY_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: DDR_BS_CLS_DAY_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_BASE_DAY_DN_MV
     DDR_R_BASE_DAY
     DDR_R_BASE_DAY
     DDR_R_BSNS_MNTH
     DDR_R_BSNS_MNTH
     DDR_R_BSNS_QTR
     DDR_R_BSNS_QTR
     DDR_R_BSNS_WK
     DDR_R_BSNS_WK
     DDR_R_BSNS_YR
     DDR_R_BSNS_YR
     DDR_R_CLNDR
     DDR_R_CLNDR
     DDR_R_DAY
     DDR_R_DAY
     DDR_R_DAY_TRANS
     DDR_R_DAY_TRANS
DDR_R_MFG_ITEM_SKU_DN_MV
     DDR_R_LKUP_MST
     DDR_R_LKUP_MST
     DDR_R_MFG_ITEM
     DDR_R_MFG_ITEM
     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_MFG_ITEM_SBC
     DDR_R_MFG_ITEM_SBC
     DDR_R_MFG_SKU_ITEM
     DDR_R_MFG_SKU_ITEM
     DDR_R_ORG
     DDR_R_ORG

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
CLNDR_CD VARCHAR2 (30) Yes
MFG_ITEM_CLASS_ID NUMBER
Yes
DAY_CD VARCHAR2 (30) Yes
NUM_MFG_SKU_ITEMS NUMBER

Query Text

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


SELECT MFG_ORG_CD
,      CLNDR_CD
,      MFG_ITEM_CLASS_ID
,      DAY_CD
,      NUM_MFG_SKU_ITEMS
FROM APPS.DDR_BS_CLS_DAY_MV;

Dependencies

[top of page]

APPS.DDR_BS_CLS_DAY_MV references the following:

SchemaAPPS
TableDDR_BS_CLS_DAY_MV
TableDDR_R_BASE_DAY_DN_MV
Materialized ViewDDR_R_BASE_DAY_DN_MV
Materialized ViewDDR_R_MFG_ITEM_SKU_DN_MV
TableDDR_R_MFG_ITEM_SKU_DN_MV
APPS.DDR_BS_CLS_DAY_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_SV_CLS_WK_MV