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]

TABLE: OKL.OKL_PROPERTY_TAX_ALL_B

Object Details

Object Name:	OKL_PROPERTY_TAX_ALL_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_PROPERTY_TAX_ALL_B
Subobject Name:
Status:	VALID

Property tax Info for asset for which lease contract is signed

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_PROPERTY_TAX_ALL_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEQUENCE_NUMBER KLE_ID
OKL_PROPERTY_TAX_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KLE_ID
OKL_PROPERTY_TAX_ALL_B_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
SEQUENCE_NUMBER	NUMBER			Sequence number
ASSET_ID	NUMBER			Asset identifier
ASSET_NUMBER	VARCHAR2	(30)		Asset number
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 assets
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
CONTRACT_NUMBER	VARCHAR2	(240)		Contract Number
STY_NAME	VARCHAR2	(150)		Stream Type Name
STY_ID	NUMBER		Yes	Stream Type Id
INVOICE_DATE	DATE		Yes	Invoice Date
AMOUNT	NUMBER			Amount
ORG_ID	NUMBER			Operating Unit Identifier
JURSDCTN_TYPE	VARCHAR2	(150)		Jurisdiction Type
JURSDCTN_NAME	VARCHAR2	(150)		Jurisdiction Name.
MLRT_TAX	NUMBER			MLRT Tax.
TAX_VENDOR_ID	NUMBER			Tax Vendor Identification.
TAX_VENDOR_NAME	VARCHAR2	(150)		Tax Vendor Name.
TAX_VENDOR_SITE_ID	NUMBER			Tax Vendor Site Identification.
TAX_VENDOR_SITE_NAME	VARCHAR2	(150)		Tax Vendor Site Name.

Query Text

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


SELECT ID
,      SEQUENCE_NUMBER
,      ASSET_ID
,      ASSET_NUMBER
,      KHR_ID
,      KLE_ID
,      ASSET_UNITS
,      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
,      CONTRACT_NUMBER
,      STY_NAME
,      STY_ID
,      INVOICE_DATE
,      AMOUNT
,      ORG_ID
,      JURSDCTN_TYPE
,      JURSDCTN_NAME
,      MLRT_TAX
,      TAX_VENDOR_ID
,      TAX_VENDOR_NAME
,      TAX_VENDOR_SITE_ID
,      TAX_VENDOR_SITE_NAME
FROM OKL.OKL_PROPERTY_TAX_ALL_B;

Dependencies

[top of page]

OKL.OKL_PROPERTY_TAX_ALL_B does not reference any database object

OKL.OKL_PROPERTY_TAX_ALL_B is referenced by following:

OKL: OKL_PROPERTY_TAX_ALL_B#