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]

VIEW: APPS.MTH_SRC_PRODUCTION_SCHEDULES_V

Object Details

Object Name:	MTH_SRC_PRODUCTION_SCHEDULES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
WORKORDER_PK	VARCHAR2	(150)	Work Order identifier
SYSTEM_FK	VARCHAR2	(4000)	Reference to source system
WORKORDER_TYPE	NUMBER		Work Order type
STATUS	VARCHAR2	(80)	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	(150)	Bill of Material revision for the primary assembly
ROUTING_REVISION	VARCHAR2	(150)	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	(150)	Alternate bill of material used in a Work Order
ALTERNATE_ROUTING_DESIGNATOR	VARCHAR2	(150)	Alternate routing used in a Work Order
COMPLETION_SUBINVENTORY	VARCHAR2	(150)	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	(150)	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	(150)	Demand source line identifier
DEMAND_SOURCE_DELIVERY	VARCHAR2	(150)	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	(150)	Production line Identifier
PARENT_WORKORDER_ID	VARCHAR2	(150)	Parent Work Order identifier in the source system
PARENT_OPERATION_SEQ_NUM	NUMBER		Parent Operation Sequence Number
SOURCE_ORG_CODE	VARCHAR2	(3)	Organization code in source system
USER_DIM1_FK	VARCHAR2	(150)	Reference to source user defined dimension
USER_DIM2_FK	VARCHAR2	(150)	Reference to source user defined dimension
USER_DIM3_FK	VARCHAR2	(150)	Reference to source user defined dimension
USER_DIM4_FK	VARCHAR2	(150)	Reference to source user defined dimension
USER_DIM5_FK	VARCHAR2	(150)	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
RECIPE_NUM	VARCHAR2	(150)	Recipe Number
RECIPE_VERSION	VARCHAR2	(150)	Recipe Version
FORMULA_NUM	VARCHAR2	(150)	Formula Number
FORMULA_VERSION	VARCHAR2	(150)	Formula Version
BATCH_TYPE	VARCHAR2	(150)	Batch Type
REQ_COMPLETION_DATE	DATE		Required Completion Date
TERMINATED_IND	NUMBER		Indicates if the batch has been terminated. 1 - Yes 0 - No
LAST_UPDATE_DATE	DATE		Last Update Date

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
,      RECIPE_NUM
,      RECIPE_VERSION
,      FORMULA_NUM
,      FORMULA_VERSION
,      BATCH_TYPE
,      REQ_COMPLETION_DATE
,      TERMINATED_IND
,      LAST_UPDATE_DATE
FROM APPS.MTH_SRC_PRODUCTION_SCHEDULES_V;

Dependencies

[top of page]

APPS.MTH_SRC_PRODUCTION_SCHEDULES_V references the following:

APPS: FM_FORM_MST_VL; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_PROFILE - show dependent code; GMD_RECIPES_VL; GMD_RECIPE_VALIDITY_RULES; GME_BATCH_HEADER; MTL_PARAMETERS; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_FLOW_SCHEDULES; WIP_LINES

APPS.MTH_SRC_PRODUCTION_SCHEDULES_V is not referenced by any database object