Answer Posted / viswa

view is one of the object, it is like as a table ,it will
created based on table,it has no data,using this we can
retrieve particular organization information

syntax
create view<view name> as select *from <table name> where
org_id=userenv('client_info')

Do you know what are user profiles in apps. Any examples you can give?

1040

---

Tell me where we find the status of order information?

1099

---

What is count(*) from po_vendors(any table)?

1034

---

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.

2974

---

Can we create tables in apps schema?

1082

---

In oracle application how do you debug or trace errors?

1052

---

How can you achieve loose coupling in soa framework?

1175

---

How can we import the data into a database using sql * loader?

1122

---

tell me the scenarios of the independent in reports

2564

---

Do you know what is applysys in oracle application database schema, what is apps?

1135

---

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

2171

---

How to move the one file from one instance to another instance? And your scripts also?

1067

---

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

1063

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2007

---

Tell me how to debug the report?

1065

---