VIEW: APPS.BIS_AREAS_V

Source

View Text - Preformatted

SELECT territory_code ID , name VALUE , territory_code AREA_CODE , name NAME , description DESCRIPTION from bis_territories_v WHERE type='AREA'

View Text - HTML Formatted

SELECT TERRITORY_CODE ID
, NAME VALUE
, TERRITORY_CODE AREA_CODE
, NAME NAME
, DESCRIPTION DESCRIPTION
FROM BIS_TERRITORIES_V
WHERE TYPE='AREA'