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


TABLE: MTH.MTH_PRODUCTION_SCHEDULES_I_STG

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


Interface table for MTH_PRODUCTION_SCHEDULES_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes Internal column for EBS integration only
WIP_ENTITY_NAME VARCHAR2 (240) Yes Internal column for EBS integration only
ORGANIZATION_CODE VARCHAR2 (120)
Internal column for EBS integration only
ORGANIZATION_ID NUMBER

Internal column for EBS integration only
DB_GLOBAL_NAME VARCHAR2 (120) Yes Internal column for EBS integration only
WORKORDER_TYPE NUMBER
Yes Internal column for EBS integration only
STATUS VARCHAR2 (80) Yes Internal column for EBS integration only
PLANNED_START_DATE DATE
Yes Internal column for EBS integration only
PLANNED_COMPLETION_DATE DATE

Internal column for EBS integration only
ACTUAL_START_DATE DATE

Internal column for EBS integration only
ACTUAL_COMPLETION_DATE DATE

Internal column for EBS integration only
DATE_RELEASED DATE

Internal column for EBS integration only
BOM_REVISION VARCHAR2 (3)
Internal column for EBS integration only
ROUTING_REVISION VARCHAR2 (3)
Internal column for EBS integration only
BOM_REVISION_DATE DATE

Internal column for EBS integration only
ROUTING_REVISION_DATE DATE

Internal column for EBS integration only
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Internal column for EBS integration only
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Internal column for EBS integration only
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Internal column for EBS integration only
COMPLETION_LOCATOR_ID NUMBER

Internal column for EBS integration only
DEMAND_CLASS VARCHAR2 (30)
Internal column for EBS integration only
SCHEDULE_GROUP_ID NUMBER

Internal column for EBS integration only
BUILD_SEQUENCE NUMBER

Internal column for EBS integration only
DEMAND_SOURCE_HEADER_ID NUMBER

Internal column for EBS integration only
DEMAND_SOURCE_LINE VARCHAR2 (30)
Internal column for EBS integration only
DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
Internal column for EBS integration only
DEMAND_SOURCE_TYPE NUMBER

Internal column for EBS integration only
KANBAN_CARD_ID NUMBER

Internal column for EBS integration only
LINE_CODE VARCHAR2 (10)
Internal column for EBS integration only
PARENT_WORKORDER VARCHAR2 (30)
Internal column for EBS integration only
PARENT_OPERATION_SEQ_NUM NUMBER

Internal column for EBS integration only
HUB_ORGANIZATION_CODE VARCHAR2 (120)
Internal column for EBS integration only
USER_ATTR1 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR2 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR3 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR4 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR5 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR6 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR7 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR8 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR9 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR10 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR11 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR12 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR13 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR14 VARCHAR2 (150)
Internal column for EBS integration only
USER_ATTR15 VARCHAR2 (150)
Internal column for EBS integration only
RECIPE_NUM VARCHAR2 (32)
Internal column for EBS integration only
RECIPE_VERSION VARCHAR2 (15)
Internal column for EBS integration only
FORMULA_NUM VARCHAR2 (32)
Internal column for EBS integration only
FORMULA_VERSION VARCHAR2 (15)
Internal column for EBS integration only
BATCH_TYPE VARCHAR2 (20)
Internal column for EBS integration only
REQ_COMPLETION_DATE DATE

Internal column for EBS integration only
TERMINATED_IND NUMBER (22)
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 WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ORGANIZATION_CODE
,      ORGANIZATION_ID
,      DB_GLOBAL_NAME
,      WORKORDER_TYPE
,      STATUS
,      PLANNED_START_DATE
,      PLANNED_COMPLETION_DATE
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      DATE_RELEASED
,      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
,      LINE_CODE
,      PARENT_WORKORDER
,      PARENT_OPERATION_SEQ_NUM
,      HUB_ORGANIZATION_CODE
,      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
,      RECIPE_NUM
,      RECIPE_VERSION
,      FORMULA_NUM
,      FORMULA_VERSION
,      BATCH_TYPE
,      REQ_COMPLETION_DATE
,      TERMINATED_IND
FROM MTH.MTH_PRODUCTION_SCHEDULES_I_STG;

Dependencies

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_I_STG does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_I_STG is referenced by following:

SchemaMTH
ViewMTH_PRODUCTION_SCHEDULES_I_ST#