Oracle Apps iExpense credit card details query
Oracle EBS iExpense credit card tables
iExpense credit card transactions query
iExpense Employee credit card table
iExpense credit card bankdetails query
--Credit card bank details
SELECT * FROM AP_CARD_PROGRAMS_ALL
--Employee credit card details
SELECT ac.ROWID row_id,
ac.employee_id,
ac.card_number,
ac.card_id,
ac.limit_override_amount,
ac.trx_limit_override_amount,
ac.profile_id,
ac.cardmember_name,
ac.department_name,
ac.physical_card_flag,
ac.paper_statement_req_flag,
ac.location_id,
ac.mothers_maiden_name,
ac.description,
ac.org_id,
ac.inactive_date,
ac.last_update_date,
ac.last_updated_by,
ac.last_update_login,
ac.creation_date,
ac.created_by,
ac.attribute_category,
ac.attribute1,
ac.attribute2,
ac.attribute3,
p.full_name full_name,
p.employee_number,
acp.profile_name,
acpr.card_program_name,
p.national_identifier,
p.date_of_birth birthdate,
ac.card_expiration_date,
ac.card_program_id,
ac.card_reference_id,
ac.paycard_reference_id
FROM ap_cards_all ac,
ap_card_programs_all acpr,
ap_card_profiles_all acp,
per_people_x p
WHERE ac.profile_id = acp.profile_id(+)
AND acpr.card_program_id = ac.card_program_id
AND ac.employee_id = p.person_id(+)
AND ac.employee_id = 123456;
--Credit card transactions
SELECT *
FROM apps.AP_CREDIT_CARD_TRXNS_ALL
WHERE card_id = 121212;
Related posts:
- PTD and YTD balances query in Oracle R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set