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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKL_PROPERTY_TAX_V

Object Details

Object Name:	OKL_PROPERTY_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_PROPERTY_TAX_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Property Tax Info for asset for which Lease contract is signed

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier in the database
ID	NUMBER		Yes	Primary key column
JURSDCTN_TYPE	VARCHAR2	(150)		Jurisdiction Type.
SEQUENCE_NUMBER	NUMBER			Sequence number
JURSDCTN_NAME	VARCHAR2	(150)		Jurisdiction Name.
MLRT_TAX	NUMBER			MLRT Tax
ASSET_ID	NUMBER			Asset identifier
TAX_VENDOR_ID	NUMBER			Tax Vendor Identifier.
ASSET_NUMBER	VARCHAR2	(30)		Asset number
TAX_VENDOR_NAME	VARCHAR2	(150)		Tax Vendor Name.
CONTRACT_NUMBER	VARCHAR2	(240)		Contract Number
TAX_VENDOR_SITE_ID	NUMBER			Tax Vendor Site Identifier.
STY_NAME	VARCHAR2	(150)		Stream Type Name
TAX_VENDOR_SITE_NAME	VARCHAR2	(150)		Tax Vendor Site Name.
STY_ID	NUMBER		Yes	Stream Type ID
INVOICE_DATE	DATE		Yes	Invoice Date
AMOUNT	NUMBER			Amount
ORG_ID	NUMBER			Operating Unit Identifier.
ASSET_DESCRIPTION	VARCHAR2	(240)		Asset description
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
ASSET_UNITS	NUMBER			Number of units of asset
LANGUAGE	VARCHAR2	(12)	Yes	Language column
SOURCE_LANG	VARCHAR2	(12)	Yes	Source Language column
SFWT_FLAG	VARCHAR2	(3)	Yes	Column used by the translation batch program
ASSET_ADDRESS_1	VARCHAR2	(250)		Address line 1
ASSET_ADDRESS_2	VARCHAR2	(250)		Address line 2
ASSET_ADDRESS_3	VARCHAR2	(250)		Address line 3
ASSET_ADDRESS_4	VARCHAR2	(250)		Address line 4
ASSET_CITY	VARCHAR2	(250)		City
ASSET_STATE	VARCHAR2	(250)		State
ASSET_COUNTRY	VARCHAR2	(250)		Country
TAX_ASSESSMENT_AMOUNT	NUMBER	(14)		Tax adjustment amount
TAX_JURISDICTION_CITY	VARCHAR2	(250)		Jurisdiction city
TAX_JURISDICTION_CITY_RATE	NUMBER	(5)		Jurisdiction city rate
TAX_JURISDICTION_COUNTY	VARCHAR2	(250)		Jurisdiction county
TAX_JURISDICTION_COUNTY_RATE	NUMBER	(5)		Jurisdiction county rate
TAX_JURISDICTION_STATE	VARCHAR2	(250)		Jurisdiction state
TAX_JURISDICTION_STATE_RATE	NUMBER	(5)		Jurisdiction state rate
TAX_JURISDICTION_SCHOOL	VARCHAR2	(250)		Jurisdiction school
TAX_JURISDICTION_SCHOOL_RATE	NUMBER	(5)		Jurisdiction school rate
TAX_JURISDICTION_COUNTRY	VARCHAR2	(250)		Jurisdiction country
TAX_JURISDICTION_COUNTRY_RATE	NUMBER	(5)		Jurisdiction country rate
TAX_ASSESSMENT_DATE	DATE			Tax assessment rate
MILRATE	NUMBER	(5)		MIL Rate
PROPERTY_TAX_AMOUNT	NUMBER	(14)		Property tax Amount
OEC	NUMBER	(14)		Original equipment cost
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.OKL_PROPERTY_TAX_V;

Dependencies

[top of page]

APPS.OKL_PROPERTY_TAX_V references the following:

APPS: OKL_PROPERTY_TAX_B; OKL_PROPERTY_TAX_TL

APPS.OKL_PROPERTY_TAX_V is referenced by following:

APPS: OKL_PROPERTY_TAX_STATEMENT_PVT - show dependent code; OKL_PTC_PVT - show dependent code; OKL_PTC_PVT - show dependent code