1 Reply Latest reply: Jan 30, 2013 9:57 PM by User430585 -Oracle RSS

    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
           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