Skip to content

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

VIEW: MTH.MTH_PRODUCTION_SCHEDULES_F#

Object Details
Object Name: MTH_PRODUCTION_SCHEDULES_F#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WORKORDER_PK_KEY NUMBER
Yes
WORKORDER_PK VARCHAR2 (240) Yes
WORKORDER_NAME VARCHAR2 (240)
PLANT_FK_KEY NUMBER
Yes
WORKORDER_TYPE NUMBER
Yes
STATUS_CODE NUMBER
Yes
SYSTEM_FK_KEY NUMBER
Yes
SOURCE_ORG_CODE VARCHAR2 (120)
PLANNED_START_DATE DATE

PLANNED_COMPLETION_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_COMPLETION_DATE DATE

DATE_RELEASED DATE

ERP_ACTUAL_START_DATE DATE

ERP_ACTUAL_COMPLETION_DATE DATE

EBS_ENTITY_ID NUMBER

EBS_ORGANIZATION_ID NUMBER

LINE_CODE VARCHAR2 (10)
BOM_REVISION VARCHAR2 (3)
ROUTING_REVISION VARCHAR2 (3)
BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
COMPLETION_SUBINVENTORY VARCHAR2 (10)
COMPLETION_LOCATOR_ID NUMBER

DEMAND_CLASS VARCHAR2 (30)
SCHEDULE_GROUP_ID NUMBER

BUILD_SEQUENCE NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE VARCHAR2 (30)
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
DEMAND_SOURCE_TYPE NUMBER

KANBAN_CARD_ID NUMBER

PARENT_OPERATION_SEQ_NUM NUMBER

USER_DIM1_FK_KEY NUMBER

USER_DIM2_FK_KEY NUMBER

USER_DIM3_FK_KEY NUMBER

USER_DIM4_FK_KEY NUMBER

USER_DIM5_FK_KEY NUMBER

USER_ATTR1 VARCHAR2 (150)
USER_ATTR2 VARCHAR2 (150)
USER_ATTR3 VARCHAR2 (150)
USER_ATTR4 VARCHAR2 (150)
USER_ATTR5 VARCHAR2 (150)
USER_ATTR6 VARCHAR2 (150)
USER_ATTR7 VARCHAR2 (150)
USER_ATTR8 VARCHAR2 (150)
USER_ATTR9 VARCHAR2 (150)
USER_ATTR10 VARCHAR2 (150)
USER_ATTR11 VARCHAR2 (150)
USER_ATTR12 VARCHAR2 (150)
USER_ATTR13 VARCHAR2 (150)
USER_ATTR14 VARCHAR2 (150)
USER_ATTR15 VARCHAR2 (150)
USER_ATTR16 VARCHAR2 (150)
USER_ATTR17 VARCHAR2 (150)
USER_ATTR18 VARCHAR2 (150)
USER_ATTR19 VARCHAR2 (150)
USER_ATTR20 VARCHAR2 (150)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_SYSTEM_ID NUMBER
Yes
LAST_UPDATE_SYSTEM_ID NUMBER
Yes
CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
PARENT_WORKORDER_ID VARCHAR2 (30)
RECIPE_NUM VARCHAR2 (32)
RECIPE_VERSION VARCHAR2 (15)
FORMULA_NUM VARCHAR2 (32)
FORMULA_VERSION VARCHAR2 (15)
REQ_COMPLETION_DATE DATE

BATCH_TYPE VARCHAR2 (240)
TERMINATED_IND NUMBER

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
,      TERMINATED_IND
FROM MTH.MTH_PRODUCTION_SCHEDULES_F#;

Dependencies

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_F# references the following:

SchemaMTH
TableMTH_PRODUCTION_SCHEDULES_F
MTH.MTH_PRODUCTION_SCHEDULES_F# is referenced by following:

SchemaAPPS
SynonymMTH_PRODUCTION_SCHEDULES_F