View: BIS_REGIONS_V

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

View Text

SELECT DISTINCT DECODE(C.AREA_CODE||C.COUNTRY_CODE
, NULL
, BTR.TERRITORY_CODE
, C.COUNTRY_CODE
, C.COUNTRY_CODE||'+'||BTR.TERRITORY_CODE
, C.AREA_CODE
, C.AREA_CODE||'+'||BTR.TERRITORY_CODE
, C.AREA_CODE||'+'||C.COUNTRY_CODE||'+'||BTR.TERRITORY_CODE) ID
, BTR.NAME VALUE
, BTR.TERRITORY_CODE REGION_CODE
, BTR.NAME NAME
, BTR.DESCRIPTION DESCRIPTION
, C.COUNTRY_CODE COUNTRY_CODE
, C.AREA_CODE AREA_CODE
FROM BIS_TERRITORY_HIERARCHIES_V TH
, BIS_COUNTRIES_V C
, BIS_TERRITORIES_V BTR
WHERE BTR.TYPE ='REGION'
AND BTR.TERRITORY_CODE = TH.CHILD_TERRITORY_CODE(+)
AND C.COUNTRY_CODE(+) = TH.PARENT_TERRITORY_CODE

Columns