Work Order
The Work Order view object contains information about what product to produce, when and how to produce the product, or process a batch in manufacturing, or execute maintenance work with a predefined ordered set of operations. It also contains information about the material, labor, and equipment required at every operation step.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WorkOrderExtractPVO
Primary Keys : WorkOrderPEOWorkOrderId
Initial Extract Date : WorkOrderPEOCreationDate
Incremental Extract Date : WorkOrderPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| WorkOrderPEOActualCompletionDate | Actual finish date of the work order. This date occurs when the work order status changes to Completed. |
| WorkOrderPEOActualStartDate | Actual start date of the work order. |
| WorkOrderPEOAttributeCategory | Context name for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar1 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar10 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar11 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar12 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar13 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar14 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar15 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar16 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar17 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar18 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar19 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar2 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar20 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar3 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar4 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar5 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar6 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar7 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar8 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeChar9 | Character segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeDate1 | Date segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeDate2 | Date segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeDate3 | Date segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeDate4 | Date segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeDate5 | Date segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber1 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber10 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber2 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber3 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber4 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber5 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber6 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber7 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber8 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeNumber9 | Number segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeTimestamp1 | Date and Time segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeTimestamp2 | Date and Time segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeTimestamp3 | Date and Time segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeTimestamp4 | Date and Time segment for the Work Order descriptive flexfield. |
| WorkOrderPEOAttributeTimestamp5 | Date and Time segment for the Work Order descriptive flexfield. |
| WorkOrderPEOBackToBackFlag | Indicates whether the work order is created as a result of a back-to-back flow. |
| WorkOrderPEOCanceledDate | Date when the work order is canceled. |
| WorkOrderPEOCanceledReason | Reason for canceling the work order. |
| WorkOrderPEOClosedDate | Date when the work order is closed. |
| WorkOrderPEOCmPoHeaderId | Value that uniquely identifies the contract manufacturing purchase order header in the Work Order view object. |
| WorkOrderPEOCmPoLineId | Value that uniquely identifies the contract manufacturing purchase order line in the Work Order view object. |
| WorkOrderPEOCmPoLineLocId | Value that uniquely identifies the contract manufacturing purchase order line schedule in the Work Order view object. |
| WorkOrderPEOComplLocatorId | Value that uniquely identifies the locator used by default when the product is completed in the work order. |
| WorkOrderPEOComplSubinventoryCode | Completion subinventory used by default when the product is completed in the work order. |
| WorkOrderPEOCompletedQuantity | Primary product quantity completed so far in the work order. This is a summary column. |
| WorkOrderPEOContractMfgFlag | Indicates whether the work order is a contract manufacturing work order. |
| WorkOrderPEOCreatedBy | User who created the work order. |
| WorkOrderPEOCreationDate | Date when the user created the work order. |
| WorkOrderPEOFirmPlannedFlag | Indicates if the work order is firm. If the work order is firm, it's not considered by Planning to reschedule or replan. |
| WorkOrderPEOInterfaceSourceCode | Identifies the interface source code. This attribute is made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make sense only to them. Stakeholders include SCO and Planning. |
| WorkOrderPEOInventoryItemId | Value that uniquely identifies the item, product, or assembly in the inventory organization in the Work Order view object. |
| WorkOrderPEOItemRevision | Revision of the item that's in effect according to the work definition date of the work order. |
| WorkOrderPEOItemStructureName | Name of the item structure that the work definition on the work order references. |
| WorkOrderPEOItemVersion | This field is no longer used. |
| WorkOrderPEOJobDefinitionName | Indicates the name of the job that created or last updated the work order record. This is populated through Enterprise Service Scheduler. |
| WorkOrderPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the work order record. This is populated through Enterprise Service Scheduler. |
| WorkOrderPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WorkOrderPEOLastUpdateDate | Date and time when the user last updated the work order record. |
| WorkOrderPEOLastUpdateLogin | Session login associated with the user who last updated the work order record. |
| WorkOrderPEOLastUpdatedBy | User who last updated the work order record. |
| WorkOrderPEOMntAllowMultipleAssetsFlag | Indicates if the maintenance work order is created for multiple asset numbers. Contains one of the following values: Y or N. |
| WorkOrderPEOMntCompleteToInvFlag | Indicates if the maintenance work order completes the asset or item to inventory. Contains one of the following values: Y or N. |
| WorkOrderPEOMntIncludeInPlanningFlag | Indicates if the maintenance work order is considered for inventory planning. Contains one of the following values: Y or N. |
| WorkOrderPEOMntOutOfSequenceFlag | Indicates whether maintenance work order operations can be completed out of sequence during work execution. Contains one of the following values: Y or N. |
| WorkOrderPEOMntTransformToItemId | Value that uniquely identifies the target item that will be transformed using a maintenance work order for the repair to stock scenario. |
| WorkOrderPEONeedByDate | The date when the work order supply is expected to fulfill its demand. |
| WorkOrderPEONettableSupplyQtyOverride | Override quantity that the planning system uses as supply from the work order instead of the work order quantity. |
| WorkOrderPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| WorkOrderPEOOrchestrationCode | Identifies the orchestration code. This attribute is made available for integrating stakeholders to retain and persist a handle in the work orders schema to filter out events that make sense only to them. Stakeholders include SCO and Planning. |
| WorkOrderPEOOrderLessFlag | Indicates if the work order is created from an orderless transaction. |
| WorkOrderPEOOrganizationId | Value that uniquely identifies the manufacturing plant to which this work order belongs. |
| WorkOrderPEOOvercomplToleranceType | Tolerance type to report over completions for the work order. A list of accepted values is defined in the lookup type EGP_OVER_TOLTYPE. |
| WorkOrderPEOOvercomplToleranceValue | Percent or quantity to allow the reporting of the finished item to exceed the work order quantity. |
| WorkOrderPEOPjcBillableFlag | Indicates if a project-related item is available to be billed to customers. Valid values are Y or N. |
| WorkOrderPEOPjcCapitalizableFlag | Indicates if a project-related item is eligible for capitalization. Valid values are Y or N. |
| WorkOrderPEOPjcContextCategory | Context name of the Project Costing descriptive flexfield used for project-related standardized cost collection. |
| WorkOrderPEOPjcContractId | Value that uniquely identifies the contract number associated to the work order. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| WorkOrderPEOPjcContractLineId | Value that uniquely identifies the contract line number associated to the work order. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| WorkOrderPEOPjcExpenditureItemDate | Date on which a project-related transaction is incurred. |
| WorkOrderPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
| WorkOrderPEOPjcFundingAllocationId | Value that uniquely identifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| WorkOrderPEOPjcOrganizationId | Value that uniquely identifies the expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
| WorkOrderPEOPjcProjectId | Value that uniquely identifies the project associated to the work order used to build the transaction descriptive flexfield for project-related transaction distributions. |
| WorkOrderPEOPjcProjectNumber | The number that identifies the project associated to the work order used to build the transaction descriptive flexfield for project-related transaction distributions. |
| WorkOrderPEOPjcReservedAttribute1 | Name of the funding source associated to the project. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| WorkOrderPEOPjcReservedAttribute10 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute2 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute3 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute4 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute5 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute6 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute7 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute8 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcReservedAttribute9 | Attribute reserved for future project-related functionality. |
| WorkOrderPEOPjcTaskId | Value that uniquely identifies the task associated to the work order used to build the transaction descriptive flexfield for project-related transaction distributions. |
| WorkOrderPEOPjcTaskNumber | The number that identifies the task associated to the work order used to build the transaction descriptive flexfield for project-related transaction distributions. Task is a subdivision of project work. |
| WorkOrderPEOPjcUserDefAttribute1 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute10 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute2 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute3 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute4 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute5 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute6 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute7 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute8 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcUserDefAttribute9 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| WorkOrderPEOPjcWorkTypeId | Value that uniquely identifies the project-related classification of the work performed. |
| WorkOrderPEOPlannedCompletionDate | Scheduled date and time when the work order is expected to complete. |
| WorkOrderPEOPlannedStartDate | Scheduled date and time when the work order is expected to start. |
| WorkOrderPEOPlannedStartQuantity | Planned production quantity for a discrete work order. It represents the batch quantity for a process work order. |
| WorkOrderPEOPreassignLotFlag | Indicates that the lot numbers for primary product and outputs can be preassigned in the work order. |
| WorkOrderPEOPrimaryProductQuantity | Planned production quantity for the primary product of a process work order. |
| WorkOrderPEOPrimaryProductUomCode | Unit of measure of the primary product of a process work order. |
| WorkOrderPEORejectedQuantity | Total rejected quantity across all operations for the work order. |
| WorkOrderPEOReleasedDate | Date when the work order is released. |
| WorkOrderPEORequestId | Indicates the request ID of the job that created or last updated work order record. This is populated through Enterprise Service Scheduler. |
| WorkOrderPEOResequenceFlag | Indicates if the work order has resequence enabled operations. |
| WorkOrderPEOSchedulingMethod | Scheduling method that the application uses to schedule the work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_SCHEDULING_METHOD. |
| WorkOrderPEOScoSupplyOrderId | Value that uniquely identifies the supply order of the orchestration module of the supply chain in the Work Order view object. |
| WorkOrderPEOScrappedQuantity | Total scrapped quantity across all operations for the work order. |
| WorkOrderPEOSerialTrackingFlag | Indicates that the item produced in the work order is tracked by serial numbers during work execution. This setting is inherited from the work definition. If this is enabled, one of more operations in the work order can be enabled for serialization. |
| WorkOrderPEOSourceHeaderRef | Reference to the work order header in the source system. |
| WorkOrderPEOSourceHeaderRefId | Value that uniquely identifies the work order header in the source system. |
| WorkOrderPEOSourceLineRef | Reference to the work order line in the source system. |
| WorkOrderPEOSourceLineRefId | Value that uniquely identifies the work order line in the source system. |
| WorkOrderPEOSourceSystemId | Value that uniquely identifies the source system in the Work Order view object. |
| WorkOrderPEOSourceSystemType | Indicates the type of source system, internal or external, from which work order was imported. A list of accepted values is defined in the lookup type ORA_WIE_SOURCE_SYSTEM_TYPE. |
| WorkOrderPEOStatusChangeReason | The reason which is a free format capture of why the status is changed. |
| WorkOrderPEOSupplyType | Default supply type to use for the work order components. |
| WorkOrderPEOTransformFromItemId | Value that identifies the item from which the work order item is being transformed to. |
| WorkOrderPEOUnderCompletedFlag | Indicates if the work order has been undercompleted based on the undercompletion tolerance type and value. |
| WorkOrderPEOUndercomplToleranceType | Value that identifies the tolerance type to report undercompletion for the work order. A list of accepted values is defined in the lookup type ORA_EGP_UNDER_COMP_TOL. |
| WorkOrderPEOUndercomplToleranceValue | Value that identifies the percentage or quantity to allow the reporting of the finished item below the work order quantity. |
| WorkOrderPEOUomCode | Identifies the unit of measure of the quantity of the work order. |
| WorkOrderPEOWorkDefinitionAsOfDate | Work definition as of date used in the work order to determine the work definition version. |
| WorkOrderPEOWorkDefinitionId | Value that uniquely identifies the work definition in the Work Order view object. This is a foreign key to the Work Definition view object. |
| WorkOrderPEOWorkDefinitionVersionId | Value that uniquely identifies the work definition version in the Work Order view object. This is a foreign key to the Work Definition Version view object. |
| WorkOrderPEOWorkMethodId | Value that uniquely identifies the work method in the Work Order view object. This is a foreign key to the Work Method view object. |
| WorkOrderPEOWorkOrderId | Value that uniquely identifies the work order. This is the primary key of the Work Order view object. |
| WorkOrderPEOWorkOrderNumber | Number that uniquely identifies the work order within the manufacturing organization. The user can manually assign the number when the user creates the work order, or can allow the application to create a unique number from the numbering scheme defined in plant parameters. |
| WorkOrderPEOWorkOrderPriority | Priority of the work order. |
| WorkOrderPEOWorkOrderStatusId | Value that uniquely identifies the work order status in the Work Order view object. This is a foreign key to the Work Order Status view object. |
| WorkOrderPEOWorkOrderSubType | Indicates the subtype of the work order. A subtype can be used to derive appropriate costing accounts for the work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_SUB_TYPE if this work order is a manufacturing work order. If this is a maintenance work order, a list of accepted values is defined in the lookup type ORA_MNT_WO_SUB_TYPE. |
| WorkOrderPEOWorkOrderType | Indicates the type of this work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_TYPE if this work order is a manufacturing work order. If this is a maintenance work order, a list of accepted values is defined in the lookup type ORA_MNT_WO_TYPE. |
| WorkOrderTLPEOCreatedBy | User who created the work order record. |
| WorkOrderTLPEOCreationDate | Date and time when the user created the work order record. |
| WorkOrderTLPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WorkOrderTLPEOLastUpdateDate | Date and time when the user last updated the work order record. |
| WorkOrderTLPEOLastUpdateLogin | Session login associated with the user who last updated the work order record. |
| WorkOrderTLPEOLastUpdatedBy | User who last updated the work order record. |
| WorkOrderTLPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| WorkOrderTLPEOSourceLang | Code of the language in which the contents of the translatable columns were originally created. |
| WorkOrderTLPEOWorkOrderDescription | Description of the work order. |
| WorkOrderTLPEOWorkOrderId | Value that uniquely identifies the work order. This is the primary key of the Work Order view object. |