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();
  }