[Home] [Help] [Dependency Information]

TABLE: APPS.DDR_R_RTL_ITEM_SBC_DN_MV

Object Details

Object Name:	DDR_R_RTL_ITEM_SBC_DN_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.DDR_R_RTL_ITEM_SBC_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_RTL_ITEM_SBC_DN_MV_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	RTL_ITEM_SBC_ID
DDR_R_RTL_ITEM_SBC_DN_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RTL_SBC_NAME
DDR_R_RTL_ITEM_SBC_DN_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RTL_CLASS_NAME
DDR_R_RTL_ITEM_SBC_DN_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	RTL_DEPT_NAME

Columns

Query Text

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

SELECT SBC_ROWID
,      CLS_ROWID
,      DPT_ROWID
,      GRP_ROWID
,      DIV_ROWID
,      ORG_ROWID
,      MFG_ORG_CD
,      ORG_NAME
,      ORG_CD
,      RTL_ITEM_SBC_ID
,      RTL_SBC_CD
,      RTL_SBC_NAME
,      RTL_ITEM_CLASS_ID
,      RTL_CLASS_CD
,      RTL_CLASS_NAME
,      RTL_ITEM_DEPT_ID
,      RTL_DEPT_CD
,      RTL_DEPT_NAME
,      RTL_ITEM_GRP_ID
,      RTL_GRP_CD
,      RTL_GRP_NAME
,      RTL_ITEM_DIV_ID
,      RTL_DIV_CD
,      RTL_DIV_NAME
,      RTL_ITEM_CMPNY_ID
FROM APPS.DDR_R_RTL_ITEM_SBC_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_RTL_ITEM_SBC_DN_MV does not reference any database object

APPS.DDR_R_RTL_ITEM_SBC_DN_MV is referenced by following:

APPS

DDR_R_RTL_ITEM_SBC_DN_MV