Oracle Apps iExpense credit card details query

1--Credit card bank details
2SELECT * FROM AP_CARD_PROGRAMS_ALL
3
4
5--Employee credit card details
6SELECT ac.ROWID        row_id,
7       ac.employee_id,
8       ac.card_number,
9       ac.card_id,
10       ac.limit_override_amount,
11       ac.trx_limit_override_amount,
12       ac.profile_id,
13       ac.cardmember_name,
14       ac.department_name,
15       ac.physical_card_flag,
16       ac.paper_statement_req_flag,
17       ac.location_id,
18       ac.mothers_maiden_name,
19       ac.description,
20       ac.org_id,
21       ac.inactive_date,
22       ac.last_update_date,
23       ac.last_updated_by,
24       ac.last_update_login,
25       ac.creation_date,
26       ac.created_by,
27       ac.attribute_category,
28       ac.attribute1,
29       ac.attribute2,
30       ac.attribute3,
31       p.full_name     full_name,
32       p.employee_number,
33       acp.profile_name,
34       acpr.card_program_name,
35       p.national_identifier,
36       p.date_of_birth birthdate,
37       ac.card_expiration_date,
38       ac.card_program_id,
39       ac.card_reference_id,
40       ac.paycard_reference_id
41  FROM ap_cards_all         ac,
42       ap_card_programs_all acpr,
43       ap_card_profiles_all acp,
44       per_people_x         p
45 WHERE     ac.profile_id = acp.profile_id(+)
46       AND acpr.card_program_id = ac.card_program_id
47       AND ac.employee_id = p.person_id(+)
48       AND ac.employee_id = 123456;
49
50--Credit card transactions
51SELECT *
52  FROM apps.AP_CREDIT_CARD_TRXNS_ALL
53 WHERE card_id = 121212;