AP Payment Terms Listing - draft

Description
Categories: BI Publisher
Columns: C Term Id, C Name, C Description, C Cutoff Day, C Rank, C Start Date Active, C End Date Active ...
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(