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
Tell me where we find the status of order information?
How to move the one file from one instance to another instance? And your scripts also?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Can u give the Documentation of Custom.pll in oracle apps
Can you explain the difference between architecture followed in 10g & 11g?
How do you register report in oracle apps?
Which oracle apps version you are very confident in?
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
Can you define an erp system?
Tell me how to find the custom directory in front end?
What does appl_top directory contain?
how do you describe O2C along with tables
How can we import the data into a database using sql * loader?
What is a value set? List its various types.
do you know is it possible to run the interface without using oracle apps?