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

TABLE: EAM.EAM_WORK_ORDER_IMPORT

Object Details
Object Name: EAM_WORK_ORDER_IMPORT
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_WORK_ORDER_IMPORT
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_WORK_ORDER_IMPORT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnWIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Header Identifier
GROUP_ID NUMBER
Yes Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Work Order Name
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
DESCRIPTION VARCHAR2 (240)
Descriptive text
ASSET_NUMBER VARCHAR2 (30)
Asset Number
ASSET_GROUP_ID NUMBER

Asset Group Identifer
REBUILD_ITEM_ID NUMBER

Rebuild Item Identifier
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Serial Number
MAINTENANCE_OBJECT_ID NUMBER

maintenance object id
MAINTENANCE_OBJECT_TYPE NUMBER

maintenance object type
MAINTENANCE_OBJECT_SOURCE NUMBER

maintenance object source
CLASS_CODE VARCHAR2 (10)
Accounting class associated with job
ASSET_ACTIVITY_ID NUMBER

Inventory item Identifier for the assembly the job creates
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause
ACTIVITY_SOURCE VARCHAR2 (30)
Activity source
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
STATUS_TYPE NUMBER

Status of job
JOB_QUANTITY NUMBER

Job Quantity
DATE_RELEASED DATE

Date on which job is released
OWNING_DEPARTMENT NUMBER

Work order owning department
PRIORITY NUMBER

Priority of this job
REQUESTED_START_DATE DATE

Requested Start Date
DUE_DATE DATE

Due date of this job
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
FIRM_PLANNED_FLAG NUMBER

Control for MRP rescheduling
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Requried Flag
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Planned Maintenance Flag
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Project task Identifier
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
SCHEDULE_GROUP_ID NUMBER

Identifier for the job schedule group
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a job
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
PARENT_WIP_ENTITY_ID NUMBER

Parent Job Identifier
MANUAL_REBUILD_FLAG VARCHAR2 (1)
The flag indicating whether this rebuild work order is created manually
PM_SCHEDULE_ID NUMBER

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

Method of material consumption within WIP
MATERIAL_ACCOUNT NUMBER

General Ledger account to accumulate material charges for a job
MATERIAL_OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate material overhead charges for a job
RESOURCE_ACCOUNT NUMBER

General Ledger account to accumulate resource charges for a job
OUTSIDE_PROCESSING_ACCOUNT NUMBER

General Ledger account to accumulate outside processing charges for a job
MATERIAL_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate material variances for a job
RESOURCE_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate resource variances for a job
OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate outside processing variances for a job
STD_COST_ADJUSTMENT_ACCOUNT NUMBER

General Ledger account to accumulate standard cost variances for a job
OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate overhead charges for a job
OVERHEAD_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate overhead variances for a job
SCHEDULED_START_DATE DATE

Date on which job is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
PO_CREATION_TIME NUMBER

PO Creation Time for Outside Processing
GEN_OBJECT_ID NUMBER

Genealogy object identifier
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
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Enable Material Issue Requests
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
Issue asset items from Expense subinventory at Zero cost
USER_ID NUMBER

User Identifier
RESPONSIBILITY_ID NUMBER

Responsibility Identifier
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
SOURCE_LINE_ID NUMBER

Identifier of the source system that generated the job record
SOURCE_CODE VARCHAR2 (30)
Code of the process that generated the job record(null if created by Oracle Work In Process)
PROCESS_STATUS NUMBER

Status of processing (1=Picked up by program, 2= locked and being processed, 3=Relationship error, 4=Errored)
TOP_WIP_ENTITY_ID NUMBER

Updated by program and used for rolling back updates for hierarchies with invalid structures
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT HEADER_ID
,      GROUP_ID
,      ROW_ID
,      WIP_ENTITY_NAME
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      DESCRIPTION
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      CLASS_CODE
,      ASSET_ACTIVITY_ID
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      ACTIVITY_SOURCE
,      WORK_ORDER_TYPE
,      STATUS_TYPE
,      JOB_QUANTITY
,      DATE_RELEASED
,      OWNING_DEPARTMENT
,      PRIORITY
,      REQUESTED_START_DATE
,      DUE_DATE
,      SHUTDOWN_TYPE
,      FIRM_PLANNED_FLAG
,      NOTIFICATION_REQUIRED
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      SCHEDULE_GROUP_ID
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      ROUTING_REVISION
,      BOM_REVISION
,      PARENT_WIP_ENTITY_ID
,      MANUAL_REBUILD_FLAG
,      PM_SCHEDULE_ID
,      WIP_SUPPLY_TYPE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      RESOURCE_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      MATERIAL_VARIANCE_ACCOUNT
,      RESOURCE_VARIANCE_ACCOUNT
,      OUTSIDE_PROC_VARIANCE_ACCOUNT
,      STD_COST_ADJUSTMENT_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OVERHEAD_VARIANCE_ACCOUNT
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      PO_CREATION_TIME
,      GEN_OBJECT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MATERIAL_ISSUE_BY_MO
,      ISSUE_ZERO_COST_FLAG
,      USER_ID
,      RESPONSIBILITY_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      SOURCE_LINE_ID
,      SOURCE_CODE
,      PROCESS_STATUS
,      TOP_WIP_ENTITY_ID
,      RETURN_STATUS
,      TRANSACTION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_WORK_ORDER_IMPORT;

Dependencies

[top of page]

EAM.EAM_WORK_ORDER_IMPORT does not reference any database object

EAM.EAM_WORK_ORDER_IMPORT is referenced by following:

SchemaAPPS
SynonymEAM_WORK_ORDER_IMPORT