VIEW: APPS.BIL_DIMV_TERRITORIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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