View: JTF_TERR_TEMPLATES_NAV

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 Text

SELECT S.MEANING LABEL
, NT.NODE_TYPE NODE_TYPE
, '"' || S.SOURCE_ID || '"' NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, NT.ROOT_KEY PARENT_NODE_KEY
FROM JTF_NAV_NODE_TYPES_V NT
, JTF_SOURCES S
, JTF_TERR T
WHERE NT.ROOT_KEY = 'JTF_TERR_TEMP_ROOT'
AND NT.NODE_TYPE = 'SOURCE'
AND T.TERR_ID = 1 UNION SELECT JTALL.NAME LABEL
, NT.NODE_TYPE NODE_TYPE
, '"' || JTALL.TERR_ID || '"' NODE_KEY
, NT.ICON_NAME ICON_NAME
, DECODE(COUNT(JTALL2.TEMPLATE_TERRITORY_ID)
, 0
, 'Y'
, 'N') LEAF_FLAG
, 'SOURCE' PARENT_NODE_TYPE
, '"' || JS.SOURCE_ID || '"' PARENT_NODE_KEY
FROM JTF_NAV_NODE_TYPES_V NT
, JTF_TERR JTALL
, JTF_TERR JTALL2
, JTF_SOURCES JS
, JTF_TERR_USGS JTU
WHERE NT.ROOT_KEY = 'JTF_TERR_TEMP_ROOT'
AND NT.NODE_TYPE = 'TEMPLATE'
AND JTALL.TEMPLATE_FLAG = 'Y'
AND JTALL.TERR_ID = JTALL2.TEMPLATE_TERRITORY_ID (+)
AND JTALL.TERR_ID = JTU.TERR_ID
AND JTU.SOURCE_ID = JS.SOURCE_ID GROUP BY JTALL.NAME
, JTALL.TERR_ID
, NT.NODE_TYPE
, NT.ICON_NAME
, NT.ROOT_KEY
, JS.SOURCE_ID UNION SELECT JTALL.NAME LABEL
, NT.NODE_TYPE NODE_TYPE
, '"' || JTALL.TERR_ID || '"' NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'Y' LEAF_FLAG
, 'TEMPLATE' PARENT_NODE_TYPE
, '"'|| JTALL.TEMPLATE_TERRITORY_ID ||'"'PARENT_NODE_KEY
FROM JTF_NAV_NODE_TYPES_V NT
, JTF_TERR JTALL
WHERE NT.ROOT_KEY = 'JTF_TERR_TEMP_ROOT'
AND NT.NODE_TYPE = 'TERRITORY'
AND JTALL.TEMPLATE_FLAG = 'N'
AND JTALL.TEMPLATE_TERRITORY_ID IS NOT NULL ORDER BY LABEL

Columns