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

VIEW: APPS.WIP_EAM_WORK_ORDERS_V

Object Details
Object Name: WIP_EAM_WORK_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_EAM_WORK_ORDERS_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The Row Identifier from WIP_DISCRETE_JOBS
WIP_ENTITY_ID NUMBER

Maintenance Work Order Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Name of the Maintenance Work Order
WE_ROW_ID ROWID (10)
WIP entity row Identifier
ENTITY_TYPE NUMBER

Maintenance Work Order Type
ORGANIZATION_ID NUMBER

Organization identifier
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
DESCRIPTION VARCHAR2 (240)
Description field for the Maintenance Work Order
PRIMARY_ITEM_ID NUMBER

Inventory item Identifier of the assembly that the Work Order maintains
ASSET_GROUP_ID NUMBER

Asset Group Identifier where the Asset Number belongs
ASSET_NUMBER VARCHAR2 (4000)
Asset Number in the Asset Group
ASSET_DESCRIPTION VARCHAR2 (240)
Description field for the Asset Number
CLASS_CODE VARCHAR2 (10)
Accounting class associated with the Work Order
STATUS_TYPE NUMBER

Status of the Work Order
PM_SCHEDULE_ID NUMBER

The preventive maintenance schedule identifier that generates the work order
MANUAL_REBUILD_FLAG VARCHAR2 (1)
The flag indicating whether this rebuild work order is created manually
WORK_ORDER_TYPE VARCHAR2 (30)
Maintenance Work Order Type
WORK_ORDER_TYPE_DISP VARCHAR2 (80)
Displayed Work Order Type
MATERIAL_ACCOUNT NUMBER

General ledger account to accumulate material charges for work order
MATERIAL_OVERHEAD_ACCOUNT NUMBER

General ledger account to accumulate material overhead charges for work order
RESOURCE_ACCOUNT NUMBER

General ledger account to accumulate resource charges for work order
OUTSIDE_PROCESSING_ACCOUNT NUMBER

General ledger account to accumulate outside proecessing charges for work order
MATERIAL_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate material variances for work order
RESOURCE_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate resource variance for work order
OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate outside processing variance for work order
STD_COST_ADJUSTMENT_ACCOUNT NUMBER

General ledger account to accumulate standard cost variance for work order
OVERHEAD_ACCOUNT NUMBER

General ledger account to accumulate overhead charges for work order
OVERHEAD_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate overhead variance for work order
SCHEDULED_START_DATE DATE

Date on which Maintenance Work Order is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Date on which Maintenance Work Order is scheduled to complete
DATE_RELEASED DATE

Date on which the Maintenance Work Order is released
DATE_COMPLETED DATE

Date on which Maintenance Work Order was completed
DATE_CLOSED DATE

Date on which Maintenance Work Order was closed
OWNING_DEPARTMENT NUMBER

Owning Department of the Asset Number
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
Asset number owning department code
ACTIVITY_TYPE VARCHAR2 (30)
Type of Maintenance Activity that is performed
ACTIVITY_TYPE_DISP VARCHAR2 (80)
Displayed Type of Maintenance Activity that is performed
ACTIVITY_CAUSE VARCHAR2 (30)
Cause of Maintenance Activity
ACTIVITY_CAUSE_DISP VARCHAR2 (80)
Displayed Cause of Maintenance Activity
PRIORITY NUMBER

Priority of the Maintenance Work Order
PRIORITY_DISP VARCHAR2 (80)
Displayed Priority of the Maintenance Work Order
REQUESTED_START_DATE DATE

Requested Start Date of the Maintenance Work Order
REQUESTED_DUE_DATE DATE

Requested Due Date of the Maintenance Work Order
ESTIMATION_STATUS NUMBER

