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

TABLE: MTH.MTH_PROD_SEGMENTS_TXN_ERR

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


Error table for MTH_PROD_SEGMENTS_TXN_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKORDER_FK VARCHAR2 (240) Yes Reference to source work order
FROM_SEGMENT_FK VARCHAR2 (120) Yes Reference to source "From" segment
TO_SEGMENT_FK VARCHAR2 (120) Yes Reference to source "To" segment
ITEM_FK VARCHAR2 (120) Yes Reference to source item
SYSTEM_FK VARCHAR2 (120)
Reference to source system
TRANSACTION_DATE DATE
Yes Transaction date
TRANSACTION_QTY NUMBER

Move quantity for the transaction in transaction unit of measure
TRANSACTION_QTY_G NUMBER

Move quantity for the transaction in primary unit of measure
TRANSACTION_QTY_SG NUMBER

Move quantity for the transaction in secondary unit of measure
PRIMARY_UOM VARCHAR2 (5)
Primary unit of measure
SECONDARY_UOM VARCHAR2 (5)
Secondary unit of measure
TRANSACTION_UOM VARCHAR2 (5)
Transaction unit of measure
FROM_STEP_TYPE VARCHAR2 (80)
"From" intraoperation step for the transaction
TO_STEP_TYPE VARCHAR2 (80)
"To" intraoperation step for the transaction
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate reprocessing 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
SUB_SEGMENT_FK VARCHAR2 (120)
Reference to sub-segment
ERR_CODE VARCHAR2 (240)
Error code
Query Text

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


SELECT WORKORDER_FK
,      FROM_SEGMENT_FK
,      TO_SEGMENT_FK
,      ITEM_FK
,      SYSTEM_FK
,      TRANSACTION_DATE
,      TRANSACTION_QTY
,      TRANSACTION_QTY_G
,      TRANSACTION_QTY_SG
,      PRIMARY_UOM
,      SECONDARY_UOM
,      TRANSACTION_UOM
,      FROM_STEP_TYPE
,      TO_STEP_TYPE
,      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
,      SUB_SEGMENT_FK
,      ERR_CODE
FROM MTH.MTH_PROD_SEGMENTS_TXN_ERR;

Dependencies

[top of page]

MTH.MTH_PROD_SEGMENTS_TXN_ERR does not reference any database object

MTH.MTH_PROD_SEGMENTS_TXN_ERR is referenced by following:

SchemaAPPS
SynonymMTH_PROD_SEGMENTS_TXN_ERR