VIEW: APPS.OKL_PROPERTY_TAX_V

Source

View Text - Preformatted

SELECT PTC.ROWID ROW_ID, PTC.ID ID, PTC.JURSDCTN_TYPE JURSDCTN_TYPE, PTC.SEQUENCE_NUMBER SEQUENCE_NUMBER, PTC.JURSDCTN_NAME JURSDCTN_NAME, PTC.MLRT_TAX MLRT_TAX, PTC.ASSET_ID ASSET_ID, PTC.TAX_VENDOR_ID TAX_VENDOR_ID, PTC.ASSET_NUMBER ASSET_NUMBER, PTC.TAX_VENDOR_NAME TAX_VENDOR_NAME, PTC.CONTRACT_NUMBER, PTC.TAX_VENDOR_SITE_ID TAX_VENDOR_SITE_ID, PTC.STY_NAME, PTC.TAX_VENDOR_SITE_NAME TAX_VENDOR_SITE_NAME, PTC.STY_ID, PTC.INVOICE_DATE, PTC.AMOUNT, PTC.ORG_ID, PTCT.ASSET_DESCRIPTION ASSET_DESCRIPTION, PTC.KHR_ID KHR_ID, PTC.KLE_ID KLE_ID, PTC.ASSET_UNITS ASSET_UNITS, PTCT.LANGUAGE LANGUAGE, PTCT.SOURCE_LANG SOURCE_LANG, PTCT.SFWT_FLAG SFWT_FLAG, PTC.ASSET_ADDRESS_1 ASSET_ADDRESS_1, PTC.ASSET_ADDRESS_2 ASSET_ADDRESS_2, PTC.ASSET_ADDRESS_3 ASSET_ADDRESS_3, PTC.ASSET_ADDRESS_4 ASSET_ADDRESS_4, PTC.ASSET_CITY ASSET_CITY, PTC.ASSET_STATE ASSET_STATE, PTC.ASSET_COUNTRY ASSET_COUNRY, PTC.TAX_ASSESSMENT_AMOUNT TAX_ASSESSMENT_AMOUNT, PTC.TAX_JURISDICTION_CITY TAX_JURISDICTION_CITY, PTC.TAX_JURISDICTION_CITY_RATE TAX_JURISDICTION_CITY_RATE, PTC.TAX_JURISDICTION_COUNTY TAX_JURISDICTION_COUNTY, PTC.TAX_JURISDICTION_COUNTY_RATE TAX_JURISDICTION_COUNTY_RATE, PTC.TAX_JURISDICTION_STATE TAX_JURISDICTION_STATE, PTC.TAX_JURISDICTION_STATE_RATE TAX_JURISDICTION_STATE_RATE, PTC.TAX_JURISDICTION_SCHOOL TAX_JURISDICTION_SCHOOL, PTC.TAX_JURISDICTION_SCHOOL_RATE TAX_JURISDICTION_SCHOOL_RATE, PTC.TAX_JURISDICTION_COUNTRY TAX_JURISDICTION_COUNTRY, PTC.TAX_JURISDICTION_COUNTRY_RATE TAX_JURISDICTION_COUNTRY_RATE, PTC.TAX_ASSESSMENT_DATE TAX_ASSESSMENT_DATE, PTC.MILRATE MILRATE, PTC.PROPERTY_TAX_AMOUNT PROPERTY_TAX_AMOUNT, PTC.OEC,PTC.CREATED_BY CREATED_BY, PTC.CREATION_DATE CREATION_DATE, PTC.LAST_UPDATED_BY LAST_UPDATED_BY, PTC.LAST_UPDATE_DATE LAST_UPDATE_DATE, PTC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_PROPERTY_TAX_B PTC,OKL_PROPERTY_TAX_TL PTCT WHERE PTC.ID = PTCT.ID AND PTCT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT PTC.ROWID ROW_ID
, PTC.ID ID
, PTC.JURSDCTN_TYPE JURSDCTN_TYPE
, PTC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PTC.JURSDCTN_NAME JURSDCTN_NAME
, PTC.MLRT_TAX MLRT_TAX
, PTC.ASSET_ID ASSET_ID
, PTC.TAX_VENDOR_ID TAX_VENDOR_ID
, PTC.ASSET_NUMBER ASSET_NUMBER
, PTC.TAX_VENDOR_NAME TAX_VENDOR_NAME
, PTC.CONTRACT_NUMBER
, PTC.TAX_VENDOR_SITE_ID TAX_VENDOR_SITE_ID
, PTC.STY_NAME
, PTC.TAX_VENDOR_SITE_NAME TAX_VENDOR_SITE_NAME
, PTC.STY_ID
, PTC.INVOICE_DATE
, PTC.AMOUNT
, PTC.ORG_ID
, PTCT.ASSET_DESCRIPTION ASSET_DESCRIPTION
, PTC.KHR_ID KHR_ID
, PTC.KLE_ID KLE_ID
, PTC.ASSET_UNITS ASSET_UNITS
, PTCT.LANGUAGE LANGUAGE
, PTCT.SOURCE_LANG SOURCE_LANG
, PTCT.SFWT_FLAG SFWT_FLAG
, PTC.ASSET_ADDRESS_1 ASSET_ADDRESS_1
, PTC.ASSET_ADDRESS_2 ASSET_ADDRESS_2
, PTC.ASSET_ADDRESS_3 ASSET_ADDRESS_3
, PTC.ASSET_ADDRESS_4 ASSET_ADDRESS_4
, PTC.ASSET_CITY ASSET_CITY
, PTC.ASSET_STATE ASSET_STATE
, PTC.ASSET_COUNTRY ASSET_COUNRY
, PTC.TAX_ASSESSMENT_AMOUNT TAX_ASSESSMENT_AMOUNT
, PTC.TAX_JURISDICTION_CITY TAX_JURISDICTION_CITY
, PTC.TAX_JURISDICTION_CITY_RATE TAX_JURISDICTION_CITY_RATE
, PTC.TAX_JURISDICTION_COUNTY TAX_JURISDICTION_COUNTY
, PTC.TAX_JURISDICTION_COUNTY_RATE TAX_JURISDICTION_COUNTY_RATE
, PTC.TAX_JURISDICTION_STATE TAX_JURISDICTION_STATE
, PTC.TAX_JURISDICTION_STATE_RATE TAX_JURISDICTION_STATE_RATE
, PTC.TAX_JURISDICTION_SCHOOL TAX_JURISDICTION_SCHOOL
, PTC.TAX_JURISDICTION_SCHOOL_RATE TAX_JURISDICTION_SCHOOL_RATE
, PTC.TAX_JURISDICTION_COUNTRY TAX_JURISDICTION_COUNTRY
, PTC.TAX_JURISDICTION_COUNTRY_RATE TAX_JURISDICTION_COUNTRY_RATE
, PTC.TAX_ASSESSMENT_DATE TAX_ASSESSMENT_DATE
, PTC.MILRATE MILRATE
, PTC.PROPERTY_TAX_AMOUNT PROPERTY_TAX_AMOUNT
, PTC.OEC
, PTC.CREATED_BY CREATED_BY
, PTC.CREATION_DATE CREATION_DATE
, PTC.LAST_UPDATED_BY LAST_UPDATED_BY
, PTC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_PROPERTY_TAX_B PTC
, OKL_PROPERTY_TAX_TL PTCT
WHERE PTC.ID = PTCT.ID
AND PTCT.LANGUAGE = USERENV('LANG')