2 Replies Latest reply: Oct 18, 2012 11:47 AM by Rejula RSS

    Receipt Method Bank Account number

    Rejula
      Hi all,

      I want to know to which bank account the particular Receipt Method is linked.


      Please tell me how i can track.

      Thanks And Regards
      Reju
        • 1. Re: Receipt Method Bank Account number
          AlexAnd
          by sql

          look at
          ar_receipt_methods - http://etrm.oracle.com/pls/etrm/etrm_pnav.show_object?c_name=AR_RECEIPT_METHODS&c_owner=AR&c_type=TABLE
          ar_receipt_method_accounts_all - http://etrm.oracle.com/pls/etrm/etrm_pnav.show_object?c_name=AR_RECEIPT_METHOD_ACCOUNTS_ALL&c_owner=AR&c_type=TABLE

          and where clause for interesting bank_account_name or bank_account_num
          select cba.bank_account_name, cba.bank_account_num, rm.name method_name
            from ar_receipt_method_accounts_all rma,
                 ce_bank_acct_uses_all          ba,
                 ce_bank_accounts               cba,
                 ar_receipt_methods             rm
           where 1 = 1
             and rma.remit_bank_acct_use_id = ba.bank_acct_use_id
             AND ba.bank_account_id = cba.bank_account_id
             and rma.receipt_method_id = rm.receipt_method_id
          • 2. Re: Receipt Method Bank Account number
            Rejula
            Thanq Alex....

            Regards
            Reju