[OAUGNet]-Re: 11i Advanced pricing questions

["Plesa, Carol" <Carol.Plesa@Garlock.com>]

We are in the process of implementing 11.5.9 with advanced pricing.  We have a bolt-on application, which based on a customer and item, would tap into the applications to get the item's selling price for that customer.  It should return the customer's discounted price based on the appropriate discounts and modifiers.   The developer on this project has the following questions:
 
1. Is there any interface defined by oracle in advance pricing where we can pass customer information(customer id, ship to location, item id etc.) and we get discounted price back?
2. Has anyone used QP_PREQ_GRP.PRICE_REQUEST API to get item price externally (using plsql outside oracle apps)?
3. How do you pass modifier values through this API?
4. In some cases we have to a create plsql record line_attr_rec and pass PRICING_ATTRIBUTE values, from where should we fetch those values (tables)? 
5. In some cases we have to a create plsql record qual_rec and pass QUALIFIER_ATTRIBUTE values, from where should we fetch those values (tables)?
 
Thank you in advance for any help you may have.  
  
Carol Plesa
Garlock Sealing Technologies
carol.plesa@garlock.com

----------Legal Disclaimer----------
The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee.  No other person is authorized to access, copy or re-use this message (or any information contained herein).  If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>