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

MATERIALIZED VIEW: APPS.DDR_SV_SLSR_MV

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

DDR_BS_SLSR_ITM_BU_WK_MV
     DDR_B_RTL_SL_RTN_ITM_DAY
     DDR_R_BASE_DAY_DN_MV
          DDR_R_BASE_DAY
          DDR_R_BSNS_MNTH
          DDR_R_BSNS_QTR
          DDR_R_BSNS_WK
          DDR_R_BSNS_YR
          DDR_R_CLNDR
          DDR_R_DAY
          DDR_R_DAY_TRANS
     DDR_R_MFG_ITEM_SKU_DN_MV
          DDR_R_LKUP_MST
          DDR_R_MFG_ITEM
          DDR_R_MFG_ITEM_CLASS
          DDR_R_MFG_ITEM_DIV
          DDR_R_MFG_ITEM_GRP
          DDR_R_MFG_ITEM_SBC
          DDR_R_MFG_SKU_ITEM
          DDR_R_ORG
     DDR_R_ORG_BU_DN_MV
          DDR_R_MKT_AREA
          DDR_R_ORG_BU_CHNLTYP_DN_MV
               DDR_R_LKUP_MST
               DDR_R_ORG
               DDR_R_ORG_AREA
               DDR_R_ORG_BSNS_UNIT
               DDR_R_ORG_CHAIN
               DDR_R_ORG_DSTRCT
               DDR_R_ORG_RGN
     DDR_R_RTL_ITEM_SKU_DN_MV
          DDR_R_LKUP_MST
          DDR_R_ORG
          DDR_R_RTL_ITEM
          DDR_R_RTL_ITEM_CLASS
          DDR_R_RTL_ITEM_DEPT
          DDR_R_RTL_ITEM_DIV
          DDR_R_RTL_ITEM_GRP
          DDR_R_RTL_ITEM_SBC
          DDR_R_RTL_SKU_ITEM

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
BSNS_WK_ID NUMBER

BSNS_MNTH_ID NUMBER

ORG_RGN_ID NUMBER

ORG_CHAIN_ID NUMBER

MKT_AREA_ID NUMBER

CHNL_TYP_CD VARCHAR2 (30)
ITM_TYP VARCHAR2 (1)
MFG_ITEM_CLASS_ID NUMBER

RTL_ITEM_CLASS_ID NUMBER

SLS_TYP_CD VARCHAR2 (30)
BSNS_CLNDR_DIM_ID NUMBER

BSNS_CLNDR_DIM_LVL VARCHAR2 (4)
ORG_DIM_ID NUMBER

ORG_DIM_LVL VARCHAR2 (3)
MFG_ITEM_DIM_ID NUMBER

MFG_ITEM_DIM_LVL VARCHAR2 (3)
RTL_ITEM_DIM_ID NUMBER

RTL_ITEM_DIM_LVL VARCHAR2 (3)
CNT_TOTAL NUMBER

ACT_BU_ITM_DAYS_SCANNED NUMBER

CNT_ACT_BU_ITM_DAYS_SCANNED NUMBER

SLS_QTY_PRMRY NUMBER

SLS_QTY_ALT NUMBER

SLS_AMT NUMBER

SLS_AMT_RPT NUMBER

SLS_COST_AMT NUMBER

SLS_COST_AMT_RPT NUMBER

RTRN_QTY_PRMRY NUMBER

RTRN_QTY_ALT NUMBER

RTRN_AMT NUMBER

RTRN_AMT_RPT NUMBER

RTRN_COST_AMT NUMBER

RTRN_COST_AMT_RPT NUMBER

CNT_SLS_QTY_PRMRY NUMBER

CNT_SLS_QTY_ALT NUMBER

CNT_SLS_AMT NUMBER

CNT_SLS_AMT_RPT NUMBER

CNT_SLS_COST_AMT NUMBER

CNT_SLS_COST_AMT_RPT NUMBER

CNT_RTRN_QTY_PRMRY NUMBER

CNT_RTRN_QTY_ALT NUMBER

CNT_RTRN_AMT NUMBER

CNT_RTRN_AMT_RPT NUMBER

CNT_RTRN_COST_AMT NUMBER

CNT_RTRN_COST_AMT_RPT NUMBER

GROUPING_ID NUMBER

Query Text

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


SELECT BSNS_WK_ID
,      BSNS_MNTH_ID
,      ORG_RGN_ID
,      ORG_CHAIN_ID
,      MKT_AREA_ID
,      CHNL_TYP_CD
,      ITM_TYP
,      MFG_ITEM_CLASS_ID
,      RTL_ITEM_CLASS_ID
,      SLS_TYP_CD
,      BSNS_CLNDR_DIM_ID
,      BSNS_CLNDR_DIM_LVL
,      ORG_DIM_ID
,      ORG_DIM_LVL
,      MFG_ITEM_DIM_ID
,      MFG_ITEM_DIM_LVL
,      RTL_ITEM_DIM_ID
,      RTL_ITEM_DIM_LVL
,      CNT_TOTAL
,      ACT_BU_ITM_DAYS_SCANNED
,      CNT_ACT_BU_ITM_DAYS_SCANNED
,      SLS_QTY_PRMRY
,      SLS_QTY_ALT
,      SLS_AMT
,      SLS_AMT_RPT
,      SLS_COST_AMT
,      SLS_COST_AMT_RPT
,      RTRN_QTY_PRMRY
,      RTRN_QTY_ALT
,      RTRN_AMT
,      RTRN_AMT_RPT
,      RTRN_COST_AMT
,      RTRN_COST_AMT_RPT
,      CNT_SLS_QTY_PRMRY
,      CNT_SLS_QTY_ALT
,      CNT_SLS_AMT
,      CNT_SLS_AMT_RPT
,      CNT_SLS_COST_AMT
,      CNT_SLS_COST_AMT_RPT
,      CNT_RTRN_QTY_PRMRY
,      CNT_RTRN_QTY_ALT
,      CNT_RTRN_AMT
,      CNT_RTRN_AMT_RPT
,      CNT_RTRN_COST_AMT
,      CNT_RTRN_COST_AMT_RPT
,      GROUPING_ID
FROM APPS.DDR_SV_SLSR_MV;

Dependencies

[top of page]

APPS.DDR_SV_SLSR_MV references the following:

SchemaAPPS
TableDDR_BS_SLSR_ITM_BU_WK_MV
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_MV
TableDDR_SV_SLSR_MV

APPS.DDR_SV_SLSR_MV is not referenced by any database object