Cmdlets for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkorderoperationresourceWorkOrderOperationResourceId [KEY] Long WorkorderoperationresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderOperationResourceInstanceId [KEY] Long Value that uniquely identifies the resource instance of a work order operation resource. It is a primary key that the application generates when it creates the resource instance for the work order operation resource.
WorkOrderOperationResourceId Long Value that uniquely identifies the resource of a work order operation. It is a primary key that the application generates when it creates the resource for the work order operation.
WorkOrderOperationId Long WorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
LaborInstanceId Long Value that uniquely identifies the labor resource instance. It is a primary key that the application generates when it creates a labor instance.
LaborInstanceCode String Abbreviation that identifies the labor resource instance.
LaborInstanceName String LaborInstanceName of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
EquipmentInstanceId Long Value that uniquely identifies the equipment resource instance. It is a primary key that the application generates when it creates a equipment instance.
EquipmentInstanceCode String Abbreviation that identifies the equipment resource instance.
EquipmentInstanceName String EquipmentInstanceName of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ChargedQuantity Double ChargedQuantity of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
ResourceType String ResourceType of WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WOOperationResourceInstanceDFF String WOOperationResourceInstanceDFF

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
BackToBackFlag String BackToBackFlag
ContractMfgFlag String ContractMfgFlag
DueDays Int DueDays
FirmPlannedFlag String FirmPlannedFlag
InventoryItemId Long InventoryItemId
ItemNumber String ItemNumber
LastUpdateDate Datetime LastUpdateDate
MaterialItemId Long MaterialItemId
PlannedCompletionDate Datetime PlannedCompletionDate
PlannedStartDate Datetime PlannedStartDate
ProductSerialId Long ProductSerialId
ResourceId Long ResourceId
SerialNumber String SerialNumber
SourceHeaderRefId Long SourceHeaderRefId
SourceHeaderReferenceId Long SourceHeaderReferenceId
SourceLineRefId Long SourceLineRefId
SourceLineReferenceId Long SourceLineReferenceId
SourceSystemId Long SourceSystemId
Tolerance Int Tolerance
WoProjectNumber String WoProjectNumber
WoTaskNumber String WoTaskNumber
WorkAreaId Long WorkAreaId
WorkCenterId Long WorkCenterId
WorkOrderNumber String WorkOrderNumber
WorkOrderStatusId Long WorkOrderStatusId
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839