[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:	FND.DDR_R_ORG_DSTRCT_DN_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_R_ORG_DSTRCT_DN_MV_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORG_DSTRCT_ID
DDR_R_ORG_DSTRCT_DN_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	DSTRCT_NAME
DDR_R_ORG_DSTRCT_DN_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RGN_NAME

Columns

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
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:

APPS

DDR_R_ORG_DSTRCT_DN_MV