Payables and Cash Management - EBS (MOSC)

MOSC Banner

Report Open Account Balances Listing

edited Oct 18, 2013 3:37PM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered
 There is one prepayment in the report that this prepayment is full pay.
I Executed this query 


select * 
from xla_trial_balances 
where source_entity_id in ( 
select entity_id 
from xla.xla_transaction_entities xte 
where application_id = 200 
and ( 
(entity_code = 'AP_INVOICES' and source_id_int_1 in (&invoice_id)) 
OR 
applied_to_entity_id in ( 
select entity_id 
from xla.xla_transaction_entities xte 
where application_id = 200 
and ( 
(entity_code = 'AP_INVOICES' and source_id_int_1 in (&invoice_id)) 
);

And the this query i saw the value.

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