Query criteria to determine future item price for a given item and store identifier. Store unique identifier Sku number Future item price effective date. Item price header information. Item price identifier. Item price unique identifer from an external system. SIM store internal identifier. Sku number Date that the price becomes effective. Date that the price is no longer valid. Price type. Valid values are CLEARANCE, PROMOTIONAL, PERMANENT, NO_VALUE, UNKNOWN. The currency code of the current selling unit price. The current selling unit price. Status Valid values are APPROVED, PENDING, ACTIVE, COMPLETED, REJECTED, TICKET_LIST, NEW, DEFAULT, DELETED, NO_VALUE, UNKNOWN. Promotion unique identifier. Promotion component unique identifier. Selling unit of measure of the current price. Number of units involved in the multi unit pricing of the item. The currency code of the multi unit price. The new multi unit price. Unit of measure of the multi unit price. True if a change was made to the multi-unit pricing for this item price, false if it only involves regular pricing. True if a change was made to this item price. The name of the associated promotion. The long description of the associated promotion. The name of the promotion component. Clearance reset identifier. The currency code of the new selling unit price. The new selling unit price. Selling unit of measure of the new unit price. The currency code of the manufacturer's suggested retail price. The amount of the manufacturer's suggested retail price. Future Item Price information The currency code of the unit price on the effective date. The unit price on the effective date. The unit of measure that applies to unit price on effective date. Query criteria to find item price information. SIM store internal identifier Include prices with an effective date equal to or after this date. Include prices with an effective date equal to or before this date. Include prices with an end date equal to or after this end date. Include prices with an end date equal to or before this end date. Include prices with items with this merchandise hierarchy department identifier. Include prices with items with this merchandise hierarchy class identifier. Include prices with items with this merchandise hierarchy subclass identifier. Include only prices for this particular sku. Include only prices in this status. Valid values are APPROVED, PENDING, ACTIVE, COMPLETED, REJECTED, TICKET_LIST, NEW, DEFAULT, DELETED, NO_VALUE, UNKNOWN. Include only prices of this type. Valid values are CLEARANCE, PROMOTIONAL, PERMANENT, NO_VALUE, UNKNOWN. Include only prices associated with this promotion. Maximum number of items to return from the query. Item Price reference Item Price unique identifier. A collection of item price header information. A collection of item price header information. Size of the collection. This service describes the Oracle Retail Store Inventory Management (SIM) Item Price service.