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

TABLE: APPS.DDR_R_ORG_DSTRCT_DN_MV

Object Details
Object Name: DDR_R_ORG_DSTRCT_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableDDR.DDR_R_ORG_DSTRCT_DN_MV
TableFND.DDR_R_ORG_DSTRCT_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DSTRCT_ROWID ROWID (10)
RGN_ROWID ROWID (10)
AREA_ROWID ROWID (10)
CHAIN_ROWID ROWID (10)
ORG_ROWID ROWID (10)
MFG_ORG_CD VARCHAR2 (30) Yes
ORG_CD VARCHAR2 (30) Yes
ORG_TYP VARCHAR2 (30)
ORG_NAME 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)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
Query Text

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


SELECT DSTRCT_ROWID
,      RGN_ROWID
,      AREA_ROWID
,      CHAIN_ROWID
,      ORG_ROWID
,      MFG_ORG_CD
,      ORG_CD
,      ORG_TYP
,      ORG_NAME
,      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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
FROM APPS.DDR_R_ORG_DSTRCT_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_ORG_DSTRCT_DN_MV does not reference any database object

APPS.DDR_R_ORG_DSTRCT_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_ORG_DSTRCT_DN_MV