oracle.apps.fnd.applcore.trees.uiModel.util
Class FilterHierarchicalQuery

java.lang.Object
  oracle.apps.fnd.applcore.trees.uiModel.util.FilterHierarchicalQuery

public final class FilterHierarchicalQuery
extends java.lang.Object

Generates the sql query for any given hierarchichal operator based on active tree version.

Author:

Abhay K Kumar <abhay.k.kumar@oracle.com>

Method Summary

static java.lang.String	getMaterializedTVQuery(java.lang.String treeStructureCode, java.lang.String treeCode, java.lang.String treeVersionId, java.lang.String selectedVal, java.lang.String selectedOperator) Internal API to get the Filter Hierarchichal operator based query for any given operator type and hierarchy.
static java.lang.String	getQuery(java.lang.String treeStructureCode, java.lang.String treeCode, java.lang.String selectedVal, java.lang.String selectedOperator) Internal API to get the Filter Hierarchichal operator based query for any given operator type and hierarchy.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getMaterializedTVQuery

public static java.lang.String getMaterializedTVQuery(java.lang.String treeStructureCode,
                                                      java.lang.String treeCode,
                                                      java.lang.String treeVersionId,
                                                      java.lang.String selectedVal,
                                                      java.lang.String selectedOperator)

Internal API to get the Filter Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

treeVersionId - Tree Version Id of the hierarchy

selectedVal - selected value

selectedOperator - Hierarchy Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding

getQuery

public static java.lang.String getQuery(java.lang.String treeStructureCode,
                                        java.lang.String treeCode,
                                        java.lang.String selectedVal,
                                        java.lang.String selectedOperator)

Internal API to get the Filter Hierarchichal operator based query for any given operator type and hierarchy.

Parameters:

treeStructureCode - Tree Structure Code of the hierarchy

treeCode - Tree Code of the hierarchy

selectedVal - selected value

selectedOperator - Hierarchy Operator

Returns:

Generated sql string where default bind variable "segVal" is used for Value binding