[Home] [Help] [Dependency Information]

TABLE: APPS.DDR_BS_CLS_DAY_MV

Object Details

Object Name:	DDR_BS_CLS_DAY_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.DDR_BS_CLS_DAY_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_BS_CLS_DAY_MV_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	MFG_ITEM_CLASS_ID DAY_CD
I_SNAP$_DDR_BS_CLS_DAY_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("MFG_ORG_CD") SYS_OP_MAP_NONNULL("CLNDR_CD") SYS_OP_MAP_NONNULL("MFG_ITEM_CLASS_ID") SYS_OP_MAP_NONNULL("DAY_CD")

Columns

Query Text

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

SELECT MFG_ORG_CD
,      CLNDR_CD
,      MFG_ITEM_CLASS_ID
,      DAY_CD
,      NUM_MFG_SKU_ITEMS
FROM APPS.DDR_BS_CLS_DAY_MV;

Dependencies

[top of page]

APPS.DDR_BS_CLS_DAY_MV does not reference any database object

APPS.DDR_BS_CLS_DAY_MV is referenced by following:

APPS

DDR_BS_CLS_DAY_MV

DDR_SV_CLS_WK_MV

DDR_SV_CLS_WK_MV#