Search Results node_key




Overview
Explore in AI Chat

Overview

JTF_TERRITORIES_NAV is a VALID database view owned by the APPS schema within the JTF - CRM Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as a "View for UI Navigator - view by Territories," defining the navigator tree structure that maps territory parent-to-child hierarchies for display in the CRM user interface. Rather than presenting business data for transactional processing, the view functions as a metadata provider: it returns rows formatted specifically for the CRM Navigator's hierarchical tree widget, where each row represents a navigable node corresponding to a territory or a territory source.

The view is particularly relevant when users search for the node_type attribute, since NODE_TYPE and PARENT_NODE_TYPE are the columns that allow the Navigator framework to assemble parent/child relationships into a rendered tree. Although it is a UI-support object, it is frequently referenced in reporting and integration contexts where the territory hierarchy must be reconstructed or audited.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, JTF_TERRITORIES_NAV is defined over the following referenced base objects:

  • FND_GLOBAL (PACKAGE) — supplies session and context values (such as ORG_ID resolution) implicit in the view's runtime evaluation.
  • JTF_NAV_NODE_TYPES_V (VIEW) — supplies the NODE_TYPE and ICON_NAME attributes; the view restricts to NT.ROOT_KEY = 'JTF_TERR_ROOT' and NT.NODE_TYPE = 'TERRITORY'.
  • JTF_SOURCES (VIEW) — joined via JTF_TERR_USGS to link territories to the sources from which they originate.
  • JTF_TERR (SYNONYM) — the base territory definition, aliased JTALL and self-joined as JTALL2 to detect child territories.
  • JTF_TERR_USGS (SYNONYM) — the territory usage/assignment linkage that bridges JTF_TERR and JTF_SOURCES.

The view text consists of a UNION ALL of two branches: the first produces territory nodes whose parent is a real parent territory, and the second produces territory nodes whose parent is a SOURCE (PARENT_TERRITORY_ID = 1). Both branches filter out template territories (TEMPLATE_FLAG <> 'Y') and escalation territories (ESCALATION_TERRITORY_FLAG <> 'Y').

Key Columns

  • LABEL — the display name, constructed as the territory name concatenated with its rank, e.g., NAME || ' [' || RANK || ']'.
  • NODE_TYPE — the navigator node classification, sourced from JTF_NAV_NODE_TYPES_V and constrained to 'TERRITORY'.
  • NODE_KEY — the unique node identifier, formed by quoting TERR_ID.
  • ICON_NAME — the Navigator icon, 'TERRITOR' for leaf nodes and 'AFTREECL' for nodes with children.
  • LEAF_FLAG — 'Y' where no child territory exists, otherwise 'N'.
  • PARENT_NODE_TYPE — 'TERRITORY' or 'SOURCE' depending on the union branch.
  • PARENT_NODE_KEY — the quoted PARENT_TERRITORY_ID or SOURCE_ID linking to the parent node.
  • DISPLAY_RANK — the sort order used when rendering siblings.

Common Use Cases and Queries

Typical uses include charting the territory hierarchy, validating parent/child integrity, and driving custom dashboards. A basic query listing all reachable nodes:

SELECT node_type, node_key, label, parent_node_type, parent_node_key
FROM   apps.jtf_territories_nav
ORDER  BY display_rank;

To isolate leaf territories only:

SELECT node_key, label
FROM   apps.jtf_territories_nav
WHERE  leaf_flag = 'Y';

To locate all children of a given parent node key:

SELECT label, node_type
FROM   apps.jtf_territories_nav
WHERE  parent_node_key = '"'||:p_terr_id||'"';

Because node keys are stored with embedded quotes, callers must match that literal format when filtering. The view respects security through its dependency on FND_GLOBAL context, so results are appropriately scoped for the executing session.

  • View: JTF_TERRITORIES_NAV 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERRITORIES_NAV,  object_name:JTF_TERRITORIES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Territories - Defines navigator tree structure for territory parent to child hierarchy. ,  implementation_dba_data: APPS.JTF_TERRITORIES_NAV , 

  • View: JTF_TERRITORIES_NAV 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERRITORIES_NAV,  object_name:JTF_TERRITORIES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Territories - Defines navigator tree structure for territory parent to child hierarchy. ,  implementation_dba_data: APPS.JTF_TERRITORIES_NAV , 

  • View: JTF_TERR_TYPES_NAV 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_TYPES_NAV,  object_name:JTF_TERR_TYPES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Territory Types - Defines navigator tree structure for type to territory hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_TYPES_NAV , 

  • View: JTF_TERR_TYPES_NAV 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_TYPES_NAV,  object_name:JTF_TERR_TYPES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Territory Types - Defines navigator tree structure for type to territory hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_TYPES_NAV , 

  • View: JTF_TERR_TEMPLATES_NAV 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_TEMPLATES_NAV,  object_name:JTF_TERR_TEMPLATES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Templates - Defines navigator tree structure for territory template to created territory hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_TEMPLATES_NAV , 

  • View: JTF_TERR_ESCALATIONS_NAV 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_ESCALATIONS_NAV,  object_name:JTF_TERR_ESCALATIONS_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Escalations - Defines navigator tree structure for territory escalations escalating hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_ESCALATIONS_NAV , 

  • View: JTF_TERR_TEMPLATES_NAV 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_TEMPLATES_NAV,  object_name:JTF_TERR_TEMPLATES_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Templates - Defines navigator tree structure for territory template to created territory hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_TEMPLATES_NAV , 

  • View: JTF_TERR_ESCALATIONS_NAV 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_TERR_ESCALATIONS_NAV,  object_name:JTF_TERR_ESCALATIONS_NAV,  status:VALID,  product: JTF - CRM Foundation ,  description: View for UI Navigator - view by Escalations - Defines navigator tree structure for territory escalations escalating hierarchy. ,  implementation_dba_data: APPS.JTF_TERR_ESCALATIONS_NAV ,