AR Payment Terms Listing

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Payment Terms Listing (XML)
Short Name: RAXPTL_XML
DB package: AR_RAXPTL_XMLP_PKG
SELECT rat.term_id term_id,   
           rat.name parent_name, 
           rat.description  description,
           look2.meaning credit_check,
           rat.base_amount  base_amount, 
           rat.due_cutoff_day cutoff_day,
           rat.printing_lead_days print_lead_days, 
           rat.start_date_active  start_date,
           rat.end_date_active  end_date, 
           look1.meaning  partial_pay,
           look3.meaning  disc_on_lines,
           look4.meaning first_installment
FROM   ra_terms rat,  ar_lookups look1,
           ar_lookups look2,ar_lookups look3, ar_lookups look4
    WHERE  rat.partial_discount_flag = look1.lookup_code
    AND    look1.lookup_type = 'YES/NO'
    AND    rat.calc_discount_on_lines_flag = look3.lookup_code
    AND    look3.lookup_type in ('YES/NO' ,'DISCOUNT_BASIS')
    AND    rat.credit_check_flag = look2.lookup_code(+)
    AND    look2.lookup_type(+) = 'YES/NO'
    AND    rat.first_installment_code = look4.lookup_code
    AND    look4.lookup_type = 'INSTALLMENT_OPTION'
    ORDER BY rat.name
Ask a question