Home » Applications » Oracle Fusion Apps & E-Business Suite » PRICING_CONTEXT
PRICING_CONTEXT [message #382922] Mon, 26 January 2009 06:35 Go to next message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
I want to know where is the data of PRICING_CONTEXT field (in sales order form) inserted in the database.
I found table oe_order_lines_all contains this field but it's empty.
I want to know where is it inserted?.
Please it's urgently.

Thanks
Re: PRICING_CONTEXT [message #382927 is a reply to message #382922] Mon, 26 January 2009 07:23 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, note that I don't know anything about Oracle Applications so - this might not be the answer.

However: if you know a column name and have access to the database (either as a privileged user or as the owner), you might try to search for a column as
SQL> select table_name from user_tab_columns where column_name = 'DEPTNO';

TABLE_NAME
------------------------------
DEPT
EMP
If you run it as a privileged user (such as SYS), you'd query ALL_TAB_COLUMNS instead (and probably add the OWNER column into the selectable column list).
Re: PRICING_CONTEXT [message #383361 is a reply to message #382922] Wed, 28 January 2009 08:45 Go to previous messageGo to next message
B.T.S.Ananth
Messages: 216
Registered: June 2006
Location: chennai / Hyderabad
Senior Member

HI,

THE TABLE NAME IS OE_ORDER_PRICE_ATTRIBS .

This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user
Re: PRICING_CONTEXT [message #384120 is a reply to message #382922] Mon, 02 February 2009 03:44 Go to previous message
hany_marawan
Messages: 195
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
Many Many Many tahnks for your help.
The table it true
Previous Topic: How we can know either a AR transaction Open or close
Next Topic: Import Blanket Releases
Goto Forum:
  


Current Time: Thu Dec 08 08:03:22 CST 2016

Total time taken to generate the page: 0.10407 seconds