[Home] [Help] [Dependency Information]

TABLE: APPS.DDR_BS_FRCST_VRSN_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_DDR_BS_FRCST_VRSN_	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_TX_DATA	SYS_OP_MAP_NONNULL("MFG_ORG_CD") SYS_OP_MAP_NONNULL("RTL_ORG_CD") SYS_OP_MAP_NONNULL("ORG_BSNS_UNIT_ID") SYS_OP_MAP_NONNULL("MFG_SKU_ITEM_ID") SYS_OP_MAP_NONNULL("RTL_SKU_ITEM_ID") SYS_OP_MAP_NONNULL("DAY_CD") SYS_OP_MAP_NONNULL("FRCST_PURP") SYS_OP_MAP_NONNULL("FRCST_TYP")
DDR_BS_FRCST_VRSN_MV_B1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORG_BSNS_UNIT_ID
DDR_BS_FRCST_VRSN_MV_B2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MFG_SKU_ITEM_ID
DDR_BS_FRCST_VRSN_MV_B3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	RTL_SKU_ITEM_ID
DDR_BS_FRCST_VRSN_MV_B4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	DAY_CD
DDR_BS_FRCST_VRSN_MV_B5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MAX_FRCST_VRSN

Columns

Query Text

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

SELECT MFG_ORG_CD
,      RTL_ORG_CD
,      ORG_BSNS_UNIT_ID
,      MFG_SKU_ITEM_ID
,      RTL_SKU_ITEM_ID
,      DAY_CD
,      FRCST_PURP
,      FRCST_TYP
,      MAX_FRCST_VRSN
,      CNT_TOTAL
FROM APPS.DDR_BS_FRCST_VRSN_MV;

Dependencies

[top of page]

APPS.DDR_BS_FRCST_VRSN_MV does not reference any database object

APPS.DDR_BS_FRCST_VRSN_MV is referenced by following:

APPS

DDR_BS_FRCST_ITM_BU_WK_C_MV

DDR_BS_FRCST_ITM_BU_WK_C_MV#

DDR_BS_FRCST_ITM_BU_WK_MV

DDR_BS_FRCST_ITM_BU_WK_MV#

DDR_BS_FRCST_LST_SLS_MV

DDR_BS_FRCST_LST_SLS_MV#

DDR_BS_FRCST_VRSN_MV

DDR_SV_FRCST_C_MV

DDR_SV_FRCST_C_MV#