[Home] [Help] [Dependency Information]
Object Name: | MTH_PROD_MTL_PRODUCED_F |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | MTH.MTH_PROD_MTL_PRODUCED_F |
Subobject Name: | |
Status: | VALID |
This table stores the work order item information. It holds information about the quantity of each item to be assembled, the actual quantity completed along with the scrap, reject and the reworked quantities, the type of the item and its expected yield
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_PROD_MTL_PRODUCED_F_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_FK_KEY
WORKORDER_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_FK_KEY | NUMBER | Yes | Reference to work order | |
ITEM_FK_KEY | NUMBER | Yes | Reference to item | |
SYSTEM_FK_KEY | NUMBER | Yes | Reference to system | |
START_QUANTITY_G | NUMBER | Work Order start quantity in primary unit of measure | ||
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Yes | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Yes | Standard who column | |
START_QUANTITY_SG | NUMBER | Work Order start quantity in secondary unit of measure | ||
EXPECTED_YIELD | NUMBER | Expected Yield % for the Work Order | ||
PRIMARY_UOM | VARCHAR2 | (5) | Primary unit of measure | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
ACTUAL_COMP_QTY_G | NUMBER | Actual completed quantity in primary unit of measure | ||
ACTUAL_COMP_QTY_SG | NUMBER | Actual completed quantity in secondary unit of measure | ||
ACTUAL_REJECTED_QTY_G | NUMBER | Actual rejected quantity in primary unit of measure | ||
ACTUAL_REJECTED_QTY_SG | NUMBER | Actual rejected quantity in secondary unit of measure | ||
ACTUAL_REWORKED_QTY_G | NUMBER | Actual reworked quantity in primary unit of measure | ||
ACTUAL_REWORKED_QTY_SG | NUMBER | Actual reworked quantity in secondary unit of measure | ||
ACTUAL_SCRAP_QTY_G | NUMBER | Actual scrapped quantity in primary unit of measure | ||
ACTUAL_SCRAP_QTY_SG | NUMBER | Actual scrapped quantity in secondary unit of measure | ||
ITEM_TYPE_CODE | NUMBER | Item type code | ||
USER_DIM1_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM2_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM3_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM4_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_DIM5_FK_KEY | NUMBER | Reference to user defined dimension | ||
USER_ATTR1 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (150) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (150) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
STATUS_CODE | NUMBER | Work Order status code | ||
PLANNED_START_DATE | DATE | Work Order planned start date | ||
PLANNED_COMPLETION_DATE | DATE | Work Order planned completion date | ||
ACTUAL_START_DATE | DATE | Work Order actual start date | ||
ACTUAL_COMPLETION_DATE | DATE | Work Order actual completion date | ||
WIP_PLAN_QTY_G | NUMBER | WIP planned quantity in primary unit of measure | ||
WIP_PLAN_QTY_SG | NUMBER | WIP planned quantity in secondary unit of measure | ||
CONTRIBUTE_YIELD_FLAG | VARCHAR2 | (1) | Flag indicating material produced contributing to yield |
Cut, paste (and edit) the following text to query this object:
SELECT WORKORDER_FK_KEY
, ITEM_FK_KEY
, SYSTEM_FK_KEY
, START_QUANTITY_G
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATION_SYSTEM_ID
, LAST_UPDATE_SYSTEM_ID
, START_QUANTITY_SG
, EXPECTED_YIELD
, PRIMARY_UOM
, SECONDARY_UOM
, 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
, USER_DIM1_FK_KEY
, USER_DIM2_FK_KEY
, USER_DIM3_FK_KEY
, USER_DIM4_FK_KEY
, USER_DIM5_FK_KEY
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, STATUS_CODE
, PLANNED_START_DATE
, PLANNED_COMPLETION_DATE
, ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE
, WIP_PLAN_QTY_G
, WIP_PLAN_QTY_SG
, CONTRIBUTE_YIELD_FLAG
FROM MTH.MTH_PROD_MTL_PRODUCED_F;
MTH.MTH_PROD_MTL_PRODUCED_F does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_F is referenced by following:
|
|
|