AP Payment Terms Listing - draft

Description
Categories: BI Publisher, Financials, Procurement
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 Name SQL text Validation
Ledger
 
Effective Date
 
Date
Terms Status
 
LOV Oracle