OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » to retrieve customer name and customer num

Home » Applications » Oracle Fusion Apps & E-Business Suite » to retrieve customer name and customer num (11g)

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

to retrieve customer name and customer num [message #591114]

Wed, 24 July 2013 21:52

narrasai27
Messages: 2
Registered: July 2013
Location: kuala lumpur

Junior Member

Hi friends,
i need to get the customer name and customer number based on certain condition
in the table oe_transaction_types there is a column transaction_type and attribute1
now i need to retrieve the filter the customers with the combination of transaction_type and attribute1.
for example in " oe_transaction_types "

transaction_type attribute1
--------------- --------------
xyx
xyz con
xyz con
xy2
abc mnv
so now i have to get the customername and customer num whos transaction_type and attribute1 is not null that means only 3 customers from the above example.

so now pls give the query for this requirement to get the customer name and cust num.

Thanks and Rgrds
(Sai Kishore)

Report message to a moderator

Re: to retrieve customer name and customer num [message #591115 is a reply to message #591114]

Wed, 24 July 2013 21:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

we don't have your tables or data.
post CREATE TABLE statement for all tables involved.

Report message to a moderator

Re: to retrieve customer name and customer num [message #591118 is a reply to message #591115]

Wed, 24 July 2013 22:38

narrasai27
Messages: 2
Registered: July 2013
Location: kuala lumpur

Junior Member

this is from oracle apps environment.
the tables involved are 1)oe_transaction_types
from this table depending on the transaction type and attribute we have to get the customers of that type .
so question is how to get the customer name and num from oe_transaction_types which table is that we have to link with
is it ra_customers or anyothr table where we can pull out customers from this transaction

Report message to a moderator

Re: to retrieve customer name and customer num [message #591134 is a reply to message #591118]

Thu, 25 July 2013 01:08

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

RA_CUSTOMERS has been obsolete for some time, you need to look a the HZ tables.

Report message to a moderator

Previous Topic:	Tables Documentation
Next Topic:	Records Not Found in mtl material transactions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 01:24:30 CST 2024