DBA Data[Home] [Help]

APPS.PON_GEOGRAPHY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

     SELECT T.TERRITORY_CODE, T.ISO_NUMERIC_CODE, TL.TERRITORY_SHORT_NAME, TL.DESCRIPTION
     FROM   FND_TERRITORIES T, FND_TERRITORIES_TL TL
     WHERE  T.TERRITORY_CODE = TL.territory_code AND
     T.TERRITORY_CODE NOT IN ('ZR','FX','LX')
     AND    TL.LANGUAGE = p_theLanguage
     ORDER BY TL.TERRITORY_SHORT_NAME;