Answer Posted / ratnakar

if u know updated date then following query will work

select * from emp where effecive_start_date = (select
sysdate from dual);


or

select * from emp where effective_start_date = (select
to_date(dateof update,'dd-mon-yy') from dual);

Tell me how to debug the report?

1175

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2268

---

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

12400

---

testing tools?

2304

---

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

1130

---

How many schemas we have? how many you have used?

2114

---

In hierarchical structure of a database? we have write query from where we should start?

2307

---

What is the concept of soa governance?

1321

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2438

---

q)what are the validations in sql*loader

2461

---

Plz anybody send me Technical specification for AP Interface

2619

---

How can you achieve loose coupling in soa framework?

1280

---

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

2711

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2674

---

Explain oracle apps architecture.

1304

---