Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

iStore

user473473Apr 4 2013 — edited Apr 10 2013
We have a generic account. Which has say 3 ship to. we have attached price list A to to 1st ship to, price list B to the 2nd ship to and price list C to the 3rd ship to.

Isuue is: to search and order skus we need to have a price list at the account level. If i add price list A at the customer account level. The users who are suppose to use price list B and C will see only items in price list A as currently price list A is attached at Customer Account level.

So each time price list B customers has to use this generic account to order, we had to change the price list at the customer account level to B

and each time price list C customers has to use this generic account to order, we had to change the price list at the customer account level to C

Is there any solution to such generic accounts.?

Please help

Thanks in Advance.

Comments

TSharma-0racle

I didn't understand the question clearly but will this work for yo?

SET MARKUP HTML ON

spool on

query

spool off

This will generate a html report from sqlplus

1 person found this helpful
user10936714

This is helpful, but the main problem is to get the HTML into the clipboard with MIME type "text/html" so that when you paste it the email client knows that it is HTML instead of just text. My experience with sqlplus is that it is just a command-line/console app.

1 person found this helpful
TSharma-0racle

Check this if this can help:

Converting Query results into HTML email

SchemaCzar

+1 to this as a feature request

  1. copy as html to clipboard
  2. FEWER CLICKS when exporting from query result!
  3. some controls over html template/styles
  4. Create html email from query result
SchemaCzar

I've had good luck with the html markup, but sqlplus is so last millenium....

Marwim 
... but sqlplus is so last millenium....

Seriously? I'm from the last millennium too, nevertheless I don't consider myself out of date

SQL*PLUS is still my first choice when I have to run a script. I'ts behaviour is reliably the same whereever my script is executed. I would never trust a script that needs another tool to be executed.

Generating a HTML-mail is IMHO out of scope for a database tool. It's a feature I would expect in a BI tool that specializes on reporting.

Regards

Marcus

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 8 2013
Added on Apr 4 2013
#customer-experience-cx, #e-commerce-istore
1 comment
1,195 views