AP Payment Terms Lines (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Payables (AP-Fusion-SQL's)
1

This AP Payment Terms Lines query displays detailed payment term schedules and discount structures for each term, including due percentages, due dates, and multiple discount tiers defined in the AP Terms setup.

#sqlquery

SELECT 
     -- SQL4Fusion (An Orbit Analytics Project) 
     -- This Query displays detailed payment term schedules and discount structures for each term
       AT.NAME TERM_NAME,
       ATL.SEQUENCE_NUM SEQUENCE_NUMBER,
       ATL.DUE_PERCENT DUE_PERCENT,
       NVL (ATL.DUE_AMOUNT, 0) DUE_AMOUNT,
       ATL.DUE_DAYS DUE_DAYS,
       ATL.DUE_DAY_OF_MONTH DUE_DAY_OF_MONTH,
       ATL.DUE_MONTHS_FORWARD,
       ATL.DISCOUNT_PERCENT,
       ATL.DISCOUNT_DAYS,
       ATL.DISCOUNT_DAY_OF_MONTH,
       ATL.DISCOUNT_MONTHS_FORWARD,
       ATL.DISCOUNT_PERCENT_2 ,
       ATL.DISCOUNT_DAYS_2 ,
       ATL.DISCOUNT_DAY_OF_MONTH_2 ,
       ATL.DISCOUNT_MONTHS_FORWARD_2 ,
       ATL.DISCOUNT_PERCENT_3 ,
       ATL.DISCOUNT_DAYS_3,
       ATL.DISCOUNT_DAY_OF_MONTH_3,
       ATL.DISCOUNT_MONTHS_FORWARD_3,
       ATL.FIXED_DATE,
       ATL.CALENDAR,
       ATL.TERM_ID TERM_ID
FROM   
       AP_TERMS_LINES ATL, 
       AP_TERMS AT      
 WHERE 1=1
    AND AT.TERM_ID = ATL.TERM_ID 
   ORDER BY SEQUENCE_NUM