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


MATERIALIZED VIEW: APPS.DDR_BS_INV_ITM_BU_WK_MV

Object Details
Object Name: DDR_BS_INV_ITM_BU_WK_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: DDR_BS_INV_ITM_BU_WK_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_BS_INV_SKU_BU_DAY_MV
     DDR_B_RTL_INV_ITEM_DAY
     DDR_B_RTL_INV_ITEM_DAY
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_INV_RULE_DN_MV
     DDR_R_ITEM_BSNS_UNT_ASSC
     DDR_R_ITEM_BSNS_UNT_ASSC
     DDR_R_RTL_SKU_BU_INV_RL
     DDR_R_RTL_SKU_BU_INV_RL
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
DDR_R_ORG_BU_DN_MV
     DDR_R_MKT_AREA
     DDR_R_MKT_AREA
     DDR_R_ORG_BU_CHNLTYP_DN_MV
          DDR_R_LKUP_MST
          DDR_R_LKUP_MST
          DDR_R_ORG
          DDR_R_ORG
          DDR_R_ORG_AREA
          DDR_R_ORG_AREA
          DDR_R_ORG_BSNS_UNIT
          DDR_R_ORG_BSNS_UNIT
          DDR_R_ORG_CHAIN
          DDR_R_ORG_CHAIN
          DDR_R_ORG_DSTRCT
          DDR_R_ORG_DSTRCT
          DDR_R_ORG_RGN
          DDR_R_ORG_RGN
DDR_R_RTL_ITEM_SKU_DN_MV
     DDR_R_LKUP_MST
     DDR_R_LKUP_MST
     DDR_R_ORG
     DDR_R_ORG
     DDR_R_RTL_ITEM
     DDR_R_RTL_ITEM
     DDR_R_RTL_ITEM_CLASS
     DDR_R_RTL_ITEM_CLASS
     DDR_R_RTL_ITEM_DEPT
     DDR_R_RTL_ITEM_DEPT
     DDR_R_RTL_ITEM_DIV
     DDR_R_RTL_ITEM_DIV
     DDR_R_RTL_ITEM_GRP
     DDR_R_RTL_ITEM_GRP
     DDR_R_RTL_ITEM_SBC
     DDR_R_RTL_ITEM_SBC
     DDR_R_RTL_SKU_ITEM
     DDR_R_RTL_SKU_ITEM

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
RTL_ORG_CD VARCHAR2 (30) Yes
ORG_BSNS_UNIT_ID NUMBER
Yes
ITM_TYP VARCHAR2 (1)
ORG_RGN_ID NUMBER
Yes
ORG_CHAIN_ID NUMBER
Yes
MFG_ITEM_ID NUMBER
Yes
MFG_ITEM_CLASS_ID NUMBER
Yes
RTL_ITEM_ID NUMBER
Yes
RTL_ITEM_CLASS_ID NUMBER
Yes
BSNS_WK_ID NUMBER
Yes
BSNS_MNTH_ID NUMBER
Yes
BSNS_YR_ID NUMBER
Yes
CNT_TOTAL NUMBER

IN_STCK_BU_ITM_DAYS NUMBER

UNDR_STCK_BU_ITM_DAYS NUMBER

ON_HAND_QTY_PRMRY NUMBER

ON_HAND_QTY_ALT NUMBER

RECVD_QTY_PRMRY NUMBER

RECVD_QTY_ALT NUMBER

IN_TRANSIT_QTY_PRMRY NUMBER

IN_TRANSIT_QTY_ALT NUMBER

BCK_ORDR_QTY_PRMRY NUMBER

BCK_ORDR_QTY_ALT NUMBER

QLTY_HOLD_QTY_PRMRY NUMBER

QLTY_HOLD_QTY_ALT NUMBER

ON_HAND_NET_COST_AMT NUMBER

ON_HAND_NET_COST_AMT_RPT NUMBER

RECVD_NET_COST_AMT NUMBER

RECVD_NET_COST_AMT_RPT NUMBER

IN_TRANSIT_NET_COST_AMT NUMBER

