VIEW: OSM.AS_CHANGED_TERRITORIES_ALL#

Source

View Text - Preformatted

select TERRITORY_ID TERRITORY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DISABLE_FLAG DISABLE_FLAG, TERRITORY_VALUE_ID TERRITORY_VALUE_ID, SEEDED_QUALIFIER_ID SEEDED_QUALIFIER_ID, OLD_VALUE_NUMBER1 OLD_VALUE_NUMBER1, OLD_VALUE_NUMBER2 OLD_VALUE_NUMBER2, OLD_VALUE_NUMBER3 OLD_VALUE_NUMBER3, OLD_VALUE_LOW OLD_VALUE_LOW, OLD_VALUE_HIGH OLD_VALUE_HIGH, TRANSFER_ONLY_FLAG TRANSFER_ONLY_FLAG, TRANSFER_TO_SALESFORCE_ID TRANSFER_TO_SALESFORCE_ID, ORG_ID ORG_ID, CURRENCY_CODE CURRENCY_CODE from "OSM"."AS_CHANGED_TERRITORIES_ALL"

View Text - HTML Formatted

SELECT TERRITORY_ID TERRITORY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DISABLE_FLAG DISABLE_FLAG
, TERRITORY_VALUE_ID TERRITORY_VALUE_ID
, SEEDED_QUALIFIER_ID SEEDED_QUALIFIER_ID
, OLD_VALUE_NUMBER1 OLD_VALUE_NUMBER1
, OLD_VALUE_NUMBER2 OLD_VALUE_NUMBER2
, OLD_VALUE_NUMBER3 OLD_VALUE_NUMBER3
, OLD_VALUE_LOW OLD_VALUE_LOW
, OLD_VALUE_HIGH OLD_VALUE_HIGH
, TRANSFER_ONLY_FLAG TRANSFER_ONLY_FLAG
, TRANSFER_TO_SALESFORCE_ID TRANSFER_TO_SALESFORCE_ID
, ORG_ID ORG_ID
, CURRENCY_CODE CURRENCY_CODE
FROM "OSM"."AS_CHANGED_TERRITORIES_ALL"