DBA Data[Home] [Help]

APPS.GMF_AR_GET_BANK_CODES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

       SELECT    gsob.name    ,
              aba.bank_account_name  ,
              aba.bank_account_num  ,
              aba.currency_code  ,
              aba.description    ,
              aba.max_check_amount  ,
              aba.min_check_amount  ,
              aba.bank_account_type  ,
              aba.multi_currency_flag  ,
              aba.inactive_date
       FROM      ap_bank_accounts_all aba,
              gl_sets_of_books gsob
       WHERE      aba.set_of_books_id =
              gsob.set_of_books_id  AND
               gsob.name like sobname  AND
              aba.creation_date  BETWEEN
              nvl(startdate,aba.creation_date)  AND
              nvl(enddate,aba.creation_date);