[Home] [Help] [Dependency Information]
Object Name: | DDR_R_ORG_BU_DN_MV# |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE( INITIAL 16384 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
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 |
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#;
APPS.DDR_R_ORG_BU_DN_MV# is not referenced by any database object
|
|
|