SELECT
app.payment_profile_name,
ppp.system_profile_code,
ppp.payment_format_code,
pm.payment_method_name,
ppp.periodic_sequence_name_1 seq_name,
app.payment_profile_id pmt_prof,
app.reset_value_1 reset_val,
app.last_used_number_1 last_used,
ppp.processing_type,
ppp.mark_complete_event mrk_cmplt,
ppp.outbound_pmt_file_directory,
ppp.outbound_pmt_file_prefix,
ppp.outbound_pmt_file_extension ext,
ppp.positive_pay_file_directory,
ppp.positive_pay_file_prefix,
ppp.positive_pay_file_extension pp_ext,
ppp.default_payment_document_id def_pmt_docid,
ppp.last_update_date,
sra.sra_override_payee_flag sra_ovrd_payee,
fmt.format_name sra_fmt,
sra.automatic_sra_submit_flag sra_autosub
FROM
iby_sys_pmt_profiles_b ppp,
iby_acct_pmt_profiles_vl app,
iby_applicable_pmt_profs appl_prof,
iby_payment_methods_vl pm,
iby_remit_advice_setup sra,
iby_formats_vl fmt
WHERE
1 = 1
AND ppp.system_profile_code = app.system_profile_code
AND ppp.system_profile_code = appl_prof.system_profile_code(+)
AND appl_prof.applicable_value_to = pm.payment_method_code(+)
AND NVL (appl_prof.applicable_type_code, 'PAYMENT_METHOD') = 'PAYMENT_METHOD'
AND ppp.system_profile_code = sra.system_profile_code(+)
AND sra.remittance_advice_format_code = fmt.format_code(+)
AND ppp.system_profile_code LIKE 'XX%';