ShoppingCatalogItemDetailsbuyingOptions
The Buying Options resource gets the different buying options when an item is referenced by multiple agreements.
Table-Specific Information
Select
The driver uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The driver processes other filters within the driver.
For example, the following query is processed server-side:
SELECT * FROM Procurement.ShoppingCatalogItemDetailsbuyingOptions WHERE Finder = 'PrimaryKey' AND SearchObjectId = 135483;
Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.
The ShoppingCatalogItemDetailsbuyingOptions view supports the
- 'FindById' finder. The fields which can be used along with it are
- GuidedBuyingEnabledFlag
- SearchObjectId
- UserPreferenceId
- 'FindByRequisitionLineId' finder. The fields which can be used along with it are
- IgnoreAgreementFlag
- RequisitionLineId
- 'PrimaryKey' finder. The fields which can be used along with it are
- SearchObjectId
Columns
| Name | Type | Description |
| ShoppingCatalogItemDetailsSearchObjectId [KEY] | Long | Value that uniquely identifies the search object referenced by the catalog item. |
| SearchObjectId [KEY] | Long | Value that uniquely identifies the goods and services that are bought. |
| SourceDocumentHeaderId | Long | Value that uniquely identifies the agreement header. |
| SourceDocumentLineId | Long | Value that uniquely identifies the agreement line. |
| SourceDocumentHeaderNumber | String | Number that identifies the agreement on which the item is available. |
| LineType | String | Type of agreement line. Valid values are Goods or Services. |
| ItemNumber | String | Name of the master item. |
| ShortDescription | String | Description of the item. |
| LongDescription | String | Long description of the item. |
| Amount | Decimal | Amount of the service items in the currency of the buying company. |
| UnitPrice | Decimal | Price of the item in the currency of the buying company. |
| CurrencyCode | String | Abbreviation that identifies the item currency. |
| CategoryName | String | Name of the category that classifies the agreement line. |
| ImageURL | String | URL (Uniform Resource Locator) of the image of the agreement line. |
| PackagingString | String | Unit of measure of the packaged supply items. |
| Manufacturer | String | Name of the party who manufactures the item. |
| ManufacturerPartNumber | String | Number issued by the manufacturer that uniquely identifies the individual product. |
| SupplierName | String | Name of the supplier of the agreement line. |
| SupplierItem | String | Number that identifies the supplier item. |
| SupplierItemAuxiliaryId | String | Value that uniquely identifies the supplier item auxiliary. |
| UOMCode | String | Abbreviation that identifies the unit of measure. |
| UNSPSC | String | Value that uniquely identifies the goods and services that are bought. |
| Comments | String | Comments on the agreement line. |
| Finder | String | Finder criteria used to filter shopping catalog item details item buying options 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. |
| UserPreferenceId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the user preference referenced by the catalog item. |