Wednesday, August 30, 2017

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


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect