BI Publisher (MOSC)

MOSC Banner

Extra line at the end of BI Publisher Report.

edited Apr 29, 2016 12:55PM in BI Publisher (MOSC) 5 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center