Receipt Method Query (with maximum details)

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