How to get Receipt Methods information in Oracle Receivables
select arma.receipt_method_id,
arc.name,
arc.creation_method_code
creation_method,
arm.name as receipt_method_name,
arm.printed_name,
bv.bank_name,
bv.bank_branch_name,
cba.bank_account_name,
cba.bank_account_num,
cba.currency_code currency,
gcc.segment1 as cash,
gcc.segment2 as cash,
gcc.segment3 as cash,
gcc.segment4 as cash,
gcc.segment5 as cash,
gcc.segment6 as cash,
gcc.segment7 as cash,
gcc.segment8 as cash,
gccrc.segment1 as receiptcon,
gccrc.segment2 as receipt,
gccrc.segment3 as receipt,
gccrc.segment4 as receipt,
gccrc.segment5 as receipt,
gccrc.segment6 as receipt,
gccrc.segment7 as receipt,
gccrc.segment8 as receipt,
gccrem.segment1 as remittance,
gccrem.segment2 as remittance,
gccrem.segment3 as remittance,
gccrem.segment4 as remittance,
gccrem.segment5 as remittance,
gccrem.segment6 as remittance,
gccrem.segment7 as remittance,
gccrem.segment8 as remittance,
gccfactor.segment1 as factoring,
gccfactor.segment2 as factoring,
gccfactor.segment3 as factoring,
gccfactor.segment4 as factoring,
gccfactor.segment5 as factoring,
gccfactor.segment6 as factoring,
gccfactor.segment7 as factoring,
gccfactor.segment8 as factoring,
gccdebt.segment1 as stdebt,
gccdebt.segment2 as stdebt,
gccdebt.segment3 as stdebt,
gccdebt.segment4 as stdebt,
gccdebt.segment5 as stdebt,
gccdebt.segment6 as stdebt,
gccdebt.segment7 as stdebt,
gccdebt.segment8 as stdebt,
gccbchrg.segment1 as bankcharge,
gccbchrg.segment2 as bankcharge,
gccbchrg.segment3 as bankcharge,
gccbchrg.segment4 as bankcharge,
gccbchrg.segment5 as bankcharge,
gccbchrg.segment6 as bankcharge,
gccbchrg.segment7 as bankcharge,
gccbchrg.segment8 as bankcharge,
gccunappl.segment1 as unapplied,
gccunappl.segment2 as unapplied,
gccunappl.segment3 as unapplied,
gccunappl.segment4 as unapplied,
gccunappl.segment5 as unapplied,
gccunappl.segment6 as unapplied,
gccunappl.segment7 as unapplied,
gccunappl.segment8 as unapplied,
gccunident.segment1 as unidentified,
gccunident.segment2 as unidentified,
gccunident.segment3 as unidentified,
gccunident.segment4 as unidentified,
gccunident.segment5 as unidentified,
gccunident.segment6 as unidentified,
gccunident.segment7 as unidentified,
gccunident.segment8 as unidentified,
gcconact.segment1 as on_account,
gcconact.segment2 as on_account,
gcconact.segment3 as on_account,
gcconact.segment4 as on_account,
gcconact.segment5 as on_account,
gcconact.segment6 as on_account,
gcconact.segment7 as on_account,
gcconact.segment8 as on_account,
gccunearn.segment1 as unearned,
gccunearn.segment2 as unearned,
gccunearn.segment3 as unearned,
gccunearn.segment4 as
unearned,
gccunearn.segment5 as unearned,
gccunearn.segment6 as unearned,
gccunearn.segment7 as unearned,
gccunearn.segment8 as unearned,
gccearn.segment1 as earned,
gccearn.segment2 as earned,
gccearn.segment3 as earned,
gccearn.segment4 as earned,
gccearn.segment5 as earned,
gccearn.segment6 as earned,
gccearn.segment7 as earned,
gccearn.segment8 as earned
from
ar_receipt_method_accounts_all arma
inner join
ar_receipt_methods arm on arm.receipt_method_id = arma.receipt_method_id
inner join
ar_receipt_classes arc on arc.receipt_class_id = arm.receipt_class_id
inner join
ce_bank_acct_uses_all cbau on cbau.bank_acct_use_id =
arma.remit_bank_acct_use_id
inner join
ce_bank_accounts cba on cba.bank_account_id = cbau.bank_account_id
inner join
ce_bank_branches_v bv on
bv.branch_party_id = cba.bank_branch_id
left outer join
gl_code_combinations gcc on gcc.code_combination_id = arma.cash_ccid
left outer join
gl_code_combinations gccrc on gccrc.code_combination_id =
arma.receipt_clearing_ccid
left outer join gl_code_combinations gccrem on gccrem.code_combination_id = arma.remittance_ccid
left outer join gl_code_combinations gccfactor on
gccfactor.code_combination_id = arma.factor_ccid
left outer join gl_code_combinations gccdebt on
gccdebt.code_combination_id = arma.short_term_debt_ccid
left outer join gl_code_combinations gccbchrg on
gccbchrg.code_combination_id = arma.bank_charges_ccid
left outer join gl_code_combinations gccunappl on
gccunappl.code_combination_id = arma.unapplied_ccid
left outer join gl_code_combinations gccunident on
gccunident.code_combination_id = arma.unidentified_ccid
left outer join gl_code_combinations gcconact on
gcconact.code_combination_id = arma.on_account_ccid
left outer join gl_code_combinations gccunearn on
gccunearn.code_combination_id = arma.unearned_ccid
left outer join gl_code_combinations gccearn on
gccearn.code_combination_id = arma.earned_ccid
where
arma.end_date is null
--and arc.receipt_class_id = 1000
--and printed_name like '%34%'
-- arma.receipt_method_id = 3030
