eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MTH.MTH_PRODUCTION_SCHEDULES_F

Object Details

Object Name:	MTH_PRODUCTION_SCHEDULES_F
Object Type:	TABLE
Owner:	MTH
FND Design Data:	MTH.MTH_PRODUCTION_SCHEDULES_F
Subobject Name:
Status:	VALID

This table stores the work order information for all types of work orders. It holds information on work order type, status, the scheduled and the actual start and end dates, the BOM and Routing information used on the work order, the demand source information and other data pertaining to the work orders.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_PRODUCTION_SCHEDULES_F_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORKORDER_PK
MTH_PRODUCTION_SCHEDULES_F_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORKORDER_PK_KEY
MTH_PRODUCTION_SCHEDULES_F_B1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
MTH_PRODUCTION_SCHEDULES_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKORDER_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
WORKORDER_PK_KEY	NUMBER		Yes	System generated surrogate key for Work Order identifier
WORKORDER_PK	VARCHAR2	(240)	Yes	Work Order identifier
WORKORDER_NAME	VARCHAR2	(240)		Work Order name or flow schedule number
PLANT_FK_KEY	NUMBER		Yes	Reference to plant
WORKORDER_TYPE	NUMBER		Yes	Work Order type
STATUS_CODE	NUMBER		Yes	Work Order status code
SYSTEM_FK_KEY	NUMBER		Yes	Reference to system
SOURCE_ORG_CODE	VARCHAR2	(120)		Organization code in source system
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
LINE_CODE	VARCHAR2	(10)		Production line Identifier
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
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
PARENT_OPERATION_SEQ_NUM	NUMBER			Parent Operation Sequence Number
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_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
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
CREATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
PARENT_WORKORDER_ID	VARCHAR2	(30)		Parent Work Order identifier in the source system
RECIPE_NUM	VARCHAR2	(30)		Recipe Number
RECIPE_VERSION	VARCHAR2	(15)		Recipe Version
FORMULA_NUM	VARCHAR2	(30)		Formula Number
FORMULA_VERSION	VARCHAR2	(15)		Formula Version
REQ_COMPLETION_DATE	DATE			Required Completion Date
BATCH_TYPE	VARCHAR2	(240)		Batch Type

Query Text

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


SELECT WORKORDER_PK_KEY
,      WORKORDER_PK
,      WORKORDER_NAME
,      PLANT_FK_KEY
,      WORKORDER_TYPE
,      STATUS_CODE
,      SYSTEM_FK_KEY
,      SOURCE_ORG_CODE
,      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
,      LINE_CODE
,      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
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_TYPE
,      KANBAN_CARD_ID
,      PARENT_OPERATION_SEQ_NUM
,      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_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
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      PARENT_WORKORDER_ID
,      RECIPE_NUM
,      RECIPE_VERSION
,      FORMULA_NUM
,      FORMULA_VERSION
,      REQ_COMPLETION_DATE
,      BATCH_TYPE
FROM MTH.MTH_PRODUCTION_SCHEDULES_F;

Dependencies

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_F does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_F is referenced by following:

APPS: MTH_EQUIP_OP_SUM_DD_MV; MTH_PRODUCTION_SCHEDULES_F