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

TABLE: MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR

Object Details
Object Name: MTH_PROD_MTL_CONSUMED_TXN_ERR
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_PROD_MTL_CONSUMED_TXN_ERR
Subobject Name:
Status: VALID


Error table for MTH_PROD_MTL_CONSUMED_TXN_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WO_MAT_TXN_PK VARCHAR2 (120) Yes Transaction Identifier for the material consumption
WORKORDER_FK VARCHAR2 (240) Yes Reference to source workorder
PRODUCT_FK VARCHAR2 (120)
Reference to primary source product
MATERIAL_FK VARCHAR2 (120) Yes Reference to input source material
SEGMENT_FK VARCHAR2 (120)
Reference to source operation
TRANSACTION_QTY NUMBER

Quantity of material consumed in transaction unit of measure
TRANSACTION_QTY_G NUMBER

Quantity of material consumed in primary unit of measure
TRANSACTION_QTY_SG NUMBER

Quantity of material consumed in secondary unit of measure
TRANSACTION_UOM VARCHAR2 (5)
Transaction unit of measure
PRIMARY_UOM VARCHAR2 (5)
Primary unit of measure
SECONDARY_UOM VARCHAR2 (5)
Secondary unit of measure
TRANSACTION_DATE DATE
Yes Transaction date for the material consumption
SYSTEM_FK VARCHAR2 (120)
Reference to source system
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in source system
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate re-processing of errored rows
USER_DIM1_FK VARCHAR2 (120)
Reference to source user defined dimension
USER_DIM2_FK VARCHAR2 (120)
Reference to source user defined dimension
USER_DIM3_FK VARCHAR2 (120)
Reference to source user defined dimension
USER_DIM4_FK VARCHAR2 (120)
Reference to source user defined dimension
USER_DIM5_FK VARCHAR2 (120)
Reference to source 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
ERR$$$_AUDIT_RUN_ID NUMBER (22)
Internal column
ERR$$$_AUDIT_DETAIL_ID NUMBER (22)
Internal column
ERR$$$_ERROR_ID NUMBER (22)
Internal column
ERR$$$_ERROR_REASON VARCHAR2 (2000)
Internal column
ERR$$$_SEVERITY VARCHAR2 (1)
Internal column
ERR$$$_OPERATOR_NAME VARCHAR2 (30)
Internal column
ERR$$$_ERROR_OBJECT_NAME VARCHAR2 (30)
Internal column
ERR_CODE VARCHAR2 (240)
Error Code
Query Text

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


SELECT WO_MAT_TXN_PK
,      WORKORDER_FK
,      PRODUCT_FK
,      MATERIAL_FK
,      SEGMENT_FK
,      TRANSACTION_QTY
,      TRANSACTION_QTY_G
,      TRANSACTION_QTY_SG
,      TRANSACTION_UOM
,      PRIMARY_UOM
,      SECONDARY_UOM
,      TRANSACTION_DATE
,      SYSTEM_FK
,      SOURCE_ORG_CODE
,      REPROCESS_READY_YN
,      USER_DIM1_FK
,      USER_DIM2_FK
,      USER_DIM3_FK
,      USER_DIM4_FK
,      USER_DIM5_FK
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      ERR$$$_AUDIT_RUN_ID
,      ERR$$$_AUDIT_DETAIL_ID
,      ERR$$$_ERROR_ID
,      ERR$$$_ERROR_REASON
,      ERR$$$_SEVERITY
,      ERR$$$_OPERATOR_NAME
,      ERR$$$_ERROR_OBJECT_NAME
,      ERR_CODE
FROM MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR;

Dependencies

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR is referenced by following:

SchemaMTH
ViewMTH_PROD_MTL_CONSUMED_TXN_ERR#