Answer / anil_abbireddy

1. list_values
2. show_lov('lov_name')

what is the difference between call_form, new_form and open_form?

0 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

can i write commit in Before report trigger

4 Answers  

---

if u want to delete all these detail block etc what will happen in form

0 Answers  

---

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

0 Answers  

---

What do you understand by lov and how can it be used?

0 Answers  

---

can u call procedure or function is sq l query in reports

1 Answers  

---

What is the maximum no of chars the parameter can store?

1 Answers  

---

What are the different default triggers created when Master Deletes Property is set to isolated?

1 Answers  

---

What is the use of break group?

1 Answers  

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

0 Answers  

---