Answer Posted / vasu

Whenever you need to change the query value at runtime then
create a parameter which reads the value during run time.
In this scenario which you are creating the parameters are
known as user parameters.
eg: create a sql query as below:
select * from emp where deptno=:p_deptno

Then system creates a parameter named p_deptno. This bind
parameter is a user parameter.

Run the report, During run time system expect the deptno
value from the user.

I hope you understood.

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

1093

---

What do you understand by soa?

1156

---

what is global tempory table?

7208

---

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

1062

---

Explain what are the tables of auto invoice?

1140

---

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

1976

---

how can i print random rows in plsql table

2496

---

what is pay run id ?

2192

---

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

2218

---

q)what are the validations in sql*loader

2399

---

Can you differentiate between mediator and osb?

1138

---

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

2660

---

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

2260

---

Do you know where we can check the status of po?

1276

---

please send me forms, xml pulisher questions,answers

2107

---