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: OKL.OKL_PROPERTY_TAX_ALL_B#

Source

View Text - Preformatted


select ID ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, KHR_ID KHR_ID, KLE_ID KLE_ID, ASSET_UNITS ASSET_UNITS, ASSET_ADDRESS_1 ASSET_ADDRESS_1, ASSET_ADDRESS_2 ASSET_ADDRESS_2, ASSET_ADDRESS_3 ASSET_ADDRESS_3, ASSET_ADDRESS_4 ASSET_ADDRESS_4, ASSET_CITY ASSET_CITY, ASSET_STATE ASSET_STATE, ASSET_COUNTRY ASSET_COUNTRY, TAX_ASSESSMENT_AMOUNT TAX_ASSESSMENT_AMOUNT, TAX_JURISDICTION_CITY TAX_JURISDICTION_CITY, TAX_JURISDICTION_CITY_RATE TAX_JURISDICTION_CITY_RATE, TAX_JURISDICTION_COUNTY TAX_JURISDICTION_COUNTY, TAX_JURISDICTION_COUNTY_RATE TAX_JURISDICTION_COUNTY_RATE, TAX_JURISDICTION_STATE TAX_JURISDICTION_STATE, TAX_JURISDICTION_STATE_RATE TAX_JURISDICTION_STATE_RATE, TAX_JURISDICTION_SCHOOL TAX_JURISDICTION_SCHOOL, TAX_JURISDICTION_SCHOOL_RATE TAX_JURISDICTION_SCHOOL_RATE, TAX_JURISDICTION_COUNTRY TAX_JURISDICTION_COUNTRY, TAX_JURISDICTION_COUNTRY_RATE TAX_JURISDICTION_COUNTRY_RATE, TAX_ASSESSMENT_DATE TAX_ASSESSMENT_DATE, MILRATE MILRATE, PROPERTY_TAX_AMOUNT PROPERTY_TAX_AMOUNT, OEC OEC, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CONTRACT_NUMBER CONTRACT_NUMBER, STY_NAME STY_NAME, STY_ID STY_ID, INVOICE_DATE INVOICE_DATE, AMOUNT AMOUNT, ORG_ID ORG_ID, JURSDCTN_TYPE JURSDCTN_TYPE, JURSDCTN_NAME JURSDCTN_NAME, MLRT_TAX MLRT_TAX, TAX_VENDOR_ID TAX_VENDOR_ID, TAX_VENDOR_NAME TAX_VENDOR_NAME, TAX_VENDOR_SITE_ID TAX_VENDOR_SITE_ID, TAX_VENDOR_SITE_NAME TAX_VENDOR_SITE_NAME from "OKL"."OKL_PROPERTY_TAX_ALL_B"

View Text - HTML Formatted

SELECT ID ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, KHR_ID KHR_ID
, KLE_ID KLE_ID
, ASSET_UNITS ASSET_UNITS
, ASSET_ADDRESS_1 ASSET_ADDRESS_1
, ASSET_ADDRESS_2 ASSET_ADDRESS_2
, ASSET_ADDRESS_3 ASSET_ADDRESS_3
, ASSET_ADDRESS_4 ASSET_ADDRESS_4
, ASSET_CITY ASSET_CITY
, ASSET_STATE ASSET_STATE
, ASSET_COUNTRY ASSET_COUNTRY
, TAX_ASSESSMENT_AMOUNT TAX_ASSESSMENT_AMOUNT
, TAX_JURISDICTION_CITY TAX_JURISDICTION_CITY
, TAX_JURISDICTION_CITY_RATE TAX_JURISDICTION_CITY_RATE
, TAX_JURISDICTION_COUNTY TAX_JURISDICTION_COUNTY
, TAX_JURISDICTION_COUNTY_RATE TAX_JURISDICTION_COUNTY_RATE
, TAX_JURISDICTION_STATE TAX_JURISDICTION_STATE
, TAX_JURISDICTION_STATE_RATE TAX_JURISDICTION_STATE_RATE
, TAX_JURISDICTION_SCHOOL TAX_JURISDICTION_SCHOOL
, TAX_JURISDICTION_SCHOOL_RATE TAX_JURISDICTION_SCHOOL_RATE
, TAX_JURISDICTION_COUNTRY TAX_JURISDICTION_COUNTRY
, TAX_JURISDICTION_COUNTRY_RATE TAX_JURISDICTION_COUNTRY_RATE
, TAX_ASSESSMENT_DATE TAX_ASSESSMENT_DATE
, MILRATE MILRATE
, PROPERTY_TAX_AMOUNT PROPERTY_TAX_AMOUNT
, OEC OEC
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CONTRACT_NUMBER CONTRACT_NUMBER
, STY_NAME STY_NAME
, STY_ID STY_ID
, INVOICE_DATE INVOICE_DATE
, AMOUNT AMOUNT
, ORG_ID ORG_ID
, JURSDCTN_TYPE JURSDCTN_TYPE
, JURSDCTN_NAME JURSDCTN_NAME
, MLRT_TAX MLRT_TAX
, TAX_VENDOR_ID TAX_VENDOR_ID
, TAX_VENDOR_NAME TAX_VENDOR_NAME
, TAX_VENDOR_SITE_ID TAX_VENDOR_SITE_ID
, TAX_VENDOR_SITE_NAME TAX_VENDOR_SITE_NAME
FROM "OKL"."OKL_PROPERTY_TAX_ALL_B"