Query need to be draw daily and cutoff by daily

Hello,

I have a query which I need to draw data and cutoff by daily,

which means the data i draw today will not reappear tomorrow when i draw again,

I am think of using a flag, maybe a procedure doing it, but I don't know th exact  way to do it, can anyone give me some advice?

like it can be done in discoverer, or a concurrent request can do it. thanks

select 

inv.TRX_NUMBER

,inv.CUSTOMER_NAME

,arc.TAX_REFERENCE

,arc.TAXPAYER_ID 

,ral.SALES_ORDER ||' '||ooh.CUST_PO_NUMBER invoice_reference

,mic.segment1 category