Answer Posted / bharath

1.SELECT ROWID FROM TABLE T1
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM TABLE T2 WHERE T1.KEY=T2.KEY);

THIS QUERY IS USEFUL WHEN WE HAVE A KEY VAL.
2.
i.CREATE TABLE NEW AS SELECT DISTINCT * FROM OLD;
ii.DROP TABLE OLD;
iii.RENAME NEW TO ORIGINAL;
THIS IS WHEN WE APPLY TO DELETE DUPLICATE ROWS..

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.

2976

---

Which oracle apps version you are very confident in?

1178

---

Can we create tables in apps schema?

1086

---

Tell me how to find the custom directory in front end?

1057

---

How to create a purchase order without a requisition?

1127

---

Is soa a part of oracle fusion middleware?

1040

---

What do you understand by soa?

1102

---

What do you understand by a set of books?

1045

---

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

1037

---

what is global tempory table?

7129

---

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

2164

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2044

---

Tell me where we find the status of order information?

1102

---

Can you define an erp system?

1094

---

testing tools?

2179

---