Answer Posted / pranita kochar

In the ‘Object Navigator’ window, select the LOVs object known as "List of values."
Then click on the green ‘+’ (Create) icon. In the ‘New List Of Value’ window, leave the default radio button which is: ‘Use the LOV Wizard’ and the click ‘OK.’
LOVs get their data from Record Groups, which may be populated using SQL queries, or by entering a static list of values. In the LOV Wizard window, use the default to base your LOV on a new Record Group; and then click ‘Next.’
In the ‘SQL Query Statement’ box, write a ‘SQL’ statement to query customers name and their ID. Then click ‘Next.’
(SQL Query Statement)

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

1698

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2128

---

did u p prepared complex report

2004

---

What do you understand by oracle forms and why are they required?

1019

---

Explain how can you use the same lov for 2 columns?

1137

---

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2997

---

what is a package n what r the packages availbla in report

2101

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1453

---

What do you understand by oracle forms?

1047

---

from where do u receive the information to develop report

2012

---

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

1989

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2906

---

difference between global n context sensitive segments?

2678

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1303

---

What is the difference between flex mode and confined mode?

1055

---