Oracle iExpense Credit Card Transaction Details Query in R12

Below query will give you detail for credit card transaction for User with details like credit card number, user name, credit card transaction type, transaction amount and age of transaction etc.

SELECT fu.user_name,
             papf.full_name,
             cc.cardmember_name,
             cc.card_number,
             tr.transaction_type,
             tr.transaction_date,
             tr.transaction_amount,
             tr.posted_currency_code,
             tr.merchant_name1,
             tr.merchant_city,
             round(sysdate - tr.transaction_date) age_cc_trx,
             tr.posted_amount,
             tr.trx_id
       FROM ap_credit_card_trxns_all tr,
             ap_cards_all             cc,
             hr.per_all_people_f      papf,
             fnd_user                 fu
       WHERE tr.card_ID = cc.card_ID
         and tr.card_program_id = cc.card_program_id
         and cc.employee_id = papf.person_id
         and fu.employee_id = papf.person_id
         and upper(fu.user_name) = upper(l_user_name)
         and tr.report_header_id is null;