SELECT TL.TERRITORY_CODE ID1, '#' ID2, TL.TERRITORY_SHORT_NAME NAME, TL.DESCRIPTION DESCRIPTION, B.ISO_NUMERIC_CODE ISO_NUMERIC_CODE, 'A' STATUS, SYSDATE START_DATE_ACTIVE, NULL END_DATE_ACTIVE, NULL PRIMARY_UOM_CODE FROM FND_TERRITORIES B,FND_TERRITORIES_TL TL WHERE B.TERRITORY_CODE = TL.TERRITORY_CODE AND TL.LANGUAGE = USERENV('LANG')
SELECT TL.TERRITORY_CODE ID1
, '#' ID2
, TL.TERRITORY_SHORT_NAME NAME
, TL.DESCRIPTION DESCRIPTION
, B.ISO_NUMERIC_CODE ISO_NUMERIC_CODE
, 'A' STATUS
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
, NULL PRIMARY_UOM_CODE
FROM FND_TERRITORIES B
, FND_TERRITORIES_TL TL
WHERE B.TERRITORY_CODE = TL.TERRITORY_CODE
AND TL.LANGUAGE = USERENV('LANG')
|
|
|