Need to build the query for incremental data for future
Posted on 2007-11-16
Here i want to write a query for my business requirement where...
Suppose for this week i have 10 records after executing a query say.
select * from mtl_system_items_b where organization_id=102;
Later i put these 10 records in excel format so that this data may be exported into other system.
For the next week... some more say 20 records have been added after executing the same previous query...
So , I need to develope one more query which will give the incremental data i.e. any update/additions in ITEMS records that happen in future.
Please help me out in building this query.
Thanks & Regards,