JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ShoppingCatalogItemDetailsitemGTINRelationships

The Item GTIN Relationships resource gets the global trade item number (GTIN) details for the master item.

Columns

Name Type Description
ShoppingCatalogItemDetailsSearchObjectId [KEY] Long Value that uniquely identifies the search object referenced by the catalog item.
GTIN String Value that uniquely identifies the global trade item number (GTIN) of the master item.
PartyType String Type of party of the global trade item number (GTIN). Values can be blank, a supplier, or a manufacturer.
UOM String Abbreviation that identifies the unit of measure for which the global trade item number (GTIN) is defined.
Finder String Finder criteria used to filter shopping catalog item details item GTIN relationships based on specific search parameters and conditions.
GuidedBuyingEnabledFlag String A finder used to filter data using Finder column. Contains one of the following values: true or false. If true, then it returns the master item document for an item that's on a blanket purchase agreement. If false, then it doesn't return the master item document for an item that's on blanket purchase agreement. This is used for the feature Procure Goods from Preferred Sources During Catalog Shopping.
IgnoreAgreementFlag String A finder used to filter data using Finder column. Contains one of the following values: Y or N. If Y, then the application ignores the agreement on the requisition line and retrieves the master item information in the destination organization from Oracle Product Information Management. If N, then it returns the information from the agreement line present on the requisition line.
RequisitionLineId Long A finder used to filter data using Finder column. Value that uniquely identifies the requisition line for which the information is queried.
SearchObjectId Long A finder used to filter data using Finder column. Value that uniquely identifies the search object referenced by the catalog item.
UserPreferenceId Long A finder used to filter data using Finder column. Value that uniquely identifies the user preference referenced by the catalog item.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434