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

TABLE: WIP.WIP_JOB_SCHEDULE_INTERFACE

Object Details
Object Name: WIP_JOB_SCHEDULE_INTERFACE
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_JOB_SCHEDULE_INTERFACE
Subobject Name:
Status: VALID


WIP_JOB_SCHEDULE_INTERFACE contains requests to create or modify
discrete jobs or repetitive schedules. Several non-WIP Oracle
Applications products place requests in this table in order to load
job and schedule information into WIP. You can use this table to load
data into WIP from external sources by following the guidelines laid
out in the Oracle Work in Process Open Job and Schedule Interface
documentation. The WIP Mass Load concurrent program processes
rows in this table.
Scope: public
Product: WIP
Lifecycle: active
Display Name: WIP Job Schedule Interface
Category: BUSINESS_ENTITY WIP_WORK_ORDER


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_JOB_SCHEDULE_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_ID
WIP_JOB_SCHEDULE_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnLOAD_TYPE
ColumnORGANIZATION_ID
WIP_JOB_SCHEDULE_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSOURCE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ID NUMBER

Interface Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Last updated by name
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY_NAME VARCHAR2 (100)
Name of person who created the interface records
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
GROUP_ID NUMBER

Processing group Identifier
SOURCE_CODE VARCHAR2 (30)
Code of the process that generated the interface record
PROCESS_PHASE NUMBER

Process phase
PROCESS_STATUS NUMBER

Process status
SOURCE_LINE_ID NUMBER

Identifier of the source system that generated the interface record
ORGANIZATION_CODE VARCHAR2 (3)
Short code that uniquely identifies the organization
ORGANIZATION_ID NUMBER

Organization Identifier
LOAD_TYPE NUMBER
Yes Type of interface record
STATUS_TYPE NUMBER

Status of the job or repetitive schedule to be loaded
FIRST_UNIT_START_DATE DATE

Date job or schedule should start
FIRST_UNIT_COMPLETION_DATE DATE

Date job or schedule should complete the first unit
LAST_UNIT_START_DATE DATE

Date job or schedule should begin processing the last unit
LAST_UNIT_COMPLETION_DATE DATE

Date job or schedule should end
SCHEDULING_METHOD NUMBER

Scheduling method
PROCESSING_WORK_DAYS NUMBER

Processing days of repetitive schedule
DAILY_PRODUCTION_RATE NUMBER

Schedule daily quantity
LINE_ID NUMBER

WIP line Identifier
LINE_CODE VARCHAR2 (10)
Line Code
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier for the assembly that the job or repetitive schedule creates
BOM_REFERENCE_ID NUMBER

Assembly Identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly Identifier used as routing reference for scheduling of nonstandard job
ROUTING_REVISION VARCHAR2 (3)
Revision to the assembly routing
BOM_REVISION VARCHAR2 (3)
Revision to the bill of material
BOM_REVISION_DATE DATE

Date of inventory item revision used to explode the bill of materials used in the job or schedule
ROUTING_REVISION_DATE DATE

Routing revision date
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion subinventory
COMPLETION_LOCATOR_ID NUMBER

Completion locator Identifier
COMPLETION_LOCATOR_SEGMENTS VARCHAR2 (2000)
Completion locator segments
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
CLASS_CODE VARCHAR2 (10)
Accounting class associated with job or repetitive assembly
LOT_NUMBER VARCHAR2 (80)
Default lot number to assign to assemblies completed from the job
JOB_NAME VARCHAR2 (240)
WIP job name
DESCRIPTION VARCHAR2 (240)
Descriptive text
FIRM_PLANNED_FLAG NUMBER

Control for MRP rescheduling
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job or repetitive schedule
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in job or schedule
SCHEDULE_GROUP_ID NUMBER

Schedule group Identifier
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Schedule group name
BUILD_SEQUENCE NUMBER

Build sequence
PROJECT_ID NUMBER

Project Identifier
PROJECT_NUMBER VARCHAR2 (25)
Project number
TASK_ID NUMBER

Task Identifier
TASK_NUMBER VARCHAR2 (25)
Task number
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Assembly unit number Identifier to support Project Manufacturing in Model Unit Effectivity.
DEMAND_CLASS VARCHAR2 (30)
Type of demand the job or schedule satisfies
NET_QUANTITY NUMBER

Job net quantity
START_QUANTITY NUMBER

Job start quantity
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly Identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount)
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Percent or amount above expected quantity that this entity is allowed to complete
KANBAN_CARD_ID NUMBER

Production kanban replentished by the WIP entity being created
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
PRIORITY NUMBER

Priority to assign to the job being created
DUE_DATE DATE

Due date of the job that is being created
ALLOW_EXPLOSION VARCHAR2 (1)
Determines whether you can run the exploder, thereby creating child records in addition to the job header record
HEADER_ID NUMBER