Work Order Cost Estimation status
NOTIFICATION_REQUIRED VARCHAR2 (1)
Maintenance Work Order Notification Required Flag
SHUTDOWN_TYPE VARCHAR2 (30)
Maintenance Work Order Shutdown Required Type
SHUTDOWN_TYPE_DISP VARCHAR2 (80)
Maintenance Work Order Shutdown Required Type that is displayed
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Planned maintenance flag
FIRM_PLANNED_FLAG NUMBER

Control for MRP rescheduling
SCHEDULE_GROUP_ID NUMBER

Schedule group for the work order
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Name of the schedule group
PROJECT_NUMBER VARCHAR2 (4000)
The project number that uniquely identifies the project
PROJECT_NAME VARCHAR2 (4000)
User defined name that uniquely identifies the project
PROJECT_ID NUMBER

The unqiue identifier of the project
TASK_NUMBER VARCHAR2 (4000)
User defined task number that uniquely identifies the task
TASK_NAME VARCHAR2 (4000)
User defined name of the task
TASK_ID NUMBER

The unique identifier of the task
PARENT_WIP_ENTITY_ID NUMBER

Parent Maintenance Work Order WIP entity identifier
PARENT_WIP_ENTITY_NAME VARCHAR2 (240)
Parent Maintenance Work Order WIP entity name
REBUILD_ITEM_ID NUMBER

Rebuildable item id for which the Maintenace Work Order exists
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuildable item serial number for which the Maintenace Work Order exists
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
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a work order
BOM_REVISION VARCHAR2 (3)
Inventory item revision code
BOM_REVISION_DATE DATE

Date of inventory item revision used to explode the bill of materials used in the work order
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a work order
ROUTING_REVISION VARCHAR2 (3)
Routing revision code
ROUTING_REVISION_DATE DATE

Routing revision date
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
LOT_NUMBER VARCHAR2 (80)
Default lot number to assign to assemblies completed from the job
DEMAND_CLASS VARCHAR2 (30)
Type of demand the work order 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
INSTANCE_ID NUMBER

INSTANCE_NUMBER VARCHAR2 (30)
MAINTENANCE_OBJECT_SOURCE NUMBER

MAINTENANCE_OBJECT_TYPE NUMBER

SOURCE VARCHAR2 (80)
MAINTENANCE_OBJECT_ID NUMBER

SERVICE_REQUEST_ID VARCHAR2 (0)
SERVICE_REQUEST VARCHAR2 (0)
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
ACTIVITY_SOURCE VARCHAR2 (30)
ACTIVITY_SOURCE_MEANING VARCHAR2 (80)
MAINTAINED_ITEM_ID NUMBER

EAM_LINEAR_LOCATION_ID NUMBER

Linear Asset Location Identifier
PENDING_FLAG VARCHAR2 (1)
Stores whether status change has some pending approval.Y indicates status is pending, N or Null indicates not pending
USER_DEFINED_STATUS_ID NUMBER

Stores the User defined work order status
WORK_ORDER_STATUS VARCHAR2 (80)
Status of work order
WORK_ORDER_STATUS_PENDING VARCHAR2 (4000)
Concatenates Pending flag with user defined status if the work order is in pending status else shows the user defined status
MATERIAL_SHORTAGE_CHECK_DATE DATE

The date at which the work order was checked for material shortage
MATERIAL_SHORTAGE_FLAG NUMBER

Stores the material shortage status of the workorder. 2 if all material is available, 1 if some/all material is not available, null if shortage has not been calculated yet, 3 if an error occurred when calculating the shortage.
MATERIAL_SHORTAGE_DISP VARCHAR2 (80)
Description of material shortage
WORKFLOW_TYPE NUMBER

Stores the Workflow Type to find the workflow process to be followed. Maps to lookup_code for EAM_WORKFLOW_TYPE lookup type
WARRANTY_CLAIM_STATUS NUMBER

The status of the warranty claim.
CYCLE_ID NUMBER

Used by Multiple Asset Activity PM
SEQ_ID NUMBER

