Query to get bank account details in Oracle E-business R12 CM, quick results.

/*Query to get All bank accounts in Oracle EBS R12 */ SELECT A10.HOME_COUNTRY "Country", a10.bank_name "Bank Name", CBA.BANK_ACCOUNT_NAME "Account Name", A10.BANK_PARTY_ID "Bank Code", BB.BANK_BRANCH_NAME "Branch Name", BB.BANK_BRANCH_ID "Bank Brach Code",…

Continue reading
Query to get AR invoice details on Oracle E-business EBS R12, Easy and Fast.

/*get AR invoice Lines Detailes */ SELECT DISTINCT rl.customer_trx_line_id, DECODE (RCTT.TYPE, 'CB', 'Chargeback', 'CM', 'Credit Memo', 'DM', 'Debit Memo', 'DEP', 'Deposit', 'GUAR', 'Guarantee', 'INV', 'Invoice', 'PMT', 'Receipt', 'Invoice') INVOICE_CLASS, --…

Continue reading