JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ProductionResourcesResourceDFF

ProductionResourcesResourceDFF

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long ProductionResourcesResourceId of ProductionResourcesResourceDFF
ResourceId [KEY] Long Value that uniquely identifies the production resource. You can use a flexfield with this production resource. A flexfield is a flexible data field that your organization can use to modify your implementation without having to write programming code.
_FLEX_Context String Descriptive flexfield context name for resources.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for resources.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AssetItemId Long AssetItemId
AssetItemNumber String AssetItemNumber
AssetNumber String AssetNumber
ChangedDate Date ChangedDate
EquipmentIdentifier String EquipmentIdentifier
EquipmentInstanceId Long EquipmentInstanceId
FirstName String FirstName
LaborIdentifier String LaborIdentifier
LaborInstanceId Long LaborInstanceId
LastName String LastName
MiddleName String MiddleName
OrganizationId Long OrganizationId
PartyId Long PartyId
PersonName String PersonName
PersonType String PersonType
PrimaryWorkCenterCode String PrimaryWorkCenterCode
PrimaryWorkCenterId Long PrimaryWorkCenterId
ResourceType String ResourceType
Finder String finder

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