AR Payment Terms Listing (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Receivables (AR-Fusion-SQL's)
1

This AR Payment Terms Listing query generates the Payment Terms Listing Report to view all payment terms that are entered in the Payment Terms window..

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This SQL query retrieves detailed information about payment terms and their installment schedules
  RTV.NAME TERM_NAME,
  RTV.DESCRIPTION TERM_DESCRIPTION,
  DECODE( RTV.CREDIT_CHECK_FLAG,'N','No','Y','Yes',RTV.CREDIT_CHECK_FLAG) CREDIT_CHECK_FLAG,
  RTV.DUE_CUTOFF_DAY,
  DECODE(RTV.PARTIAL_DISCOUNT_FLAG,'N','No','Y','Yes',RTV.PARTIAL_DISCOUNT_FLAG) DISCOUNTS_PARTIAL_PAYMENTS,
  RTV.START_DATE_ACTIVE START_DATE,
  RTV.END_DATE_ACTIVE END_DATE,
  DECODE(RTV.FIRST_INSTALLMENT_CODE,'ALLOCATE','Allocate tax and freight','INCLUDE','Include tax and freight in first installment',RTV.FIRST_INSTALLMENT_CODE) FIRST_INSTALLMENT,
  RTV.PRINTING_LEAD_DAYS,
  DECODE(RTV.CALC_DISCOUNT_ON_LINES_FLAG,'F','Lines and Tax, not Freight Items and Tax','I','Invoice Amount','L','Lines Only','T','Lines, Freight Items, and Tax',
    RTV.CALC_DISCOUNT_ON_LINES_FLAG
  ) DISCOUNT_ON_LINES,
  RTV.BASE_AMOUNT,
  RTL.SEQUENCE_NUM SEQUENCE_NUMBER,
  RTL.RELATIVE_AMOUNT,
  RTL.DUE_DAYS DAYS,
  RTL.DUE_DATE,
  RTL.DUE_DAY_OF_MONTH,
  RTL.DUE_MONTHS_FORWARD,
  RTV.LAST_UPDATE_DATE,
  RTV.LAST_UPDATED_BY,
  RTV.CREATION_DATE,
  RTV.CREATED_BY,
  RTV.TERM_ID
 -- RT.CALC_DISCOUNT_ON_LINES_FLAG
  --RT.FIRST_INSTALLMENT_CODE
FROM
  RA_TERMS_VL RTV,
  RA_TERMS_LINES RTL
WHERE
  1 = 1
  AND RTV.TERM_ID = RTL.TERM_ID