View: BIS_TERRITORIES_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_TERRITORIES_V

View Text

SELECT LOOKUP_CODE TERRITORY_CODE
, MEANING NAME
, DESCRIPTION DESCRIPTION
, LOOKUP_TYPE TYPE
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE IN ('REGION'
, 'AREA')
AND NVL(START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE) > = SYSDATE UNION SELECT TERRITORY_CODE TERRITORY_CODE
, TERRITORY_SHORT_NAME TERRITORY_NAME
, DESCRIPTION TERRITORY_DESCRIPTION
, 'COUNTRY' TERRITORY_TYPE
FROM FND_TERRITORIES_VL

Columns