Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount

The Exceptions for Operation Materials resource gets the count of exceptions that occurred for material during the operation.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkorderoperationmaterialWorkOrderOperationMaterialId [KEY] Long WorkorderoperationmaterialWorkOrderOperationMaterialId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrderMaterialExceptionCount Long WorkOrderMaterialExceptionCount of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrderOperationMaterialId [KEY] Long WorkOrderOperationMaterialId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
DueDays Int DueDays of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
Finder String Finder of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
ResourceId Long ResourceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
Tolerance Int Tolerance of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount

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