JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequestssupplyRequestLinessupplyRequestLinesXferDFF

SupplyRequestssupplyRequestLinessupplyRequestLinesXferDFF

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyRequestLinessupplyRequestLinesXferDFF
LineInterfaceId [KEY] Long Value that uniquely identifies the flexfields that are tied to the transfer order line on supply request lines.
Discriminator String This is a transient attribute. The value of this attribute is always null. Ignore this attribute.
_FLEX_Context String Descriptive flexfield context name of the transfer order line on supply request lines.
_FLEX_Context_DisplayValue String Descriptive flexfield context name display value of the transfer order line on supply request lines.

Pseudo-Columns

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

Name Type Description
SupplyOrderReferenceNumber String SupplyOrderReferenceNumber
BindDestOrganizationCode String bindDestOrganizationCode
BindDocumentNumber String bindDocumentNumber
BindItemNumber String bindItemNumber
BindNeedByDate Datetime bindNeedByDate
BindSupplyOrderNumber String bindSupplyOrderNumber
BindSupplyOrderReferenceNumber String bindSupplyOrderReferenceNumber
BindSupplyOrderSource String bindSupplyOrderSource
BindSupplyRequestDate Datetime bindSupplyRequestDate
BindSupplyStatus String bindSupplyStatus
BindSupplyType String bindSupplyType
Finder String finder

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