[Home] [Help] [Dependency Information]

TABLE: APPS.MTH_EQUIP_SHFT_DD_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_MTH_EQUIP_SHFT_DD_	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("DEPT_KEY") SYS_OP_MAP_NONNULL("DEPT_EFF_DATE") SYS_OP_MAP_NONNULL("DAY_ID") SYS_OP_MAP_NONNULL("CALENDAR_MONTH_ID") SYS_OP_MAP_NONNULL("CUST_LEVEL9_KEY") SYS_OP_MAP_NONNULL("CUST_LEVEL9_EFF_DATE")
MTH_EQUIP_SHFT_DD_MV_B1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	DAY_ID

Columns

Query Text

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

SELECT DAY_ID
,      CALENDAR_MONTH_ID
,      DEPT_KEY
,      DEPT_EFF_DATE
,      CUST_LEVEL9_KEY
,      CUST_LEVEL9_EFF_DATE
,      EQUIP_CAL_TIME
,      EQUIP_CAL_TIME_COUNT
,      EQUIP_CAL_TIME_VAL
,      EQUIP_CAL_TIME_VAL_COUNT
,      EQUIP_SCH_TIME
,      EQUIP_SCH_TIME_COUNT
,      EQUIP_SCH_TIME_VAL
,      EQUIP_SCH_TIME_VAL_COUNT
,      TOTAL_COUNT
FROM APPS.MTH_EQUIP_SHFT_DD_MV;

Dependencies

[top of page]

APPS.MTH_EQUIP_SHFT_DD_MV does not reference any database object

APPS.MTH_EQUIP_SHFT_DD_MV is referenced by following:

APPS

MTH_EQUIP_SHFT_DD_MV

MTH_EQUIP_SHFT_PM_MV