Creation of dependent pick list or poplist

 Creation fo dependent pick list or poplist

D:\oracle\visappl\fnd\11.5.0\secure\myprojects





]
Creation of BC4J







Creation of AM



Next next

Finish it



Save it and create page






Rebuild page
Run it



Creation of vo


Write  query





Create another vo for polines


select po_header_id,
       po_line_id,
       line_num
       from po_lines_all





Creation of pick list by using items


dependenPick.oracle.apps.po.mgmt.picklist.server.poheadersVO



dependenPick.oracle.apps.po.mgmt.picklist.server.polinesVO











Creation of new controller







Attach vo to am only polinevo



Go to controller.java and write the following code

import dependenPick.oracle.apps.po.mgmt.picklist.server.dependentpickAMImpl;

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
 {
   super.processFormRequest(pageContext, webBean);
   dependentpickAMImpl obj=(dependentpickAMImpl) pageContext.getApplicationModule(webBean);
   
   if("POLineidevent".equals(pageContext.getParameter(EVENT_PARAM)))
   {
     System.out.println("SAmple");
     
     String pohid=pageContext.getParameter("poheader");
     System.out.println("poheaderid"+pohid);
     obj.XXHndleLines(pohid);      
   }
 }


And writge the code in the AM class file


public void XXHndleLines(String pohid)
 {
   polinesVOImpl vos=getpolinesVO();
   vos.setWhereClause("po_header_id='"+pohid+"'");
   vos.executeQuery();
 }

Change the some properties for dependent lov where when 1st val changes then automatically changes the 2nd value

In poheaders item the following properties are final modifications










Similarly in the polines also



Save it and run the page







Here we can create some defaultdouble region and develop the items below





Creation of items like poheader and poline under region of defaultdouble column