In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
- 10 Answers
- 16052 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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
can we use look up type instead of a pofile option?or valueset?is it possible how?
How can a process be deployed in soa?
What is count(*) from po_vendors(any table)?
what are the different transaction clauses in AR?
List the types of flexfield?
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
What are the Standard Reports and Forms in HRMS?
In sequence i want to 11 and 15th values how we will write?
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.
What are the different components you should consider while defining a responsibility in oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
What are do's and dont's of Interface?
What is the concept of soa governance?
Do you know what is applysys in oracle application database schema, what is apps?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