Used by Multiple Asset Activity PM
DS_SCHEDULED_FLAG VARCHAR2 (1)
Identify if the Detailed Scheduler has scheduled the work order.
ESTIMATE_ID NUMBER

ESTIMATE_NUMBER VARCHAR2 (30)
ASSET_SERIAL_NUMBER VARCHAR2 (30)
serial number
MAINT_ORGANIZATION_ID NUMBER

Maitenance Organization Id
Query Text

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


SELECT ROW_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WE_ROW_ID
,      ENTITY_TYPE
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      PRIMARY_ITEM_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      CLASS_CODE
,      STATUS_TYPE
,      PM_SCHEDULE_ID
,      MANUAL_REBUILD_FLAG
,      WORK_ORDER_TYPE
,      WORK_ORDER_TYPE_DISP
,      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
,      DATE_RELEASED
,      DATE_COMPLETED
,      DATE_CLOSED
,      OWNING_DEPARTMENT
,      OWNING_DEPARTMENT_CODE
,      ACTIVITY_TYPE
,      ACTIVITY_TYPE_DISP
,      ACTIVITY_CAUSE
,      ACTIVITY_CAUSE_DISP
,      PRIORITY
,      PRIORITY_DISP
,      REQUESTED_START_DATE
,      REQUESTED_DUE_DATE
,      ESTIMATION_STATUS
,      NOTIFICATION_REQUIRED
,      SHUTDOWN_TYPE
,      SHUTDOWN_TYPE_DISP
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      FIRM_PLANNED_FLAG
,      SCHEDULE_GROUP_ID
,      SCHEDULE_GROUP_NAME
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_ID
,      PARENT_WIP_ENTITY_ID
,      PARENT_WIP_ENTITY_NAME
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      BOM_REFERENCE_ID
,      ROUTING_REFERENCE_ID
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      ALTERNATE_BOM_DESIGNATOR
,      BOM_REVISION
,      BOM_REVISION_DATE
,      ALTERNATE_ROUTING_DESIGNATOR
,      ROUTING_REVISION
,      ROUTING_REVISION_DATE
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      LOT_NUMBER
,      DEMAND_CLASS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INSTANCE_ID
,      INSTANCE_NUMBER
,      MAINTENANCE_OBJECT_SOURCE
,      MAINTENANCE_OBJECT_TYPE
,      SOURCE
,      MAINTENANCE_OBJECT_ID
,      SERVICE_REQUEST_ID
,      SERVICE_REQUEST
,      MATERIAL_ISSUE_BY_MO
,      ACTIVITY_SOURCE
,      ACTIVITY_SOURCE_MEANING
,      MAINTAINED_ITEM_ID
,      EAM_LINEAR_LOCATION_ID
,      PENDING_FLAG
,      USER_DEFINED_STATUS_ID
,      WORK_ORDER_STATUS
,      WORK_ORDER_STATUS_PENDING
,      MATERIAL_SHORTAGE_CHECK_DATE
,      MATERIAL_SHORTAGE_FLAG
,      MATERIAL_SHORTAGE_DISP
,      WORKFLOW_TYPE
,      WARRANTY_CLAIM_STATUS
,      CYCLE_ID
,      SEQ_ID
,      DS_SCHEDULED_FLAG
,      ESTIMATE_ID
,      ESTIMATE_NUMBER
,      ASSET_SERIAL_NUMBER
,      MAINT_ORGANIZATION_ID
FROM APPS.WIP_EAM_WORK_ORDERS_V;

Dependencies

[top of page]

APPS.WIP_EAM_WORK_ORDERS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymCSI_ITEM_INSTANCES
PL/SQL PackageEAM_COMMON_UTILITIES_PVT - show dependent code
ViewEAM_WORK_ORDER_DETAILS_V
PL/SQL PackageFND_MESSAGE - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_PARAMETERS
PL/SQL PackagePJM_PROJECT - show dependent code
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_SCHEDULE_GROUPS

APPS.WIP_EAM_WORK_ORDERS_V is not referenced by any database object