Home » Applications » Oracle Fusion Apps & E-Business Suite » to retrieve customer name and customer num (11g)
to retrieve customer name and customer num [message #591114] Wed, 24 July 2013 21:52 Go to next message
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)
Re: to retrieve customer name and customer num [message #591115 is a reply to message #591114] Wed, 24 July 2013 21:58 Go to previous messageGo to next message
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.
Re: to retrieve customer name and customer num [message #591118 is a reply to message #591115] Wed, 24 July 2013 22:38 Go to previous messageGo to next message
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
Re: to retrieve customer name and customer num [message #591134 is a reply to message #591118] Thu, 25 July 2013 01:08 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
RA_CUSTOMERS has been obsolete for some time, you need to look a the HZ tables.
Previous Topic: Tables Documentation
Next Topic: Records Not Found in mtl material transactions
Goto Forum:
  


Current Time: Thu Mar 28 14:37:57 CDT 2024