Skip to content

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

VIEW: MTH.MTH_PROD_MTL_PRODUCED_I_STG#

Object Details
Object Name: MTH_PROD_MTL_PRODUCED_I_STG#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes
ORGANIZATION_CODE VARCHAR2 (120)
ORGANIZATION_ID NUMBER

DB_GLOBAL_NAME VARCHAR2 (120) Yes
PRIMARY_ITEM_ID NUMBER
Yes
START_QUANTITY_G NUMBER
Yes
START_QUANTITY_SG NUMBER

EXPECTED_YIELD NUMBER

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

ITEM_TYPE_CODE VARCHAR2 (80)
HUB_ORGANIZATION_CODE VARCHAR2 (120)
WIP_PLAN_QTY_SG NUMBER

WIP_PLAN_QTY_G NUMBER

CONTRIBUTE_YIELD_FLAG VARCHAR2 (1)
Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_ID
,      DB_GLOBAL_NAME
,      PRIMARY_ITEM_ID
,      START_QUANTITY_G
,      START_QUANTITY_SG
,      EXPECTED_YIELD
,      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
,      ITEM_TYPE_CODE
,      HUB_ORGANIZATION_CODE
,      WIP_PLAN_QTY_SG
,      WIP_PLAN_QTY_G
,      CONTRIBUTE_YIELD_FLAG
FROM MTH.MTH_PROD_MTL_PRODUCED_I_STG#;

Dependencies

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_I_STG# references the following:

SchemaMTH
TableMTH_PROD_MTL_PRODUCED_I_STG
MTH.MTH_PROD_MTL_PRODUCED_I_STG# is referenced by following:

SchemaAPPS
SynonymMTH_PROD_MTL_PRODUCED_I_STG