AR Payment Terms Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Receivables
Source: Payment Terms Listing (XML)
Short Name: RAXPTL_XML
DB package: AR_RAXPTL_XMLP_PKG
Run AR Payment Terms Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
AR Transaction Detail AR iReceivables Customers Statement Data Definition AR Discount Projection AR Transaction Types BR100 ONT Comprehensive Order Detail ONT Sales Order Acknowledgement AR Customer Listing - Detail AR Customer Profiles AR Transaction Batch Source Listing
Blitz Report™

Blitz Report™ provides multiple benefits: