[OAUGNet]-Re: 11i Advanced pricing questions

[Carol Francum <cfrancum@earthlink.net>]

Carol --

Hi there! 
There are two groups that I worked with who may have answers,  US Steel, and a medical manufacturer out of Knoxville, Tn -- Will try to locate specific email addresses for you.

Has your developer checked all the Oracle Whitepapers for Advanced Pricing?  I think there's one that describes exactly how to use the API --

For passing modifier values, if you are referring to dipping into a pricing modifier (discount) which has been set-up, the folks at US Steel did some reverse engineering of the tables in order to get the data...  I may have a copy of that, if you are interested.

For getting pricing attribute and qualifier attribute data, it's kind of fun... You need to get into the pricing attribute context information, and I can definitely send you something on that.

Hope all is going well at Garlock....   What version are you on?  Have you updated, yet?

Carol Francum


-----Original Message-----
From: "Plesa, Carol" <Carol.Plesa@Garlock.com>
Sent: Jan 18, 2005 12:51 PM
To: OAUG Net listserver <OAUGNet@oaug.com>
Subject: [OAUGNet]-Re: 11i Advanced pricing questions 

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>



#############################################################
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>