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

VIEW: APPS.DDR_R_ORG_DSTRCT_DN_MV#

Object Details
Object Name: DDR_R_ORG_DSTRCT_DN_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

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# references the following:

SchemaAPPS
SynonymDDR_R_ORG
SynonymDDR_R_ORG_AREA
SynonymDDR_R_ORG_CHAIN
SynonymDDR_R_ORG_DSTRCT
SynonymDDR_R_ORG_RGN

APPS.DDR_R_ORG_DSTRCT_DN_MV# is not referenced by any database object