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

TABLE: EAM.EAM_FORECAST_WDJ

Object Details
Object Name: EAM_FORECAST_WDJ
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_FORECAST_WDJ
Subobject Name:
Status: VALID


This table stores all of the work order information for a forecasted work order for eAM maintenance budgeting and forecasting. Work orders are extracted according to the criteria of a budget forecast, which is stored in EAM_FORECASTS. This table mirrors the structure of wip_discrete_jobs.
WIP_DISCRETE_JOBS stores discrete job information. Each row
represents a discrete job, and contains information about the assembly
being built, the revision of the assembly, the job quantity, the
status of the job, the material control method, accounting
information, and job schedule dates. Oracle Work in Process uses this
information to control discrete production.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Yes WIP Job Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
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
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

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)
DESCRIPTION VARCHAR2 (240)
Descriptive text
STATUS_TYPE NUMBER
Yes Status of job
PRIMARY_ITEM_ID NUMBER

nventory item Identifier for the assembly the job creates
FIRM_PLANNED_FLAG NUMBER
Yes Control for MRP rescheduling
JOB_TYPE NUMBER
Yes Type of discrete job
WIP_SUPPLY_TYPE NUMBER
Yes Method of material consumption within WIP
CLASS_CODE VARCHAR2 (10) Yes Accounting class associated with job
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 resource 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
Yes Date on which job is scheduled to start
DATE_RELEASED DATE

Date on which job is released
SCHEDULED_COMPLETION_DATE DATE
Yes Last unit scheduled completion date
DATE_COMPLETED DATE

Last unit actual completion date
DATE_CLOSED DATE

Date on which job was closed
START_QUANTITY NUMBER
Yes Job start quantity
QUANTITY_COMPLETED NUMBER
Yes Current job quantity completed
QUANTITY_SCRAPPED NUMBER
Yes Number of units scrapped on the current job
NET_QUANTITY NUMBER
Yes Number of assemblies netted to supply by MRP
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 explosions of nonstandard job
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
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
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
LOT_NUMBER VARCHAR2 (80)
Default lot number to assign to assemblies completed from the job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a job
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
COMPLETION_LOCATOR_ID NUMBER

Default completion locator identifier for assemblies completed by the job
MPS_SCHEDULED_COMPLETION_DATE DATE

Date used by MRP to relieve the MPS for the job (used by MRP only)
MPS_NET_QUANTITY NUMBER

Quantity used by MRP to relieve MPS for the job (used by MRP only)
DEMAND_CLASS VARCHAR2 (30)
Type of demand the job satisfies
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
SCHEDULE_GROUP_ID NUMBER

Identifier for the job schedule group
BUILD_SEQUENCE NUMBER

Build sequence
LINE_ID NUMBER

Production line Identifier
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Project task Identifier
KANBAN_CARD_ID NUMBER

Identifier for production kanban replentished by the job
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount)
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Percent or amount above start quantity that this job is allowed to complete
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
PO_CREATION_TIME NUMBER

PO Creation Time for Outside Processing
PRIORITY NUMBER

Priority of this job
DUE_DATE DATE

Due date of this job
EST_SCRAP_ACCOUNT NUMBER

Estimated Scrap account
EST_SCRAP_VAR_ACCOUNT NUMBER

Estimated Scrap variance account
EST_SCRAP_PRIOR_QTY NUMBER

Estimated quantity completed for calculation of operation yield
DUE_DATE_PENALTY NUMBER

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

Number of days a job can be late
COPRODUCTS_SUPPLY NUMBER

Flag indicating if this job forms supply for co-products also
PARENT_WIP_ENTITY_ID NUMBER

Parent Job Identifier
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
MANUAL_REBUILD_FLAG VARCHAR2 (1)
The flag indicating whether this rebuild work order is created manually.
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
ESTIMATION_STATUS NUMBER

Costing Estimation Status
REQUESTED_START_DATE DATE

Requested Start Date
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Requried Flag
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
OWNING_DEPARTMENT NUMBER

Work order owning department
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Planned Maintenance Flag
PM_SCHEDULE_ID NUMBER

