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')

How can you achieve loose coupling in soa framework?

1204

---

In support project one ticket alloted which steps follows manualy tell me ?

2651

---

what are the prerequisites for costing transactions?

3125

---

What are do's and dont's of Interface?

2405

---

What is a value set? List its various types.

1080

---

where to define interorganization transaction charges and what are the different options?

2408

---

Can u give the Documentation of Custom.pll in oracle apps

3457

---

is it possible to run the interface without using oracle apps?

1964

---

what is global tempory table?

7185

---

testing tools?

2223

---

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?

1057

---

What is instead of trigger in where we will use?

1155

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2243

---

Which oracle apps version you are very confident in?

1194

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2112

---