While approving a purchase order when we click on Forward check box the forward to field becomes enabled and it has the LOV containing employee names and employee numbers. I want to add another column in this LOV for employee positions through form personalization.
Can any one guide me how to do this.
To set another LOV, you should change the property of your combobox, named LOV_NAME with Forms perso, but you need some PL SQL code to create a new LOV.
See this example : [http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/custom-lov-using-custompll-883870]
One pre-requisite is that your new LOV should have the same number of rows and the same datatype, so I'm afraid you won't be able to do this just using Forms perso