Get Credit Card Number for an invoice (oracle 11i)

Posted by Jiltin     Tags: , , , 10 November, 2008    701 views    (0) Comment

/* Description: This script will find the credit card number for an invoice number (oracle 11i) Author:      Jay Gopa l/ Jiltin Input:       &&inv_no */ select rc.customer_name customer, rct.trx_number invoice_number, apa.bank_account_id, apa.bank_account_name bank_name, apa.bank_account_num credit_card_number, to_char(apa.inactive_date,’dd-mon-yyyy’) credit_validaity_date, rct.invoice_currency_code, rct.org_id from ap_bank_accounts_all apa, ra_customer_trx_all Read Full Article (Click here)...

Categories : 11i Scripts, Receivables Tags : , , ,