In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.

Answer Posted / vijaya

select * from aa,fnd_sessions ses
where ses.effective_date between aa.effective_start_date
and aa.effective_end_date

or

select * from aa
where sysdate between aa.effective_start_date and
aa.effective_end_date

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can a process be deployed in soa?

691


What is the concept of soa governance?

763


What does appl_top directory contain?

642


how do you describe O2C along with tables

2307


Do you know what are user profiles in apps. Any examples you can give?

652






do you know is it possible to run the interface without using oracle apps?

642


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1750


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1885


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2456


How can we import the data into a database using sql * loader?

676


Can you differentiate between mediator and osb?

621


What do you understand by a set of books?

641


How to create a purchase order without a requisition?

620


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3073


What do you understand by soa and what are the benefits of using this architecture?

617