select * from all_objects
where object_type = ‘TABLE‘
and object_name like ‘GL_JE%‘

select * from po_requisition_headers_all
where segment1 = ‘14304‘
and creation_date > trunc(sysdate)

select * from po_requisition_lines_all
where requisition_header_id = 181271

select * from po_req_distributions_all
where requisition_line_id = 208479


select * from po_headers_all
where segment1 = ‘6028‘
and creation_date > trunc(sysdate)

select * from po_lines_all
where po_header_id = 110386

select * from po_line_locations_all
where po_line_id = 173315

select * from po_distributions_all
where line_location_id = 264461
and req_distribution_id = 206998


select * from rcv_shipment_headers
where receipt_num = 8458
and creation_date > trunc(sysdate)

select * from rcv_shipment_lines
where shipment_header_id = 4815907
and creation_date > trunc(sysdate)

select * from mtl_material_transactions
where creation_date > trunc(sysdate)

select status from ap_invoices_interface
where creation_date > trunc(sysdate)

select * from ap_invoice_lines_interface
where invoice_id = 2283731
creation_date > trunc(sysdate)

select * from ap_invoices_all
where creation_date > trunc(sysdate)

select * from ap_invoice_lines_all
where invoice_id = 211380

select * from ap_invoice_distributions_all
where invoice_id = 211380

select * from ap_payment_schedules_all
where invoice_id = 211380

select * from ap_checks_all
where creation_date > trunc(sysdate)

select * from ap_invoice_payments_all
where check_id = 77570
creation_date > trunc(sysdate-10)

select * from ap_payment_distributions_all
where creation_date > trunc(sysdate-1)


select * from xla_events
where event_id = 3322714

select * from xla_transaction_entities
where creation_date > trunc(sysdate-1)

select * from xla_ae_headers
where event_id = 3322714

select * from xla_ae_lines
where ae_header_id = 4947978

select * from xla_distribution_links
where ae_header_id = 4947978


select * from gl_interface
where accounting_date > trunc(sysdate-90)

select count(*) from gl_import_references
where creation_date > trunc(sysdate)
and je_header_id in (4681155, 4681156)

select * from gl_je_headers
where creation_date > trunc(sysdate)
and je_header_id in (4681155, 4681156)

select * from gl_je_lines
where creation_date > trunc(sysdate)
and  je_header_id in (4681155, 4681156)

http://blog.csdn.net/pan_tian/article/details/7770412/


http://zhangzhongjie.iteye.com/blog/1977931


http://blog.chinaunix.net/uid-324202-id-3413901.html