AP Payment Terms Listing- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Payment Terms Listing
Application: Payables
Source: Payment Terms Listing (XML) - Not Supported: Reserved For Future Use
Short Name: APXPTPTR_XML
DB package: AP_APXPTPTR_XMLP_PKG
            SELECT  t.term_id C_TERM_ID,
                    name C_NAME,
                    description C_DESCRIPTION,
                    due_cutoff_day C_CUTOFF_DAY,
                    rank C_RANK,
                    start_date_active C_START_DATE_ACTIVE,
                    end_date_active C_END_DATE_ACTIVE
            FROM    ap_terms t
            WHERE   name != 'Prepayment Immediate'
              AND   ( (:p_effective_date BETWEEN
                       decode(upper(:p_termtype),'ACTIVE', start_date_active,
                                    'INACTIVE',:p_effective_date+1,
                                            :p_effective_date)
                    AND     decode(upper(:p_termtype),'ACTIVE',
                                  nvl(end_date_active, :p_effective_date),
                                   'INACTIVE',:p_effective_date+1,
                                   :p_effective_date) )
                    OR NOT ( :p_effective_date BETWEEN
                    decode(upper(:p_termtype),'INACTIVE', start_date_active,
                                    :p_effective_date)
                    AND     decode(upper(:p_termtype),'INACTIVE', end_date_active,
                                    :p_effective_date) ) )
            GROUP BY t.term_id, name, description, due_cutoff_day, rank,
                            start_date_active, end_date_active
            ORDER BY rank, upper(Name), start_date_active
Parameter NameSQL textValidation
Operating Unit
 
LOV
Terms Status
 
LOV Oracle
Effective Date
 
Date
Download
Related Blitz Reports
AP Invoices and Lines 11i APL: AP Invoices and Lines AP Invoices and Lines(GST) XXAP Supplier Sites Audit AP Supplier Upload AP Invoices and Lines ECC Procurement, Purchase Orders AP Suppliers ECC Project Manufacturing, Procurement Activities, SQL3 PO IDV Modification
Blitz Report™