Request Work Orders
The Supply Request Work Order Details Extract view object extracts details from the work order for the supply request.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyRequestWorkOrderDtlsExtractPVO
Primary Keys : DosWorkOrderDetailsIntPEOWorkorderDetailsIntfId
Initial Extract Date : DosWorkOrderDetailsIntPEOCreationDate
Incremental Extract Date : DosWorkOrderDetailsIntPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosWorkOrderDetailsIntPEOActionCode | Abbreviation that identifies the action that the manufacturing system should perform on the work order. For example, REPLACE. The requesting application sends this value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOAlternateNumber | Number that identifies the resource to use as an alternative to the primary resource. |
| DosWorkOrderDetailsIntPEOAppliedResourceUnits | Resource units to apply to the work order. |
| DosWorkOrderDetailsIntPEOAppliedResourceValue | Resource value to apply to the work order. |
| DosWorkOrderDetailsIntPEOAssignedUnits | Units assigned for the work order. |
| DosWorkOrderDetailsIntPEOBackflushFlag | This attribute contains 1 or 0. 1 means to backflush the work order. 0 means to not backflush. No value means 0. 0 is the default value. |
| DosWorkOrderDetailsIntPEOCompChargeAccntId | Value that uniquely identifies the charge account for a component in the work order. |
| DosWorkOrderDetailsIntPEOCompDateRequired | Date that fulfillment needs the component to finish the work order. |
| DosWorkOrderDetailsIntPEOCompItemIdNew | Value that uniquely identifies the new requirement for the component in the work order. |
| DosWorkOrderDetailsIntPEOCompItemIdOld | Value that uniquely identifies the old requirement for the component in the work order. Use this value only when you have a substitute component. |
| DosWorkOrderDetailsIntPEOCompItemNameNew | Name of the new component in the work order. |
| DosWorkOrderDetailsIntPEOCompItemNameOld | Name of the old component in the work order. |
| DosWorkOrderDetailsIntPEOCompItemRevision | Revision to use for the component in the work order. |
| DosWorkOrderDetailsIntPEOCompMrpNetFlag | This attribute contains 1 or 0. 1 means the component is MRP nettable. 0 means it isn't. No value means 0. 0 is the default value. |
| DosWorkOrderDetailsIntPEOCompQuantityIssued | Quantity already issued for the component in the work order. |
| DosWorkOrderDetailsIntPEOCompQuantityPerAssembly | Quantity that the work order needs for the component for each assembly. |
| DosWorkOrderDetailsIntPEOCompRequiredQuantity | Quantity that the work order needs for the component. |
| DosWorkOrderDetailsIntPEOCompRequiredQuantityUom | Unit of measure of the quantity that the work order needs for the component. |
| DosWorkOrderDetailsIntPEOCompSupplyLocatorId | Value that uniquely identifies the supply locator for the component. |
| DosWorkOrderDetailsIntPEOCompSupplyLocatorName | Name of the supply locator for the component. |
| DosWorkOrderDetailsIntPEOCompSupplySubInventory | Name of the subinventory that the work order uses to supply parts for the component. |
| DosWorkOrderDetailsIntPEOCountPointType | Type of the count point for the operation. |
| DosWorkOrderDetailsIntPEOCreatedBy | Name of the user who created the required details for the work order. |
| DosWorkOrderDetailsIntPEOCreationDate | Date and time when the user created the required details for the work order. |
| DosWorkOrderDetailsIntPEODetailType | Type of the required details for the work order. |
| DosWorkOrderDetailsIntPEOHeaderInterfaceId | Value that uniquely identifies the header of the required details for the work order. |
| DosWorkOrderDetailsIntPEOInterfaceBatchNumber | Number that identifies the batch of supply requests that the supply request sends to Oracle Supply Chain Orchestration Cloud to create supply. The batch consists of one or more supply requests. |
| DosWorkOrderDetailsIntPEOInterfaceStatusCode | Abbreviation that identifies the status of the required work order details. For example, Ready. The requesting application sends the status to the manufacturing application. |
| DosWorkOrderDetailsIntPEOJobDefinitionName | Name of the job that Enterprise Service Scheduler used to create or most recently update the required work order details. |
| DosWorkOrderDetailsIntPEOJobDefinitionPackage | Name of the package that Enterprise Service Scheduler used to create or most recently update the required work order details. |
| DosWorkOrderDetailsIntPEOLastUpdateDate | Date and time when the user most recently updated the requirements for the work order details. |
| DosWorkOrderDetailsIntPEOLastUpdateLogin | Login that the user used when updating the requirements for the work order details. |
| DosWorkOrderDetailsIntPEOLastUpdatedBy | User who most recently updated the requirements for the work order details. |
| DosWorkOrderDetailsIntPEOLineInterfaceId | Value that uniquely identifies flexfields that you use for the transfer order line on a supply request line. |
| DosWorkOrderDetailsIntPEOLoadType | Type of data that the work order detail contains. For example, RESOURCE or MATERIAL. The requesting application sends the value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOMaterialQtyPerProduct | Quantity of the original component for the item or assembly. The requesting application sends the value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOMaterialSeqNumber | Number that identifies the sequence to use when consuming material for an operation. The requesting application sends the value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOMinTransferQuantity | Minimum quantity to transfer for the operation. |
| DosWorkOrderDetailsIntPEOMinTransferQuantityUom | Unit of measure of the minimum quantity to transfer for the operation. |
| DosWorkOrderDetailsIntPEOMpsDateRequired | Date when MPS Relief (Master Production Schedule) needs fulfillment to do the operation. |
| DosWorkOrderDetailsIntPEOMpsRequiredQuantity | Quantity that MPS Relief (Master Production Schedule) needs the operation to fulfill. |
| DosWorkOrderDetailsIntPEOMpsRequiredQuantityUom | Unit of measure of the quantity that MPS Relief (Master Production Schedule) needs the operation to fulfill. |
| DosWorkOrderDetailsIntPEOObjectVersionNumber | Version of the work order details. This attribute makes sure no more than one user modifies the same object at the same time. The database increments the version every time it updates the row, then compares the version at the start and at the end of each transaction to determine whether another user updated the row during the current session. |
| DosWorkOrderDetailsIntPEOOperationSequenceId | Value that uniquely identifies the sequence to use for the operation. |
| DosWorkOrderDetailsIntPEOOperationSequenceNumber | Number that identifies the sequence to use for the operation. You can use it for a component or for a resource. |
| DosWorkOrderDetailsIntPEORequestId | Value that uniquely identifies the request that Enterprise Service Scheduler used to create or most recently update the requested work order details. |
| DosWorkOrderDetailsIntPEOResourceActivityId | Value that uniquely identifies the resource that fulfillment uses to cost the request according to activity. |
| DosWorkOrderDetailsIntPEOResourceAutoChargeType | Type of charge to use when creating a charge for the resource. |
| DosWorkOrderDetailsIntPEOResourceBasisType | Type of resource basis to use for the operation. The type can be for each item or for a lot. |
| DosWorkOrderDetailsIntPEOResourceCompletionDate | Date when the resource completed the operation. |
| DosWorkOrderDetailsIntPEOResourceDepartmentId | Value that uniquely identifies the department that manages the resource. |
| DosWorkOrderDetailsIntPEOResourceIdNew | Value that uniquely identifies the new resource to use when adding or changing the required work order details. |
| DosWorkOrderDetailsIntPEOResourceIdOld | Value that uniquely identifies the old resource to use when adding or changing the required work order details. |
| DosWorkOrderDetailsIntPEOResourceLoadType | Type of load. The value 1 means to load a resource. 2 means to load a component. 3 means to load an operation. 5 means to change between the primary and an alternative resource. |
| DosWorkOrderDetailsIntPEOResourceNameNew | Name of the new resource that the work order will use to perform the operation. |
| DosWorkOrderDetailsIntPEOResourceNameOld | Name of the old resource that the work order used to perform the operation. |
| DosWorkOrderDetailsIntPEOResourceSequenceNumber | Number of the sequence that the resource uses to perform the operation. |
| DosWorkOrderDetailsIntPEOResourceStartDate | Date to start the activity in the resource that performs the operation. |
| DosWorkOrderDetailsIntPEOResourceUomCode | Abbreviation that identifies the unit of measure to use in the resource for the amount. |
| DosWorkOrderDetailsIntPEOResourceUsageRateOrAmount | Rate or amount that the resource needs to perform the operation. |
| DosWorkOrderDetailsIntPEOResoureDepartmentName | Name of the department that manages the resource. |
| DosWorkOrderDetailsIntPEOScheduledFlag | This attribute contains 1 or 0. 1 means details for the work order are scheduled. 0 means they aren't. No value means 0. 0 is the default value. |
| DosWorkOrderDetailsIntPEOSourceCode | Abbreviation that identifies the source that created the required work order details. |
| DosWorkOrderDetailsIntPEOStandardOperationId | Value that uniquely identifies the standard operation that creates the required work order details. |
| DosWorkOrderDetailsIntPEOStandardOperationName | Name of the standard operation in the work order. |
| DosWorkOrderDetailsIntPEOStandardRateFlag | This attribute contains 1 or 0. 1 means to use the standard rate. 0 means don't use it. No value means 0. 0 is the default value. |
| DosWorkOrderDetailsIntPEOSubstituteQtyPerProduct | Substitute quantity for the item according to the material or assembly. The requesting application sends the value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOSubstitutionType | Type of substitution. The value 1 means to to delete. 2 means to add. 3 means to change. |
| DosWorkOrderDetailsIntPEOWdOpAltResourceId | Value that uniquely identifies an alternative operation to use for the work order. The requesting application sends the value to the manufacturing application. |
| DosWorkOrderDetailsIntPEOWipEntityId | Value that uniquely identifies the entity to use for work in process. |
| DosWorkOrderDetailsIntPEOWipSupplyType | Type of supply to use to fulfill for the required work details. |
| DosWorkOrderDetailsIntPEOWoProcessPhase | Phase the process to use for work-in-process. This attribute contains a value of 2 for validation. |
| DosWorkOrderDetailsIntPEOWoProcessStatus | Status of the process that's processing work-in-process. This attribute contains a value of 1 for Pending. |
| DosWorkOrderDetailsIntPEOWorkorderDetailsIntfId | Value that uniquely identifies the interface record for the required work order details. |