Uniquely identifies this request so that it can be referenced by child requests in other interfaces
DELIVERY_ID NUMBER

Delivery Id
COPRODUCTS_SUPPLY NUMBER

Supply of the coproducts
DUE_DATE_PENALTY NUMBER

Penalty incurred if job is late (in days)
DUE_DATE_TOLERANCE NUMBER

Number of days a job can be late
PRIMARY_ITEM_SEGMENTS VARCHAR2 (2000)
primary item
XML_DOCUMENT_ID VARCHAR2 (240)
XML message identifier
PARENT_WIP_ENTITY_ID NUMBER

Parent Job Identifier
PARENT_JOB_NAME VARCHAR2 (240)
Parent Job Name
ASSET_NUMBER VARCHAR2 (30)
Asset number
ASSET_GROUP_ID NUMBER

Asset Group Identifier
ASSET_GROUP_SEGMENTS VARCHAR2 (2000)
Asset Group Segments
PM_SCHEDULE_ID NUMBER

The preventive maintenance schedule that generates this work order.
REBUILD_ITEM_ID NUMBER

Rebuild Item Identifier
REBUILD_ITEM_SEGMENTS VARCHAR2 (2000)
Rebuild Item Number Segments
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Serial Numbers
MANUAL_REBUILD_FLAG VARCHAR2 (1)
Manual Rebuild Flag
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Required Flag
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
OWNING_DEPARTMENT NUMBER

Owning Department
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
Owning Department Code
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout Required Flag
PLAN_MAINTENANCE VARCHAR2 (1)
Plan Maintanence Flag
DATE_RELEASED DATE

Release Date of the Job/Schedule
REQUESTED_START_DATE DATE

Requested start date
ROUTING_REFERENCE_SEGMENTS VARCHAR2 (2000)
routing reference
BOM_REFERENCE_SEGMENTS VARCHAR2 (2000)
bom reference
ACTIVITY_SOURCE VARCHAR2 (30)
activity source
MAINTENANCE_OBJECT_ID NUMBER

maintenance object ID
MAINTENANCE_OBJECT_TYPE NUMBER

maintenance object type
MAINTENANCE_OBJECT_SOURCE NUMBER

maintenance object source
SERIALIZATION_START_OP NUMBER

Serialization start operation
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
For EAM only
Query Text

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


SELECT INTERFACE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BY_NAME
,      CREATION_DATE
,      CREATED_BY_NAME
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SOURCE_CODE
,      PROCESS_PHASE
,      PROCESS_STATUS
,      SOURCE_LINE_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_ID
,      LOAD_TYPE
,      STATUS_TYPE
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      SCHEDULING_METHOD
,      PROCESSING_WORK_DAYS
,      DAILY_PRODUCTION_RATE
,      LINE_ID
,      LINE_CODE
,      PRIMARY_ITEM_ID
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      ROUTING_REVISION
,      BOM_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      COMPLETION_LOCATOR_SEGMENTS
,      WIP_SUPPLY_TYPE
,      CLASS_CODE
,      LOT_NUMBER
,      JOB_NAME
,      DESCRIPTION
,      FIRM_PLANNED_FLAG
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      SCHEDULE_GROUP_ID
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      END_ITEM_UNIT_NUMBER
,      DEMAND_CLASS
,      NET_QUANTITY
,      START_QUANTITY
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      KANBAN_CARD_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRIORITY
,      DUE_DATE
,      ALLOW_EXPLOSION
,      HEADER_ID
,      DELIVERY_ID
,      COPRODUCTS_SUPPLY
,      DUE_DATE_PENALTY
,      DUE_DATE_TOLERANCE
,      PRIMARY_ITEM_SEGMENTS
,      XML_DOCUMENT_ID
,      PARENT_WIP_ENTITY_ID
,      PARENT_JOB_NAME
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      ASSET_GROUP_SEGMENTS
,      PM_SCHEDULE_ID
,      REBUILD_ITEM_ID
,      REBUILD_ITEM_SEGMENTS
,      REBUILD_SERIAL_NUMBER
,      MANUAL_REBUILD_FLAG
,      SHUTDOWN_TYPE
,      NOTIFICATION_REQUIRED
,      WORK_ORDER_TYPE
,      OWNING_DEPARTMENT
,      OWNING_DEPARTMENT_CODE
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      DATE_RELEASED
,      REQUESTED_START_DATE
,      ROUTING_REFERENCE_SEGMENTS
,      BOM_REFERENCE_SEGMENTS
,      ACTIVITY_SOURCE
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      SERIALIZATION_START_OP
,      MATERIAL_ISSUE_BY_MO
FROM WIP.WIP_JOB_SCHEDULE_INTERFACE;

Dependencies

[top of page]

WIP.WIP_JOB_SCHEDULE_INTERFACE does not reference any database object

WIP.WIP_JOB_SCHEDULE_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_JOB_SCHEDULE_INTERFACE#