1 Reply Latest reply on Jan 31, 2013 3:57 AM by User430585 -Oracle

    Query to find Customer Standard Form Details

    User430585 -Oracle
      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
           Contact Name
           Site Number
           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