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: AS_CHANGED_TERRITORIES

Product:	AS - Sales Foundation
Description:	Obsolete. Changed territories (multi-org)
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TERRITORY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DISABLE_FLAG
, TERRITORY_VALUE_ID
, SEEDED_QUALIFIER_ID
, OLD_VALUE_NUMBER1
, OLD_VALUE_NUMBER2
, OLD_VALUE_NUMBER3
, OLD_VALUE_LOW
, OLD_VALUE_HIGH
, TRANSFER_ONLY_FLAG
, TRANSFER_TO_SALESFORCE_ID
, ORG_ID
, CURRENCY_CODE
FROM AS_CHANGED_TERRITORIES_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
TERRITORY_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
DISABLE_FLAG
TERRITORY_VALUE_ID
SEEDED_QUALIFIER_ID
OLD_VALUE_NUMBER1
OLD_VALUE_NUMBER2
OLD_VALUE_NUMBER3
OLD_VALUE_LOW
OLD_VALUE_HIGH
TRANSFER_ONLY_FLAG
TRANSFER_TO_SALESFORCE_ID
ORG_ID
CURRENCY_CODE