Skip to content

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

MATERIALIZED VIEW: APPS.MTH_MTL_PROD_LT_MV

Object Details
Object Name: MTH_MTL_PROD_LT_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MTH_MTL_PROD_LT_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: PREBUILT
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

MTH_MTL_PROD_IT_MV
     MTH_GREGORIAN_CALENDAR
     MTH_ITEM_DENORM_D
     MTH_PROD_MTL_PRODUCED_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ITEM_FK_KEY NUMBER

LEVEL9_FK_KEY NUMBER

STATUS_CODE NUMBER

DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

START_QUANTITY_G NUMBER

START_QUANTITY_G_COUNT NUMBER

EXPECTED_YIELD NUMBER

EXPECTED_YIELD_COUNT NUMBER

START_QUANTITY_SG NUMBER

START_QUANTITY_SG_COUNT NUMBER

ACTUAL_COMP_QTY_G NUMBER

ACTUAL_COMP_QTY_G_COUNT NUMBER

ACTUAL_COMP_QTY_SG NUMBER

ACTUAL_COMP_QTY_SG_COUNT NUMBER

ACTUAL_REJECTED_QTY_G NUMBER

ACTUAL_REJECTED_QTY_G_COUNT NUMBER

ACTUAL_REJECTED_QTY_SG NUMBER

ACTUAL_REJECTED_QTY_SG_COUNT NUMBER

ACTUAL_REWORKED_QTY_G NUMBER

ACTUAL_REWORKED_QTY_G_COUNT NUMBER

ACTUAL_REWORKED_QTY_SG NUMBER

ACTUAL_REWORKED_QTY_SG_COUNT NUMBER

ACTUAL_SCRAP_QTY_G NUMBER

ACTUAL_SCRAP_QTY_G_COUNT NUMBER

ACTUAL_SCRAP_QTY_SG NUMBER

ACTUAL_SCRAP_QTY_SG_COUNT NUMBER

BATCH_CYCLE_TIME_SUM NUMBER

BATCH_CTS_COUNT NUMBER

BATCH_CYCLE_TIME_COUNT NUMBER

BATCH_CTC_COUNT NUMBER

FIRST_TIME_QTY NUMBER

FTS_COUNT NUMBER

FIRST_TIME_QTY_COUNT NUMBER

FTC_COUNT NUMBER

TOTAL_COUNT NUMBER

GROUPING_ID NUMBER

TIME_DIM_KEY NUMBER

TIME_DIM_LEVEL NUMBER

ITEM_DIM_KEY NUMBER

ITEM_DIM_LEVEL NUMBER

Query Text

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


SELECT ITEM_FK_KEY
,      LEVEL9_FK_KEY
,      STATUS_CODE
,      DAY_ID
,      CALENDAR_MONTH_ID
,      START_QUANTITY_G
,      START_QUANTITY_G_COUNT
,      EXPECTED_YIELD
,      EXPECTED_YIELD_COUNT
,      START_QUANTITY_SG
,      START_QUANTITY_SG_COUNT
,      ACTUAL_COMP_QTY_G
,      ACTUAL_COMP_QTY_G_COUNT
,      ACTUAL_COMP_QTY_SG
,      ACTUAL_COMP_QTY_SG_COUNT
,      ACTUAL_REJECTED_QTY_G
,      ACTUAL_REJECTED_QTY_G_COUNT
,      ACTUAL_REJECTED_QTY_SG
,      ACTUAL_REJECTED_QTY_SG_COUNT
,      ACTUAL_REWORKED_QTY_G
,      ACTUAL_REWORKED_QTY_G_COUNT
,      ACTUAL_REWORKED_QTY_SG
,      ACTUAL_REWORKED_QTY_SG_COUNT
,      ACTUAL_SCRAP_QTY_G
,      ACTUAL_SCRAP_QTY_G_COUNT
,      ACTUAL_SCRAP_QTY_SG
,      ACTUAL_SCRAP_QTY_SG_COUNT
,      BATCH_CYCLE_TIME_SUM
,      BATCH_CTS_COUNT
,      BATCH_CYCLE_TIME_COUNT
,      BATCH_CTC_COUNT
,      FIRST_TIME_QTY
,      FTS_COUNT
,      FIRST_TIME_QTY_COUNT
,      FTC_COUNT
,      TOTAL_COUNT
,      GROUPING_ID
,      TIME_DIM_KEY
,      TIME_DIM_LEVEL
,      ITEM_DIM_KEY
,      ITEM_DIM_LEVEL
FROM APPS.MTH_MTL_PROD_LT_MV;

Dependencies

[top of page]

APPS.MTH_MTL_PROD_LT_MV references the following:

SchemaAPPS
TableMTH_MTL_PROD_IT_MV
Materialized ViewMTH_MTL_PROD_IT_MV
TableMTH_MTL_PROD_LT_MV

APPS.MTH_MTL_PROD_LT_MV is not referenced by any database object