Extra line at the end of BI Publisher Report.
Good afternoon
I have created a report on BI Publisher using the following query;
select
a.TERM_ID, a.ENABLED_FLAG, TO_CHAR(TRUNC("START_DATE_ACTIVE"),'yyyymmddhhmiss'), TO_CHAR(TRUNC("END_DATE_ACTIVE"),'yyyymmddhhmiss'), a.DUE_CUTOFF_DAY, a.RANK, b.SEQUENCE_NUM, b.DUE_PERCENT, b.DUE_AMOUNT, b.DUE_DAYS, b.DUE_DAY_OF_MONTH, b.DUE_MONTHS_FORWARD, b.DISCOUNT_PERCENT, b.DISCOUNT_DAYS, b.DISCOUNT_DAY_OF_MONTH, b.DISCOUNT_MONTHS_FORWARD, b.FIXED_DATE, b.DISCOUNT_DAYS_2, c.NAME, c.DESCRIPTION, d.SET_CODE
FROM AP_TERMS_B a, AP_TERMS_LINES b, AP_TERMS_TL c, FND_SETID_SETS d, AP_TERMS_ST e