[Home] [Help]
View: 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
Name |
TERRITORY_PK |
NAME |
TERRITORY_TYPE_ID |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ENABLED_FLAG |
ORG_ID |
ID |
VALUE |