Query to Get The Oracle Separate Remittance Advice (SRA) Details

SELECT

  rma.object_version_number,

  rma.remittance_advice_format_code,

  rma.remit_advice_delivery_method,

  rma.system_profile_code,

  rma.sra_override_payee_flag,

  fmt.format_name,

  l1.meaning allow_multiple_copy_flag_disp,

  l2.meaning remit_advice_del_method_disp,

  l3.meaning sra_override_payee_disp,

  rma.automatic_sra_submit_flag,

  l4.meaning automatic_sra_submit_disp

FROM

  iby_remit_advice_setup rma,

  iby_formats_vl fmt,

  fnd_lookups l1,

  fnd_lookups l2,

  fnd_lookups l3,

  fnd_lookups l4

WHERE 1=1

  AND rma.remittance_advice_format_code = fmt.format_code(+)

  AND allow_multiple_copy_flag = l1.lookup_code

  AND l1.lookup_type = 'IBY_YES_NO'

  AND remit_advice_delivery_method = l2.lookup_code(+)

  AND l2.lookup_type(+) = 'IBY_DELIVERY_METHODS'

  AND sra_override_payee_flag = l3.lookup_code

  AND l3.lookup_type = 'IBY_YES_NO'

  AND automatic_sra_submit_flag = l4.lookup_code

  AND l4.lookup_type = 'IBY_YES_NO'

  AND fmt.format_name IS NOT NULL

ORDER BY 2