Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

fetch two table records together and add them as one record ,how ?

edited Oct 14, 2015 10:01AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

V551070.Select

V551070.Fetch Next

While SV File_IO_Status is equal to CO SUCCESS

If VA rpt_GL is greater than or equal to PO StartDate And VA rpt_GL is less than or equal to PO EndDate

VA rpt_TotalAmount = [VA rpt_TransactionAmount]+[VA rpt_CheckAmount]

If VA rpt_TotalAmount is greater than or equal to <Zero>

VA rpt_TotalDebit = VA rpt_TotalAmount

VA rpt_TotalAmount = "0"

Else

VA rpt_TotalCredit = VA rpt_TotalAmount

VA rpt_TotalAmount = "0"

End If

End If

V551070.Fetch Next

End While

RV Credit2 = VA rpt_TotalCredit

RV Debit2 = VA rpt_TotalDebit

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