AP AR Payment Terms Extract Query 11i

AR payments terms

SELECT t.NAME ,
  t.description,
  b.base_amount,
  b.partial_discount_flag,
  nvl(b.prepayment_flag,'N'),
  b.credit_check_flag,
  al.meaning discount_basis,
  b.start_date_active,
  b.end_date_active,
  b.printing_lead_days,
  b.due_cutoff_day,
  al.meaning installment_option,
  b.in_use,
  b.term_id,
  rtl.sequence_num,
  rtl.relative_amount,
  rtl.due_days,
  rtl.due_date,
  rtl.due_day_of_month,
  rtl.due_months_forward
FROM apps.ra_terms_tl t,
  apps.ra_terms_b b,
  apps.ar_lookups al,
  apps.ar_lookups al1,
  apps.ra_terms_lines rtl
WHERE b.term_id = t.term_id
AND rtl.term_id(+)=b.term_id
AND SYSDATE BETWEEN nvl(b.start_date_active,SYSDATE) AND nvl(b.end_date_active,SYSDATE)
AND al.lookup_code=  b.calc_discount_on_lines_flag
AND al.lookup_type='DISCOUNT_BASIS'
AND al1.lookup_type='INSTALLMENT_OPTION'
AND al1.lookup_code=    b.first_installment_code
AND t.language  = userenv('LANG')
ORDER BY 1;


--AP Payment terms

SELECT  b.NAME,
  b.description,
  b.term_id,
  b.enabled_flag,
  b.due_cutoff_day,
  b.TYPE,
  b.start_date_active,
  b.end_date_active,
  b.rank  ,
  atl.sequence_num,
  atl.due_percent,
  atl.due_amount,
  atl.fixed_date,
  atl.calendar,
  atl.due_days,
  atl.due_day_of_month,
  atl.due_months_forward,
  atl.discount_percent,
  atl.discount_days,
  atl.discount_day_of_month,
  atl.discount_months_forward,
  atl.discount_percent_2,
  atl.discount_days_2,
  atl.discount_day_of_month_2,
  atl.discount_months_forward_2,
  atl.discount_percent_3,
  atl.discount_days_3,
  atl.discount_day_of_month_3,
  atl.discount_months_forward_3
FROM apps.ap_terms_tl b,
 ap_terms_lines atl
WHERE b.language = userenv('LANG')
AND b.term_id=atl.term_id(+)
 AND SYSDATE BETWEEN nvl(b.start_date_active,SYSDATE) AND nvl(b.end_date_active,SYSDATE)
 ORDER BY 1;