[Oracle]R12:付款條件

SELECT RT.TERM_ID,
       RT.NAME,
       RT.CYCLE_NAME,
       RTL.SEQUENCE_NUM,
       RTL.RELATIVE_AMOUNT    相關金額,
       RTL.DUE_DAYS           到期天數,
       RTL.DUE_DATE           到期日期,
       RTL.DUE_DAY_OF_MONTH   每月固定日期,
       RTL.DUE_MONTHS_FORWARD 後推月數,
       RTL.CREATION_DATE,
       RTL.CREATED_BY,
       FU1.USER_NAME,
       RTL.LAST_UPDATE_DATE,
       RTL.LAST_UPDATED_BY,
       FU2.USER_NAME
  FROM RA_TERMS_VL RT, RA_TERMS_LINES RTL, FND_USER FU1, FND_USER FU2
 WHERE 1 = 1
   AND RT.TERM_ID = RTL.TERM_ID
   AND RTL.CREATED_BY = FU1.USER_ID
   AND RTL.LAST_UPDATED_BY = FU2.USER_ID
   AND TRUNC(NVL(RT.END_DATE_ACTIVE, SYSDATE + 1)) > TRUNC(SYSDATE)
 ORDER BY RT.TERM_ID ASC