Anil's Blog is Best Viewed on GOOGLE CHROME

Tuesday, June 8, 2010

Advanced Table in Advanced Table via View Link

This article is contributed by my friend - Pranav Maheshwari. Thanks for his extended support.

In this article we are creating Advanced table in Advanced Table and show the details region data by creating View Link between these tables View Object.




Steps you need to follow.

1. Create a Advanded Table Region on page. We call it Main Table Region.





2. Right click on Table region and click on New -> detail. We call it detail region
3. This details table region will show those column which are not availabe intially when page renders.
4. Create a Application Module
5. Create a Controller.
5. Create Two View Object let say ParentVO and Child VO.
7. Create a View Link between these two view objects.
















8. Take an instance of View Object and View Link in Application Module



Things to remember
1. Both View Object must have one same Key Attribute. Like in our case it is Assignment Id.



2. Also create a Transient Attribute in MasterVO of Boolean Type. We name it DetailFlag.




In Main Table Region set the following property.

1. View Instance: ParentVO1
2. Details View Attribute: DetailFlag
3. Child View Attribute: AssignmentId
4. View Link Instance: MasterToDetailsVL1




In Details Table Region set the following property.

1. View Instance: ChildVO2
2. View Link Instance: MasterToDetailsVL1



Controller CODE:

import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import xx.oracle.apps.pa.tableaudit.server.MainApplicationAMImpl;;


public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    MainApplicationAMImpl AM=(MainApplicationAMImpl)pageContext.getApplicationModule(webBean);
    pageContext.writeDiagnostics(this, "Calling Method", 1);
    AM.AssignmentAuditDetails(pageContext,webBean);
  }


Application Module CODE:

import oracle.apps.fnd.framework.server.OAApplicationModuleImpl;
import oracle.jbo.server.ViewLinkImpl;
import oracle.apps.fnd.framework.server.OAApplicationModuleImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;

public void AssignmentAuditDetails(OAPageContext pageContext,OAWebBean webBean)
  {
    ParentVOImpl pvo = getParentVO1();
    pvo.executeQuery();
  }

11 comments:

  1. Can I add a LOV to advance table item?.If yes how?

    ReplyDelete
  2. Thank you! It helped me for one of the requirement where client wanted group by kind of layout for an Attribute.

    ReplyDelete
  3. thanks anil. its very good article.

    ReplyDelete
  4. Yes Yes Yes !!!!! Thank You !!

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. How to find out LOV ID in a OA Framework page

    ReplyDelete
  9. How to default few LOV columns based on another LOV. But not dependent LOVs

    ReplyDelete
  10. thanks anil nice article

    ReplyDelete

Note: Only a member of this blog may post a comment.