select * from aa,fnd_sessions ses where ses.effective

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

Question Posted / vijaya

10 Answers
18324 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

Please Help Members By Posting Answers For Below Questions

Are you familiar with internet architecture of oracle apps 11i?

1035

Can you differentiate between mediator and osb?

1104

Plz anybody send me Technical specification for AP Interface

2522

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2591

What does appl_top directory contain?

1089

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2588

What are the benefits of using soa architecture?

1202

what is global tempory table?

7157

how to print multi lay outs,muti currency,muti language in xml publisher

12195

please send me forms, xml pulisher questions,answers

2087

Tell me how to debug the report?

1079

what is the differences between internal requisition and internal sales order?

2621

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1085

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.

3004

What are the different components you should consider while defining a responsibility in oracle apps?

1049