Work Definition Operation
The Work Definition Operation view object contains information about the operation steps defined in a work definition to produce a product, or process a batch in manufacturing, or execute a maintenance work.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationExtractPVO
Primary Keys : WDOperationTranslationPEOLanguage, WDOperationTranslationPEOWdOperationId, WdOperationId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActionStatusCode | Code that represents the last action performed on the work definition operation which caused it to trigger the approvals workflow. Valid values are CREATE and DELETE. An empty or a null value indicates this record was reviewed and approved. |
| ApplicabilityRuleId | Value that uniquely identifies the criteria to include an option dependent operation in the configured item work order. This applies to an ATO Model work definition only. |
| AttributeCategory | Context name for the Work Definition Operation descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Definition Operation descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Definition Operation descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Definition Operation descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Definition Operation descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Definition Operation descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Definition Operation descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Work Definition Operation descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Work Definition Operation descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Work Definition Operation descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Work Definition Operation descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Work Definition Operation descriptive flexfield. |
| AutoTransactFlag | Indicates whether the operation is automatically reported and its resources and materials are automatically charged based on the Supply Type or the Charge Type setups upon completion of the next count point operation. |
| CountPointFlag | Indicates if this is a count point operation. If an operation is a count point operation, then operation completion needs to be explicitly reported at the operation. |
| CreatedBy | User who created the work definition operation record. |
| CreationDate | Date when the work definition operation record was created. |
| EffectiveFromDate | Date and time from when this work definition operation is effective. |
| EffectiveToDate | Date and time from when this work definition operation is no longer effective. |
| FixedLeadTime | Lead time to perform this supplier operation, independent of the quantity of the outside processing item. |
| Language | Code of the language into which the contents of the translatable columns are translated. |
| LastUpdateDate | Date and time when the user last updated the work definition operation record. |
| LastUpdateLogin | Session login associated with the user who last updated the work definition operation record. |
| LastUpdatedBy | User who last updated the work definition operation record. |
| LeadTimeUom | Unit of measure for the fixed and variable lead time values of the supplier operation. |
| ObjectVersionNumber | 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. |
| OperationSeqNumber | Sequence in which the operation is executed. |
| OperationType | Value that represents the type of the operation. A list of accepted values is defined in the lookup type ORA_WIS_OPERATION_TYPE. |
| OptionDependentFlag | Indicates whether the operation is dependent on the choice of one or multiple optional components. This applies to an assemble top order model work definition only. |
| OspItemId | Value that uniquely identifies the outside processing item of a supplier operation in the in the Work Definition Operation view object. |
| PlanningPercent | Offset of a given operation as a percentage of the manufacturing lead time considering all operations of the work definition. These lead time percent values are used to calculate cumulative lead times. |
| ReferencedFlag | Indicates if a standard operation is referenced in the work definition operation. |
| ResequenceFlag | Indicates if the operation can be resequenced during work execution. |
| SerialTrackingFlag | Indicates if the operation is a serialization operation. It's applicable only if the work definition item is set up as serial-tracked. Serialization is applicable to only discrete work definitions. |
| ShippingDocumentsFlag | Indicates whether shipping documents need to be generated for the supplier operation for outside processing. |
| StandardOperationId | Value that uniquely identifies the standard operation. This is a foreign key to the Standard Operation view object. |
| SupplierId | Value that uniquely identifies the suggested supplier of the supplier operation in the Work Definition Operation view object. This is a foreign key to the Supplier object. |
| SupplierSiteId | Value that uniquely identifies the suggested supplier site of the supplier operation in the Work Definition Operation view object. This is a foreign key to the Supplier Site object. |
| VariableLeadTime | Lead time to perform this supplier operation for each unit of the outside processing item. |
| WDOperationPEOYieldFactor | Indicates the yield factor of an operation that represents the percentage of the starting quantity that's yielded on completion of the operation. |
| WDOperationTranslationPEOCreatedBy | User who created the work definition operation record. |
| WDOperationTranslationPEOCreationDate | Date when the work definition operation record was created. |
| WDOperationTranslationPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WDOperationTranslationPEOLastUpdateDate | Date and time when the user last updated the work definition operation record. |
| WDOperationTranslationPEOLastUpdateLogin | Session login associated with the user who last updated the work definition operation record. |
| WDOperationTranslationPEOLastUpdatedBy | User who last updated the work definition operation record. |
| WDOperationTranslationPEOObjectVersionNumber | 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. |
| WDOperationTranslationPEOOperationDescription | Description of the work definition operation. |
| WDOperationTranslationPEOOperationName | Name of the work definition operation. |
| WDOperationTranslationPEOSourceLang | Code of the language in which the contents of the translatable columns were originally created. |
| WDOperationTranslationPEOWdOperationId | Value that uniquely identifies the work definition operation. This is the primary key of the Work Definition Operation view object. |
| WdOperationId | Value that uniquely identifies the work definition operation. This is the primary key of the Work Definition Operation view object. |
| WorkCenterId | Value that uniquely identifies the work center in the Work Definition Operation view object. This is a foreign key to the Work Center view object. |
| WorkDefinitionId | Value that uniquely identifies the work definition in the Work Definition Operation view object. This is a foreign key to the Work Definition view object. |