eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIS_COUNTRIES_V

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

View Text

SELECT DISTINCT DECODE(BTA.AREA_CODE||BTC.TERRITORY_CODE
, BTC.TERRITORY_CODE
, BTC.TERRITORY_CODE
, BTA.AREA_CODE||'+'||BTC.TERRITORY_CODE) ID
, BTC.NAME VALUE
, BTC.TERRITORY_CODE COUNTRY_CODE
, BTC.NAME NAME
, BTC.DESCRIPTION DESCRIPTION
, BTA.AREA_CODE AREA_CODE
FROM BIS_TERRITORIES_V BTC
, BIS_AREAS_V BTA
, BIS_TERRITORY_HIERARCHIES_V BTH
WHERE BTC.TYPE = 'COUNTRY'
AND BTC.TERRITORY_CODE = BTH.CHILD_TERRITORY_CODE(+)
AND BTA.AREA_CODE(+) = BTH.PARENT_TERRITORY_CODE

Columns

Name
ID
VALUE
COUNTRY_CODE
NAME
DESCRIPTION
AREA_CODE