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
Run AP Payment Terms Listing- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
            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 Name SQL text Validation
Operating Unit 
 
 LOV
Terms Status 
 
 LOV Oracle
Effective Date 
 
 Date
Download
Related Blitz Reports
AP Invoices and Lines PO IDV Modification XXE4ARW Excel4apps Suppliers and Sites PO IDV Data template PO Award Data template PON Solicitation data template AP Suppliers PO Financials/Purchasing Options Listing AP Suppliers Report- Not Supported: Reserved For Future Use ECC Contract Lifecycle Management, Solicitations, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: