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


VIEW: APPS.MTH_EQUIP_OP_SUM_PM_MV#

Object Details
Object Name: MTH_EQUIP_OP_SUM_PM_MV#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
STORAGE(INITIAL 4096 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX PCTFREE 10 INITRANS 11 MAXTRANS 255
STORAGE(INITIAL 4096 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
REFRESH FORCE ON DEMAND
WITH ROWID USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE

[View Source]

Columns
Name Datatype Length Mandatory Comments
DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

STATUS_CODE NUMBER
Yes
PRODUCT_LEVEL9_KEY NUMBER

DEPT_KEY NUMBER

DEPT_EFF_DATE DATE

CUST_LEVEL9_KEY NUMBER

CUST_LEVEL9_EFF_DATE DATE

REJECTED_QTY NUMBER

REJECTED_QTY_COUNT NUMBER

QTY_REWORK NUMBER

QTY_REWORK_COUNT NUMBER

QTY_SCRAP NUMBER

QTY_SCRAP_COUNT NUMBER

QTY_GOOD NUMBER

QTY_GOOD_COUNT NUMBER

OUTPUT_QTY NUMBER

OUTPUT_QTY_COUNT NUMBER

COMPLETED_QTY NUMBER

COMPLETED_QTY_COUNT NUMBER

HRS_ACT_COMP_QTY NUMBER

HRS_ACT_COMP_QTY_COUNT NUMBER

SHIFT_ACT_PROD NUMBER

SHIFT_ACT_PROD_COUNT NUMBER

LOSS_BAD_QUALITY NUMBER

LOSS_BAD_QUALITY_COUNT NUMBER

LOSS_BAD_QUALTY_VAL NUMBER

LOSS_BAD_QUALTY_VAL_COUNT NUMBER

TOTAL_COUNT NUMBER

GROUPING_ID NUMBER

TIME_DIM_KEY NUMBER

TIME_DIM_LEVEL NUMBER

EQUIP_HIER NUMBER

EQUIP_HIER_KEY NUMBER

EQUIP_HIER_EFF_DATE DATE

Query Text

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


SELECT DAY_ID
,      CALENDAR_MONTH_ID
,      STATUS_CODE
,      PRODUCT_LEVEL9_KEY
,      DEPT_KEY
,      DEPT_EFF_DATE
,      CUST_LEVEL9_KEY
,      CUST_LEVEL9_EFF_DATE
,      REJECTED_QTY
,      REJECTED_QTY_COUNT
,      QTY_REWORK
,      QTY_REWORK_COUNT
,      QTY_SCRAP
,      QTY_SCRAP_COUNT
,      QTY_GOOD
,      QTY_GOOD_COUNT
,      OUTPUT_QTY
,      OUTPUT_QTY_COUNT
,      COMPLETED_QTY
,      COMPLETED_QTY_COUNT
,      HRS_ACT_COMP_QTY
,      HRS_ACT_COMP_QTY_COUNT
,      SHIFT_ACT_PROD
,      SHIFT_ACT_PROD_COUNT
,      LOSS_BAD_QUALITY
,      LOSS_BAD_QUALITY_COUNT
,      LOSS_BAD_QUALTY_VAL
,      LOSS_BAD_QUALTY_VAL_COUNT
,      TOTAL_COUNT
,      GROUPING_ID
,      TIME_DIM_KEY
,      TIME_DIM_LEVEL
,      EQUIP_HIER
,      EQUIP_HIER_KEY
,      EQUIP_HIER_EFF_DATE
FROM APPS.MTH_EQUIP_OP_SUM_PM_MV#;

Dependencies

[top of page]

APPS.MTH_EQUIP_OP_SUM_PM_MV# references the following:

SchemaAPPS
TableMTH_EQUIP_OP_SUM_DD_MV

APPS.MTH_EQUIP_OP_SUM_PM_MV# is not referenced by any database object