DBA Data[Home] [Help] [Dependency Information]

TABLE: APPS.MLOG$_MTH_EQUIP_ST_SUM_DD_

Object Details
Object Name: MLOG$_MTH_EQUIP_ST_SUM_DD_
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.MTH_EQUIP_ST_SUM_DD_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CALENDAR_MONTH_ID NUMBER

CUST_LEVEL9_EFF_DATE DATE

CUST_LEVEL9_KEY NUMBER

DAY_ID NUMBER

DEPT_EFF_DATE DATE

DEPT_KEY NUMBER

DOWN_HOURS NUMBER

DOWN_HOURS_COUNT NUMBER

DOWN_HOURS_VAL NUMBER

DOWN_HOURS_VAL_COUNT NUMBER

IDLE_HOURS NUMBER

IDLE_HOURS_COUNT NUMBER

LOSS_INEFF NUMBER

LOSS_INEFF_COUNT NUMBER

MAC_EFF_COUNT NUMBER

MAC_EFF_SUM NUMBER

RUN_HOURS NUMBER

RUN_HOURS_COUNT NUMBER

RUN_HOURS_VAL NUMBER

RUN_HOURS_VAL_COUNT NUMBER

TOTAL_COUNT NUMBER

UP_HOURS NUMBER

UP_HOURS_COUNT NUMBER

WO_ITEM_COUNT NUMBER

WO_ITEM_SUM NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT CALENDAR_MONTH_ID
,      CUST_LEVEL9_EFF_DATE
,      CUST_LEVEL9_KEY
,      DAY_ID
,      DEPT_EFF_DATE
,      DEPT_KEY
,      DOWN_HOURS
,      DOWN_HOURS_COUNT
,      DOWN_HOURS_VAL
,      DOWN_HOURS_VAL_COUNT
,      IDLE_HOURS
,      IDLE_HOURS_COUNT
,      LOSS_INEFF
,      LOSS_INEFF_COUNT
,      MAC_EFF_COUNT
,      MAC_EFF_SUM
,      RUN_HOURS
,      RUN_HOURS_COUNT
,      RUN_HOURS_VAL
,      RUN_HOURS_VAL_COUNT
,      TOTAL_COUNT
,      UP_HOURS
,      UP_HOURS_COUNT
,      WO_ITEM_COUNT
,      WO_ITEM_SUM
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_MTH_EQUIP_ST_SUM_DD_;

Dependencies

[top of page]

APPS.MLOG$_MTH_EQUIP_ST_SUM_DD_ does not reference any database object

APPS.MLOG$_MTH_EQUIP_ST_SUM_DD_ is not referenced by any database object