Post date: Feb 14, 2014 9:24:30 AM
select *
from ap_invoice_distributions_all
where invoice_id ='182631'
select *
from ap_invoice_distributions_all
where 1=1
and line_type_lookup_code='PREPAY'
--and period_name ='DEC-13'
and invoice_id='182631'
select rowid,xe.*
from xla_events xe
where event_id in (select accounting_event_id
from ap_invoice_distributions_all
where line_type_lookup_code ='PREPAY'
--and period_name ='DEC-13'
and invoice_id='197230')
select *
from xla_events
where event_id in('3919159')
select *
from ap_invoice_distributions_all
where accounting_event_id ='3919159'
select rowid,aida.*
from ap_prepay_history_all aida
where invoice_id='182631'
select rowid,aida.*
from ap_prepay_history_all aida
where invoice_id='197230'
select *
from xla_events
where event_id
select *
from ap_invoice_distributions_all
where invoice_id =197230
and period_name='JAN-14'
and line_type_lookup_code='PREPAY'
select *
from ap_invoice_distributions_all
where 1=1
and invoice_id='219901'
--and invoice_id =197230
and period_name='JAN-14'
and line_type_lookup_code='PREPAY'