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
原文：http://www.cnblogs.com/eastsea/p/3816796.html