VIEW: APPS.BIS_TERRITORIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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