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

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