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

TABLE: APPS.DDR_R_ORG_BU_DN_MV

Object Details
Object Name: DDR_R_ORG_BU_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableDDR.DDR_R_ORG_BU_DN_MV
TableFND.DDR_R_ORG_BU_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_R_ORG_BU_DN_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_BSNS_UNIT_ID
DDR_R_ORG_BU_DN_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBSNS_UNIT_NAME
DDR_R_ORG_BU_DN_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnDSTRCT_NAME
DDR_R_ORG_BU_DN_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnRGN_NAME
Columns
Name Datatype Length Mandatory Comments
BU_DN_ROWID ROWID (10)
MKT_AREA_ROWID ROWID (10)
MFG_ORG_CD VARCHAR2 (30) Yes
ORG_CD VARCHAR2 (30) Yes
ORG_TYP VARCHAR2 (30)
ORG_NAME VARCHAR2 (240)
ORG_BSNS_UNIT_ID NUMBER
Yes
BSNS_UNIT_CD VARCHAR2 (30) Yes
BSNS_UNIT_NAME VARCHAR2 (240)
BSNS_UNIT_TYP VARCHAR2 (30)
CHNL_TYP_CD VARCHAR2 (30)
CHNL_TYP_DESC VARCHAR2 (240)
STORE_MGR VARCHAR2 (40)
STORE_OPEN_DT DATE

STORE_CLOSE_DT DATE

STORE_TYP VARCHAR2 (30)
NEW_STORE_IND VARCHAR2 (1)
GLBL_LOC_ID VARCHAR2 (30) Yes
GLBL_LOC_ID_TYP VARCHAR2 (30) Yes
BSNS_UNIT_CNCPT VARCHAR2 (240)
MKT_AREA_ID NUMBER

MKT_AREA_CD VARCHAR2 (30)
MKT_AREA_TYP VARCHAR2 (30)
MKT_AREA_NAME VARCHAR2 (40)
MKT_AREA_DESC VARCHAR2 (240)
ORG_DSTRCT_ID NUMBER
Yes
DSTRCT_CD VARCHAR2 (30) Yes
DSTRCT_NAME VARCHAR2 (240)
DSTRCT_MGR_NAME VARCHAR2 (40)
ORG_RGN_ID NUMBER
Yes
RGN_CD VARCHAR2 (30) Yes
RGN_NAME VARCHAR2 (240)
RGN_MGR_NAME VARCHAR2 (40)
ORG_AREA_ID NUMBER
Yes
AREA_CD VARCHAR2 (30) Yes
AREA_NAME VARCHAR2 (240)
AREA_MGR_NAME VARCHAR2 (40)
ORG_CHAIN_ID NUMBER
Yes
CHAIN_CD VARCHAR2 (30) Yes
CHAIN_NAME VARCHAR2 (240)
CHAIN_MGR_NAME VARCHAR2 (40)
GEO_SUB_RGN_ID NUMBER

STORE_VOL VARCHAR2 (40)
NO_OF_RTL_STORES NUMBER

Query Text

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


SELECT BU_DN_ROWID
,      MKT_AREA_ROWID
,      MFG_ORG_CD
,      ORG_CD
,      ORG_TYP
,      ORG_NAME
,      ORG_BSNS_UNIT_ID
,      BSNS_UNIT_CD
,      BSNS_UNIT_NAME
,      BSNS_UNIT_TYP
,      CHNL_TYP_CD
,      CHNL_TYP_DESC
,      STORE_MGR
,      STORE_OPEN_DT
,      STORE_CLOSE_DT
,      STORE_TYP
,      NEW_STORE_IND
,      GLBL_LOC_ID
,      GLBL_LOC_ID_TYP
,      BSNS_UNIT_CNCPT
,      MKT_AREA_ID
,      MKT_AREA_CD
,      MKT_AREA_TYP
,      MKT_AREA_NAME
,      MKT_AREA_DESC
,      ORG_DSTRCT_ID
,      DSTRCT_CD
,      DSTRCT_NAME
,      DSTRCT_MGR_NAME
,      ORG_RGN_ID
,      RGN_CD
,      RGN_NAME
,      RGN_MGR_NAME
,      ORG_AREA_ID
,      AREA_CD
,      AREA_NAME
,      AREA_MGR_NAME
,      ORG_CHAIN_ID
,      CHAIN_CD
,      CHAIN_NAME
,      CHAIN_MGR_NAME
,      GEO_SUB_RGN_ID
,      STORE_VOL
,      NO_OF_RTL_STORES
FROM APPS.DDR_R_ORG_BU_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_ORG_BU_DN_MV does not reference any database object

APPS.DDR_R_ORG_BU_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_C_MV
ViewDDR_BS_EXCPTN_SKU_BU_WK_C_MV#
Materialized ViewDDR_BS_EXCPTN_SKU_BU_WK_MV
ViewDDR_BS_EXCPTN_SKU_BU_WK_MV#
Materialized ViewDDR_BS_FRCST_ITM_BU_WK_C_MV
ViewDDR_BS_FRCST_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_FRCST_ITM_BU_WK_MV
ViewDDR_BS_FRCST_ITM_BU_WK_MV#
Materialized ViewDDR_BS_INV_ITM_BU_WK_C_MV
ViewDDR_BS_INV_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_INV_ITM_BU_WK_MV
ViewDDR_BS_INV_ITM_BU_WK_MV#
Materialized ViewDDR_BS_MFG_SHIP_ITM_BU_WK_MV
ViewDDR_BS_MFG_SHIP_ITM_BU_WK_MV#
Materialized ViewDDR_BS_MFG_SHP_ITM_BU_WK_C_MV
ViewDDR_BS_MFG_SHP_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_ORDR_ITM_BU_WK_C_MV
ViewDDR_BS_ORDR_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_ORDR_ITM_BU_WK_MV
ViewDDR_BS_ORDR_ITM_BU_WK_MV#
Materialized ViewDDR_BS_SHIP_ITM_BU_WK_C_MV
ViewDDR_BS_SHIP_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_SHIP_ITM_BU_WK_MV
ViewDDR_BS_SHIP_ITM_BU_WK_MV#
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_C_MV
ViewDDR_BS_SLSR_ITM_BU_WK_C_MV#
Materialized ViewDDR_BS_SLSR_ITM_BU_WK_MV
ViewDDR_BS_SLSR_ITM_BU_WK_MV#
Materialized ViewDDR_R_ORG_BU_DN_MV
Materialized ViewDDR_SV_FRCST_C_MV
ViewDDR_SV_FRCST_C_MV#
Materialized ViewDDR_SV_INV_INT_C_MV
ViewDDR_SV_INV_INT_C_MV#
Materialized ViewDDR_SV_MFG_SHIP_C_MV
ViewDDR_SV_MFG_SHIP_C_MV#
Materialized ViewDDR_SV_ORDR_C_MV
ViewDDR_SV_ORDR_C_MV#
Materialized ViewDDR_SV_SHIP_C_MV
ViewDDR_SV_SHIP_C_MV#
Materialized ViewDDR_SV_SLSR_C_MV
ViewDDR_SV_SLSR_C_MV#