JDBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ShoppingCatalogItemDetailsitemRevisions

A revision represents a particular version of an item.

Columns

Name Type Description
ShoppingCatalogItemDetailsSearchObjectId [KEY] Long Value that uniquely identifies the search object referenced by the catalog item.
Revision String Revision of the master item.
Finder String Finder criteria used to filter shopping catalog item details item revisions 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