VIEW: APPS.BIS_COUNTRIES_V

Source

View Text - Preformatted

SELECT DISTINCT ftl.territory_code ID , ftl.TERRITORY_SHORT_NAME VALUE , ftl.territory_code COUNTRY_CODE , ftl.TERRITORY_SHORT_NAME NAME , ftl.description DESCRIPTION , fnl.lookup_code AREA_CODE from fnd_territories_tl ftl, fnd_lookups fnl, bis_territory_hierarchies bth WHERE ftl.territory_code = bth.CHILD_TERRITORY_CODE(+) and fnl.lookup_code(+) = bth.PARENT_TERRITORY_CODE and fnl.lookup_type(+) = 'AREA' and nvl(fnl.start_date_active,sysdate) <= sysdate and nvl(fnl.end_date_active, sysdate) >= sysdate and ftl.language=userenv('LANG')

View Text - HTML Formatted

SELECT DISTINCT FTL.TERRITORY_CODE ID
, FTL.TERRITORY_SHORT_NAME VALUE
, FTL.TERRITORY_CODE COUNTRY_CODE
, FTL.TERRITORY_SHORT_NAME NAME
, FTL.DESCRIPTION DESCRIPTION
, FNL.LOOKUP_CODE AREA_CODE
FROM FND_TERRITORIES_TL FTL
, FND_LOOKUPS FNL
, BIS_TERRITORY_HIERARCHIES BTH
WHERE FTL.TERRITORY_CODE = BTH.CHILD_TERRITORY_CODE(+)
AND FNL.LOOKUP_CODE(+) = BTH.PARENT_TERRITORY_CODE
AND FNL.LOOKUP_TYPE(+) = 'AREA'
AND NVL(FNL.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(FNL.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND FTL.LANGUAGE=USERENV('LANG')