View: BIL_DIMV_TERRITORIES

Product:	BIL - Sales Intelligence
Description:	Sales territories view
Implementation/DBA Data:	APPS.BIL_DIMV_TERRITORIES

View Text

SELECT JTA.TERR_ID
, JTA.NAME
, JTA.TERRITORY_TYPE_ID
, JTA.START_DATE_ACTIVE
, JTA.END_DATE_ACTIVE
, JTA.ENABLED_FLAG
, JTA.ORG_ID
, TO_CHAR(JTA.TERR_ID) ID
, SUBSTR(JTA.NAME
, 1
, 80) VALUE
FROM JTF_TERR_ALL JTA UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) TERRITORY_PK
, FL.MEANING NAME
, TO_NUMBER(FL.LOOKUP_CODE) TERRITORY_TYPE_ID
, FL.START_DATE_ACTIVE START_DATE_ACTIVE
, FL.END_DATE_ACTIVE END_DATE_ACTIVE
, FL.ENABLED_FLAG ENABLED_FLAG
, TO_NUMBER(FL.LOOKUP_CODE) ORG_ID
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns