Lov's in Oracle forms using Template.fmb
665451Apr 30 2009 — edited Apr 30 2009Hi All,
I want to create LOV's in the form which I'm developing.
I have to display the LOV based on the type of location.
If location_type = 'ORG' then I have to use sql 1 and display those values in the business name field.
If location_type = 'Customer' then I have to use sql 2 and display those values in the business name field.
If location_type = 'Supplier' then I have to use sql 3 and display those values in the business name field.
Please Advice.
Thanks in Advance.
-Satish