IN_TRANSIT_NET_COST_AMT_RPT NUMBER

BCKORDR_NET_COST_AMT NUMBER

BCKORDR_NET_COST_AMT_RPT NUMBER

QLTY_HOLD_NET_COST_AMT NUMBER

QLTY_HOLD_NET_COST_AMT_RPT NUMBER

ON_HAND_RTL_AMT NUMBER

ON_HAND_RTL_AMT_RPT NUMBER

RECVD_RTL_AMT NUMBER

RECVD_RTL_AMT_RPT NUMBER

IN_TRANSIT_RTL_AMT NUMBER

IN_TRANSIT_RTL_AMT_RPT NUMBER

BCKORDR_RTL_AMT NUMBER

BCKORDR_RTL_AMT_RPT NUMBER

QLTY_HOLD_RTL_AMT NUMBER

QLTY_HOLD_RTL_AMT_RPT NUMBER

CNT_ON_HAND_QTY_PRMRY NUMBER

CNT_ON_HAND_QTY_ALT NUMBER

CNT_RECVD_QTY_PRMRY NUMBER

CNT_RECVD_QTY_ALT NUMBER

CNT_IN_TRANSIT_QTY_PRMRY NUMBER

CNT_IN_TRANSIT_QTY_ALT NUMBER

CNT_BCK_ORDR_QTY_PRMRY NUMBER

CNT_BCK_ORDR_QTY_ALT NUMBER

CNT_QLTY_HOLD_QTY_PRMRY NUMBER

CNT_QLTY_HOLD_QTY_ALT NUMBER

CNT_ON_HAND_NET_COST_AMT NUMBER

CNT_ON_HAND_NET_COST_AMT_RPT NUMBER

CNT_RECVD_NET_COST_AMT NUMBER

CNT_RECVD_NET_COST_AMT_RPT NUMBER

CNT_IN_TRANSIT_NET_COST_AMT NUMBER

CNT_IN_TRANSIT_NET_CST_AMT_RPT NUMBER

CNT_BCKORDR_NET_COST_AMT NUMBER

CNT_BCKORDR_NET_COST_AMT_RPT NUMBER

CNT_QLTY_HOLD_NET_COST_AMT NUMBER

CNT_QLTY_HOLD_NET_COST_AMT_RPT NUMBER

CNT_ON_HAND_RTL_AMT NUMBER

CNT_ON_HAND_RTL_AMT_RPT NUMBER

CNT_RECVD_RTL_AMT NUMBER

CNT_RECVD_RTL_AMT_RPT NUMBER

CNT_IN_TRANSIT_RTL_AMT NUMBER

CNT_IN_TRANSIT_RTL_AMT_RPT NUMBER

CNT_BCKORDR_RTL_AMT NUMBER

CNT_BCKORDR_RTL_AMT_RPT NUMBER

CNT_QLTY_HOLD_RTL_AMT NUMBER

CNT_QLTY_HOLD_RTL_AMT_RPT NUMBER

Query Text

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


SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      ITM_TYP
,      ORG_RGN_ID
,      ORG_CHAIN_ID
,      MFG_ITEM_ID
,      MFG_ITEM_CLASS_ID
,      RTL_ITEM_ID
,      RTL_ITEM_CLASS_ID
,      BSNS_WK_ID
,      BSNS_MNTH_ID
,      BSNS_YR_ID
,      CNT_TOTAL
,      IN_STCK_BU_ITM_DAYS
,      UNDR_STCK_BU_ITM_DAYS
,      ON_HAND_QTY_PRMRY
,      ON_HAND_QTY_ALT
,      RECVD_QTY_PRMRY
,      RECVD_QTY_ALT
,      IN_TRANSIT_QTY_PRMRY
,      IN_TRANSIT_QTY_ALT
,      BCK_ORDR_QTY_PRMRY
,      BCK_ORDR_QTY_ALT
,      QLTY_HOLD_QTY_PRMRY
,      QLTY_HOLD_QTY_ALT
,      ON_HAND_NET_COST_AMT
,      ON_HAND_NET_COST_AMT_RPT
,      RECVD_NET_COST_AMT
,      RECVD_NET_COST_AMT_RPT
,      IN_TRANSIT_NET_COST_AMT
,      IN_TRANSIT_NET_COST_AMT_RPT
,      BCKORDR_NET_COST_AMT
,      BCKORDR_NET_COST_AMT_RPT
,      QLTY_HOLD_NET_COST_AMT
,      QLTY_HOLD_NET_COST_AMT_RPT
,      ON_HAND_RTL_AMT
,      ON_HAND_RTL_AMT_RPT
,      RECVD_RTL_AMT
,      RECVD_RTL_AMT_RPT
,      IN_TRANSIT_RTL_AMT
,      IN_TRANSIT_RTL_AMT_RPT
,      BCKORDR_RTL_AMT
,      BCKORDR_RTL_AMT_RPT
,      QLTY_HOLD_RTL_AMT
,      QLTY_HOLD_RTL_AMT_RPT
,      CNT_ON_HAND_QTY_PRMRY
,      CNT_ON_HAND_QTY_ALT
,      CNT_RECVD_QTY_PRMRY
,      CNT_RECVD_QTY_ALT
,      CNT_IN_TRANSIT_QTY_PRMRY
,      CNT_IN_TRANSIT_QTY_ALT
,      CNT_BCK_ORDR_QTY_PRMRY
,      CNT_BCK_ORDR_QTY_ALT
,      CNT_QLTY_HOLD_QTY_PRMRY
,      CNT_QLTY_HOLD_QTY_ALT
,      CNT_ON_HAND_NET_COST_AMT
,      CNT_ON_HAND_NET_COST_AMT_RPT
,      CNT_RECVD_NET_COST_AMT
,      CNT_RECVD_NET_COST_AMT_RPT
,      CNT_IN_TRANSIT_NET_COST_AMT
,      CNT_IN_TRANSIT_NET_CST_AMT_RPT
,      CNT_BCKORDR_NET_COST_AMT
,      CNT_BCKORDR_NET_COST_AMT_RPT
,      CNT_QLTY_HOLD_NET_COST_AMT
,      CNT_QLTY_HOLD_NET_COST_AMT_RPT
,      CNT_ON_HAND_RTL_AMT
,      CNT_ON_HAND_RTL_AMT_RPT
,      CNT_RECVD_RTL_AMT
,      CNT_RECVD_RTL_AMT_RPT
,      CNT_IN_TRANSIT_RTL_AMT
,      CNT_IN_TRANSIT_RTL_AMT_RPT
,      CNT_BCKORDR_RTL_AMT
,      CNT_BCKORDR_RTL_AMT_RPT
,      CNT_QLTY_HOLD_RTL_AMT
,      CNT_QLTY_HOLD_RTL_AMT_RPT
FROM APPS.DDR_BS_INV_ITM_BU_WK_MV;

Dependencies

[top of page]

APPS.DDR_BS_INV_ITM_BU_WK_MV references the following:

SchemaAPPS
TableDDR_BS_INV_ITM_BU_WK_MV
Materialized ViewDDR_BS_INV_SKU_BU_DAY_MV
TableDDR_BS_INV_SKU_BU_DAY_MV
TableDDR_R_BASE_DAY_DN_MV
Materialized ViewDDR_R_BASE_DAY_DN_MV
Materialized ViewDDR_R_INV_RULE_DN_MV
TableDDR_R_INV_RULE_DN_MV
TableDDR_R_MFG_ITEM_SKU_DN_MV
Materialized ViewDDR_R_MFG_ITEM_SKU_DN_MV
TableDDR_R_ORG_BU_DN_MV
Materialized ViewDDR_R_ORG_BU_DN_MV
Materialized ViewDDR_R_RTL_ITEM_SKU_DN_MV
TableDDR_R_RTL_ITEM_SKU_DN_MV
APPS.DDR_BS_INV_ITM_BU_WK_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_SV_INV_MV