The preventive maintenance schedule that generates this work order.
LAST_ESTIMATION_DATE DATE

last estimation date
LAST_ESTIMATION_REQ_ID NUMBER

last estimation ID
ACTIVITY_SOURCE VARCHAR2 (30)
Activity source
SERIALIZATION_START_OP NUMBER

first operation under serialized control
MAINTENANCE_OBJECT_ID NUMBER

maintenance object id
MAINTENANCE_OBJECT_TYPE NUMBER

maintenance object type
MAINTENANCE_OBJECT_SOURCE NUMBER

maintenance object source
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Enable Material Issue Requests
SCHEDULING_REQUEST_ID NUMBER

Constraint Based Scheduling Request Identifier
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
Issue asset items from Expense subinventory at Zero cost
EAM_LINEAR_LOCATION_ID NUMBER

Linear Asset Location Identifier
WSM_CURRENT_RTG_OP_SEQ_NUM NUMBER

Not Used
ACTUAL_START_DATE DATE

An actual job start time calculated based on info collected.
ACTUAL_COMPLETION_DATE DATE

Not Used
FORECAST_ID NUMBER
Yes Forecast Id
EXPEDITED VARCHAR2 (1)
Expedited flag
EXPECTED_HOLD_RELEASE_DATE DATE

An expected time to release job from on hold.
Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_LINE_ID
,      SOURCE_CODE
,      DESCRIPTION
,      STATUS_TYPE
,      PRIMARY_ITEM_ID
,      FIRM_PLANNED_FLAG
,      JOB_TYPE
,      WIP_SUPPLY_TYPE
,      CLASS_CODE
,      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
,      DATE_RELEASED
,      SCHEDULED_COMPLETION_DATE
,      DATE_COMPLETED
,      DATE_CLOSED
,      START_QUANTITY
,      QUANTITY_COMPLETED
,      QUANTITY_SCRAPPED
,      NET_QUANTITY
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      BOM_REVISION
,      ROUTING_REVISION
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      LOT_NUMBER
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      MPS_SCHEDULED_COMPLETION_DATE
,      MPS_NET_QUANTITY
,      DEMAND_CLASS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      KANBAN_CARD_ID
,      OVERCOMPLETION_TOLERANCE_TYPE
,      OVERCOMPLETION_TOLERANCE_VALUE
,      END_ITEM_UNIT_NUMBER
,      PO_CREATION_TIME
,      PRIORITY
,      DUE_DATE
,      EST_SCRAP_ACCOUNT
,      EST_SCRAP_VAR_ACCOUNT
,      EST_SCRAP_PRIOR_QTY
,      DUE_DATE_PENALTY
,      DUE_DATE_TOLERANCE
,      COPRODUCTS_SUPPLY
,      PARENT_WIP_ENTITY_ID
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      MANUAL_REBUILD_FLAG
,      SHUTDOWN_TYPE
,      ESTIMATION_STATUS
,      REQUESTED_START_DATE
,      NOTIFICATION_REQUIRED
,      WORK_ORDER_TYPE
,      OWNING_DEPARTMENT
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      PM_SCHEDULE_ID
,      LAST_ESTIMATION_DATE
,      LAST_ESTIMATION_REQ_ID
,      ACTIVITY_SOURCE
,      SERIALIZATION_START_OP
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      MATERIAL_ISSUE_BY_MO
,      SCHEDULING_REQUEST_ID
,      ISSUE_ZERO_COST_FLAG
,      EAM_LINEAR_LOCATION_ID
,      WSM_CURRENT_RTG_OP_SEQ_NUM
,      ACTUAL_START_DATE
,      ACTUAL_COMPLETION_DATE
,      FORECAST_ID
,      EXPEDITED
,      EXPECTED_HOLD_RELEASE_DATE
FROM EAM.EAM_FORECAST_WDJ;

Dependencies

[top of page]

EAM.EAM_FORECAST_WDJ does not reference any database object

EAM.EAM_FORECAST_WDJ is referenced by following:

SchemaAPPS
SynonymEAM_FORECAST_WDJ