ShoppingCatalogItemDetails
The Shopping Catalog Item Details resource gets the product details of any item, which helps the requester to check the details before procuring the item.
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.ShoppingCatalogItemDetails WHERE Finder = 'PrimaryKey' AND SearchObjectId = 14938;
Due to the limitations of the Oracle Fusion Cloud Financials API, querying this view requires the use of Finders.
The ShoppingCatalogItemDetails 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 |
| SearchObjectId [KEY] | Long | Value that uniquely identifies the search object referenced by the catalog item. |
| SourceDocumentHeaderId | Long | Value that uniquely identifies the agreement header. |
| SourceDocumentLineId | Long | Value that uniquely identifies the agreement line. |
| CreatedBy | String | User who created the item details. |
| CreationDate | Datetime | Date on which the user created the item details. |
| LastUpdatedBy | String | User who last updated the item details. |
| LastUpdateDate | Datetime | Date on which the user last updated the item details. |
| 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 or any user-defined line type. |
| OrderTypeLookupCode | String | Abbreviation that identifies the type of agreement line. Valid values are QUANTITY Services or FIXED Services. |
| ItemNumber | String | Name of the master item. |
| StockEnabled | String | Value that specifies whether the item is stockable in the deliver-to organization. |
| RestrictSubinventories | String | Value that specifies whether the item is restricted by subinventories. |
| ItemRevision | String | Revision 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. |
| UOMCode | String | Abbreviation that identifies the unit of measure. |
| 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 item or agreement. |
| SupplierItem | String | Number that identifies the supplier item. |
| SupplierItemAuxiliaryId | String | Value that uniquely identifies the supplier item auxiliary. |
| Availability | String | Value that shows the availability of the goods and services. |
| LeadTime | Decimal | Time taken by the supplier to deliver the goods once an order is placed. |
| UNSPSC | String | Value that uniquely identifies the goods and services that are bought. |
| Comments | String | Comments on the agreement line. |
| UnitOfMeasure | String | Unit of measure that the item uses. |
| InternalTransferOrderEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is enabled for internal transfer orders. If false, then the item is disabled for internal transfer orders. |
| InternallyTransferableItemFlag | Bool | Contains one of the following values: true or false. If true, then the item is internally transferrable. If false, then the item isn't internally transferrable. |
| PurchasingEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is enabled for purchasing. If false, then the item is disabled for purchasing. |
| ItemCatalogCategoryId | Long | Value that uniquely identifies the category of the item. |
| AllowMasterItemDescriptionUpdateFlag | Bool | Contains one of the following values: true, false, or NULL. If true, then the master item allows description updates on purchasing documents. If false, then the master item doesn't allow description updates on purchasing documents. If NULL, then the value is not available. |
| BPAPriceLimit | Decimal | Price limit set on a blanket purchase agreement line that allows price override. |
| AllowPriceOverrideForBPAFlag | Bool | Contains one of the following values: true, false, or NULL. If true, then the blanket purchase agreement line allows a price override. If false, then the blanket purchase agreement line doesn't allow a price override. If NULL, then the value is not available. |
| AllowDescriptionOverrideForBPAFlag | Bool | Contains one of the following values: true, false, or NULL. If true, then the blanket purchase agreement line allows a description override. If false, then the blanket purchase agreement line doesn't allow a description override. If NULL, then the value is not available. |
| SecondaryUOMCode | String | Abbreviation that identifies the secondary unit of measure. |
| PrimaryUOMCode | String | Abbreviation that identifies the primary unit of measure. |
| SupplierURL | String | URL of the supplier's organization. |
| ManufacturerURL | String | URL of the manufacturer of the item specified on a blanket purchase agreement line. |
| AttachmentURL | String | URL of the attachment on the agreement line associated with the item. |
| Finder | String | Finder criteria used to filter shopping catalog item details 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. |