VIEW: OSM.AS_TERRITORY_VALUES_ALL#

Source

View Text - Preformatted

select TERRITORY_VALUE_ID TERRITORY_VALUE_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, TERRITORY_ID TERRITORY_ID, SEEDED_QUALIFIER_ID SEEDED_QUALIFIER_ID, LOW_VALUE_CHAR LOW_VALUE_CHAR, HIGH_VALUE_CHAR HIGH_VALUE_CHAR, LOW_VALUE_NUMBER LOW_VALUE_NUMBER, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER, ROLLUP_TERRITORY_ID ROLLUP_TERRITORY_ID, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, STATE_PROVINCE_CODE STATE_PROVINCE_CODE, COUNTRY COUNTRY, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, MATCH_CODE MATCH_CODE, ORG_ID ORG_ID, CURRENCY_CODE CURRENCY_CODE from "OSM"."AS_TERRITORY_VALUES_ALL"

View Text - HTML Formatted

SELECT TERRITORY_VALUE_ID TERRITORY_VALUE_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
, TERRITORY_ID TERRITORY_ID
, SEEDED_QUALIFIER_ID SEEDED_QUALIFIER_ID
, LOW_VALUE_CHAR LOW_VALUE_CHAR
, HIGH_VALUE_CHAR HIGH_VALUE_CHAR
, LOW_VALUE_NUMBER LOW_VALUE_NUMBER
, HIGH_VALUE_NUMBER HIGH_VALUE_NUMBER
, ROLLUP_TERRITORY_ID ROLLUP_TERRITORY_ID
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, STATE_PROVINCE_CODE STATE_PROVINCE_CODE
, COUNTRY COUNTRY
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, MATCH_CODE MATCH_CODE
, ORG_ID ORG_ID
, CURRENCY_CODE CURRENCY_CODE
FROM "OSM"."AS_TERRITORY_VALUES_ALL"