Get Credit Card Number for a customer number (oracle 11i)

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

– – Description: For any customer number, this gives credit card or bank account number (oracle 11i) – Author:      Jay Gopal / Jiltin – Input:       &&Cust_number – Download the code SELECT RC.CUSTOMER_NAME, RC.CUSTOMER_NUMBER, BACCT.BANK_ACCOUNT_NAME BANK_NAME, BACCT.BANK_ACCOUNT_NUM CREDIT_CARD_NUMBER, TO_CHAR(bacct.inactive_date,’DD-MON-YYYY’)  CREDIT_VALIDAITY_DATE, BANK_ACCOUNT_USES_id, Read Full Article (Click here)...

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

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

Posted by Jiltin     Tags: , , , 10 November, 2008    525 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 : , , ,