JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData JDBC Driver for Oracle Fusion Cloud SCM ビュー

Name Description
DispatchListWorkOrderOperations DispatchListWorkOrderOperations
DispatchListWorkOrderOperationsWorkOrderOperationProductSerial DispatchListWorkOrderOperationsWorkOrderOperationProductSerial
FlexFndDffDescriptiveFlexfieldContexts FlexFndDffDescriptiveFlexfieldContexts
FlexFndPvsCharacterIdCharacterValues FlexFndPvsCharacterIdCharacterValues
FlexFndPvsCharacterValues FlexFndPvsCharacterValues
FlexFndPvsNumberIdCharacterValues FlexFndPvsNumberIdCharacterValues
OperationStartStops OperationStartStops
ProductionResources ProductionResources
ProductionResourcesEquipmentInstance ProductionResourcesEquipmentInstance
ProductionResourcesEquipmentInstanceEquipmentInstanceDFF ProductionResourcesEquipmentInstanceEquipmentInstanceDFF
ProductionResourcesLaborInstance ProductionResourcesLaborInstance
ProductionResourcesLaborInstanceLaborInstanceDFF ProductionResourcesLaborInstanceLaborInstanceDFF
ProductionResourcesResourceDFF ProductionResourcesResourceDFF
StandardLookupsLOV StandardLookupsLOV
WorkAreas WorkAreas
WorkAreasWorkAreaDFF WorkAreasWorkAreaDFF
WorkCenters WorkCenters
WorkCentersWorkCenterDFF WorkCentersWorkCenterDFF
WorkCentersWorkCenterResource WorkCentersWorkCenterResource
WorkCentersWorkCenterResourceWorkCenterResourceShift WorkCentersWorkCenterResourceWorkCenterResourceShift
WorkCentersWorkCenterSubinventory WorkCentersWorkCenterSubinventory
WorkDefinitionNames WorkDefinitionNames
WorkDefinitionNamestranslations WorkDefinitionNamestranslations
WorkOrders WorkOrders
WorkOrdersMetrics WorkOrdersMetrics
WorkOrdersProjectDetailsDFF WorkOrdersProjectDetailsDFF
WorkOrderStatuses WorkOrderStatuses
WorkOrdersWorkOrderActiveOperation WorkOrdersWorkOrderActiveOperation
WorkOrdersWorkOrderAssemblyComponent WorkOrdersWorkOrderAssemblyComponent
WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkOrdersWorkOrderAttachment WorkOrdersWorkOrderAttachment
WorkOrdersWorkOrderDFF WorkOrdersWorkOrderDFF
WorkOrdersWorkOrderExceptionCount WorkOrdersWorkOrderExceptionCount
WorkOrdersWorkOrderLotNumber WorkOrdersWorkOrderLotNumber
WorkOrdersWorkOrderMaterial WorkOrdersWorkOrderMaterial
WorkOrdersWorkOrderMaterialWorkOrderMaterialExceptionCount WorkOrdersWorkOrderMaterialWorkOrderMaterialExceptionCount
WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialAttachment WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialAttachment
WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF
WorkOrdersWorkOrderOperation WorkOrdersWorkOrderOperation
WorkOrdersWorkOrderOperationWorkOrderOperationAttachment WorkOrdersWorkOrderOperationWorkOrderOperationAttachment
WorkOrdersWorkOrderOperationWorkOrderOperationDFF WorkOrdersWorkOrderOperationWorkOrderOperationDFF
WorkOrdersWorkOrderOperationWorkOrderOperationExceptionCount WorkOrdersWorkOrderOperationWorkOrderOperationExceptionCount
WorkOrdersWorkOrderOperationWorkOrderOperationMaterial WorkOrdersWorkOrderOperationWorkOrderOperationMaterial
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderMaterialExceptionCount
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialAttachment WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialAttachment
WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF WorkOrdersWorkOrderOperationWorkOrderOperationMaterialWorkOrderOperationMaterialDFF
WorkOrdersWorkOrderOperationWorkOrderOperationResource WorkOrdersWorkOrderOperationWorkOrderOperationResource
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceAttachment WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceAttachment
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceInstance
WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderResourceExceptionCount
WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkOrdersWorkOrderReservation WorkOrdersWorkOrderReservation
WorkOrdersWorkOrderResource WorkOrdersWorkOrderResource
WorkOrdersWorkOrderResourceWorkOrderOperationResourceAttachment WorkOrdersWorkOrderResourceWorkOrderOperationResourceAttachment
WorkOrdersWorkOrderResourceWorkOrderOperationResourceDFF WorkOrdersWorkOrderResourceWorkOrderOperationResourceDFF
WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstanceWOOperationResourceInstanceDFF WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstanceWOOperationResourceInstanceDFF
WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount
WorkOrdersWorkOrderSerialNumber WorkOrdersWorkOrderSerialNumber
WorkOrdersWorkOrderStatus WorkOrdersWorkOrderStatus
WorkOrdersWorkOrderStatusHistory WorkOrdersWorkOrderStatusHistory

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