OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » PRICING

Home » Applications » Oracle Fusion Apps & E-Business Suite » PRICING_CONTEXT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PRICING_CONTEXT [message #382922]

Mon, 26 January 2009 06:35

hany_marawan
Messages: 198
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

Report message to a moderator

Re: PRICING_CONTEXT [message #382927 is a reply to message #382922]

Mon, 26 January 2009 07:23

Littlefoot
Messages: 21811
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).

Report message to a moderator

Re: PRICING_CONTEXT [message #383361 is a reply to message #382922]

Wed, 28 January 2009 08:45

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

Report message to a moderator

Re: PRICING_CONTEXT [message #384120 is a reply to message #382922]

Mon, 02 February 2009 03:44

hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt

Senior Member

Hello,
Many Many Many tahnks for your help.
The table it true

Report message to a moderator

Previous Topic:	How we can know either a AR transaction Open or close
Next Topic:	Import Blanket Releases

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 12:21:05 CDT 2024