View: BIL_DIMV_TERR_HIER

Product:	BIL - Sales Intelligence
Description:	Sales territory hiearchy view
Implementation/DBA Data:	APPS.BIL_DIMV_TERR_HIER

View Text

SELECT JTD.TERR_ID
, JTD.PARENT_TERR_ID
, JTD.IMMEDIATE_PARENT_FLAG
FROM JTF_TERR_DENORM JTD UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) TERR_ID
, TO_NUMBER(FL.LOOKUP_CODE) PARENT_TERR_ID
, 'N' IMMEDIATE_PARENT_FLAG
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns