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_PROPERTY_TAX_V

Product:	OKL - Lease and Finance Management
Description:	Property tax Info for asset for which lease contract is signed
Implementation/DBA Data:	APPS.OKL_PROPERTY_TAX_V

View Text

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')

Columns

Name
ROW_ID
ID
JURSDCTN_TYPE
SEQUENCE_NUMBER
JURSDCTN_NAME
MLRT_TAX
ASSET_ID
TAX_VENDOR_ID
ASSET_NUMBER
TAX_VENDOR_NAME
CONTRACT_NUMBER
TAX_VENDOR_SITE_ID
STY_NAME
TAX_VENDOR_SITE_NAME
STY_ID
INVOICE_DATE
AMOUNT
ORG_ID
ASSET_DESCRIPTION
KHR_ID
KLE_ID
ASSET_UNITS
LANGUAGE
SOURCE_LANG
SFWT_FLAG
ASSET_ADDRESS_1
ASSET_ADDRESS_2
ASSET_ADDRESS_3
ASSET_ADDRESS_4
ASSET_CITY
ASSET_STATE
ASSET_COUNTRY
TAX_ASSESSMENT_AMOUNT
TAX_JURISDICTION_CITY
TAX_JURISDICTION_CITY_RATE
TAX_JURISDICTION_COUNTY
TAX_JURISDICTION_COUNTY_RATE
TAX_JURISDICTION_STATE
TAX_JURISDICTION_STATE_RATE
TAX_JURISDICTION_SCHOOL
TAX_JURISDICTION_SCHOOL_RATE
TAX_JURISDICTION_COUNTRY
TAX_JURISDICTION_COUNTRY_RATE
TAX_ASSESSMENT_DATE
MILRATE
PROPERTY_TAX_AMOUNT
OEC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN