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

TABLE: MTH.MTH_PRODUCTION_SCHEDULES_ERR

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


Error table for MTH_PRODUCTION_SCHEDULES_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKORDER_PK VARCHAR2 (240) Yes Work Order identifier
SYSTEM_FK VARCHAR2 (120)
Reference to source system
WORKORDER_TYPE NUMBER
Yes Work Order type
STATUS VARCHAR2 (80) Yes 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
DATE_RELEASED DATE

Date on which Work Order is released
ERP_ACTUAL_START_DATE DATE

Work Order actual start date from ERP
ERP_ACTUAL_COMPLETION_DATE DATE

Work Order actual completion date from ERP
EBS_ENTITY_ID NUMBER

Work Order identifier in the Oracle E-business suite
EBS_ORGANIZATION_ID NUMBER

Organization identifier in Oracle E-business suite
BOM_REVISION VARCHAR2 (3)
Bill of Material revision for the primary assembly
ROUTING_REVISION VARCHAR2 (3)
Routing revision for the primary assembly
BOM_REVISION_DATE DATE

Bill of Material revision date
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a Work Order
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a Work Order
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the Work Order
COMPLETION_LOCATOR_ID NUMBER

Default completion locator identifier for assemblies completed by the Work Order
DEMAND_CLASS VARCHAR2 (30)
Type of demand the Work Order satisfies
SCHEDULE_GROUP_ID NUMBER

Schedule group identifier for the Work Order
BUILD_SEQUENCE NUMBER

Build sequence
WORKORDER_NAME VARCHAR2 (240)
Work Order name or flow schedule number
DEMAND_SOURCE_HEADER_ID NUMBER

Demand source header identifier
DEMAND_SOURCE_LINE VARCHAR2 (30)
Demand source line identifier
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
Delivery identifier for demand source
DEMAND_SOURCE_TYPE NUMBER

Demand source type
KANBAN_CARD_ID NUMBER

Identifier for production kanban replenished by the job
LINE_CODE VARCHAR2 (10)
Production line Identifier
PARENT_WORKORDER_ID VARCHAR2 (30)
Parent Work Order identifier in the source system
PARENT_OPERATION_SEQ_NUM NUMBER

Parent Operation Sequence Number
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in source system
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_ATTR6 VARCHAR2 (150)
User-defined attribute
USER_ATTR7 VARCHAR2 (150)
User-defined attribute
USER_ATTR8 VARCHAR2 (150)
User-defined attribute
USER_ATTR9 VARCHAR2 (150)
User-defined attribute
USER_ATTR10 VARCHAR2 (150)
User-defined attribute
USER_ATTR11 VARCHAR2 (150)
User-defined attribute
USER_ATTR12 VARCHAR2 (150)
User-defined attribute
USER_ATTR13 VARCHAR2 (150)
User-defined attribute
USER_ATTR14 VARCHAR2 (150)
User-defined attribute
USER_ATTR15 VARCHAR2 (150)
User-defined attribute
USER_ATTR16 VARCHAR2 (150)
User-defined attribute
USER_ATTR17 VARCHAR2 (150)
User-defined attribute
USER_ATTR18 VARCHAR2 (150)
User-defined attribute
USER_ATTR19 VARCHAR2 (150)
User-defined attribute
USER_ATTR20 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
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate reprocessing of errored rows
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
RECIPE_NUM VARCHAR2 (32)
Recipe Number
RECIPE_VERSION VARCHAR2 (15)
Recipe Version
FORMULA_NUM VARCHAR2 (32)
Formula Number
FORMULA_VERSION VARCHAR2 (15)
Formula Version
REQ_COMPLETION_DATE DATE

Required Completion Date
BATCH_TYPE VARCHAR2 (240)
Batch Type
ERR_CODE VARCHAR2 (240)
Error Code
TERMINATED_IND NUMBER

Indicates if the batch has been terminated. 1 - Yes 0 - No
Query Text

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


SELECT WORKORDER_PK
,      SYSTEM_FK
,      WORKORDER_TYPE
,      STATUS
,      PLANNED_START_DATE
,      PLANNED_COMPLETION_DATE
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      DATE_RELEASED
,      ERP_ACTUAL_START_DATE
,      ERP_ACTUAL_COMPLETION_DATE
,      EBS_ENTITY_ID
,      EBS_ORGANIZATION_ID
,      BOM_REVISION
,      ROUTING_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      DEMAND_CLASS
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      WORKORDER_NAME
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_TYPE
,      KANBAN_CARD_ID
,      LINE_CODE
,      PARENT_WORKORDER_ID
,      PARENT_OPERATION_SEQ_NUM
,      SOURCE_ORG_CODE
,      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_ATTR6
,      USER_ATTR7
,      USER_ATTR8
,      USER_ATTR9
,      USER_ATTR10
,      USER_ATTR11
,      USER_ATTR12
,      USER_ATTR13
,      USER_ATTR14
,      USER_ATTR15
,      USER_ATTR16
,      USER_ATTR17
,      USER_ATTR18
,      USER_ATTR19
,      USER_ATTR20
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      REPROCESS_READY_YN
,      ERR$$$_AUDIT_RUN_ID
,      ERR$$$_AUDIT_DETAIL_ID
,      ERR$$$_ERROR_ID
,      ERR$$$_ERROR_REASON
,      ERR$$$_SEVERITY
,      ERR$$$_OPERATOR_NAME
,      ERR$$$_ERROR_OBJECT_NAME
,      RECIPE_NUM
,      RECIPE_VERSION
,      FORMULA_NUM
,      FORMULA_VERSION
,      REQ_COMPLETION_DATE
,      BATCH_TYPE
,      ERR_CODE
,      TERMINATED_IND
FROM MTH.MTH_PRODUCTION_SCHEDULES_ERR;

Dependencies

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_ERR does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_ERR is referenced by following:

SchemaMTH
ViewMTH_PRODUCTION_SCHEDULES_ERR#