Payables and Cash Management - EBS (MOSC)

MOSC Banner

Need Query that will work fater for fetching data

edited Aug 11, 2011 2:52AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
Hi

Issue - Trial balance shows 0.01 positive or negative balance in trial balance as per below. There could be more than 1000 such records in the data at present.

I want for now to select only say 10 or 50 records in a table to work on correction of these records.

Can some one please help with a query to fetch and gather the data in a table?

                                              Accounts Payable Trial Balance

                      Invoice
Invoice Number        Date       Curr              Amount    Remaining Amount  Invoice Description
--------------------  ---------  ----  ------------------  ------------------  ----------------------------------------------------
Supplier Name:       XYZ

575                   06-NOV-07  BRL            5,201.97               (0.01)  Tipo de Nota: SERVICOS - REC: 4912 (Nota Fiscal)
620                   07-FEB-08  BRL            3,698.01                0.01   Tipo de Nota: SERVICOS - REC: 33727 (Nota Fiscal)

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