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

TABLE: MTH.MLOG$_MTH_PROD_MTL_PRODUCE

Object Details
Object Name: MLOG$_MTH_PROD_MTL_PRODUCE
Object Type: TABLE
Owner: MTH
Subobject Name:
Status: VALID

snapshot log for master table MTH.MTH_PROD_MTL_PRODUCED_F

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTUAL_COMPLETION_DATE DATE

ACTUAL_COMP_QTY_G NUMBER

ACTUAL_COMP_QTY_SG NUMBER

ACTUAL_REJECTED_QTY_G NUMBER

ACTUAL_REJECTED_QTY_SG NUMBER

ACTUAL_REWORKED_QTY_G NUMBER

ACTUAL_REWORKED_QTY_SG NUMBER

ACTUAL_SCRAP_QTY_G NUMBER

ACTUAL_SCRAP_QTY_SG NUMBER

ACTUAL_START_DATE DATE

EXPECTED_YIELD NUMBER

ITEM_FK_KEY NUMBER

PLANNED_COMPLETION_DATE DATE

PLANNED_START_DATE DATE

START_QUANTITY_G NUMBER

START_QUANTITY_SG NUMBER

STATUS_CODE 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 ACTUAL_COMPLETION_DATE
,      ACTUAL_COMP_QTY_G
,      ACTUAL_COMP_QTY_SG
,      ACTUAL_REJECTED_QTY_G
,      ACTUAL_REJECTED_QTY_SG
,      ACTUAL_REWORKED_QTY_G
,      ACTUAL_REWORKED_QTY_SG
,      ACTUAL_SCRAP_QTY_G
,      ACTUAL_SCRAP_QTY_SG
,      ACTUAL_START_DATE
,      EXPECTED_YIELD
,      ITEM_FK_KEY
,      PLANNED_COMPLETION_DATE
,      PLANNED_START_DATE
,      START_QUANTITY_G
,      START_QUANTITY_SG
,      STATUS_CODE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM MTH.MLOG$_MTH_PROD_MTL_PRODUCE;

Dependencies

[top of page]

MTH.MLOG$_MTH_PROD_MTL_PRODUCE does not reference any database object

MTH.MLOG$_MTH_PROD_MTL_PRODUCE is referenced by following:

SchemaAPPS
SynonymMLOG$_MTH_PROD_MTL_PRODUCE