This discussion is archived
1 Reply Latest reply: Jan 30, 2013 7:57 PM by User430585 - Oracle RSS

Query to find Customer Standard Form Details

User430585 - Oracle Explorer
Currently Being Moderated
Hi Gurus,

Can anyone Help me out with a query , which will fetch the details of the Customer standard form in Oracle Receivables

Navigation from applications :- Oracle Receivables Super User => Customers => Standard.

Customer details like Customer Address,Contacts,Communication, Contact roles

my requirement is to fetch the following columns from the customer standard form in a sql query.

eg :
Need a script that will provide the following
     Account Number
     Customer Type
     Account Name
     Category
     Type
     Status
     Address
     Country
     Contact Name
     Site Number
     Address
     Country
     Usage
     Status (Active Y or N)

Am very new to this module, so i am not much aware of the tables and joins involved in it.

any help is highly appreciated.

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points