Hi, In product pricing, we can define multiple record PRIMARY KEY (product_id, product_price_type_id, product_price_purpose_id, currency_uom_id, product_store_group_id, from_date)
My below scenario is at below (1 + 2 + 3 + 4 + 5 + 2Jan2014 ) and thruDate = 15Jan2014 (1 + 2 + 3 + 4 + 5 + 15Jan2014 ) and thruDate is null and i would like to return 15jan2014 pricing, and i will return 2 records. And assuming timestamp is not important in this scenario. Just only the date What is the current practice of choosing which record to retrieve ? -- Disclaimer : This E-mail is intended only for the use of the individual or entity named above and may contain information that is confidential. If you are not the intended recipients, please immediately notify us by return email and delete it from your system. Any unauthorised dissemination, distribution or copying of this email is strictly prohibited. Thank You.
