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_OR_ASSET_INFO_UV

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CLEV_FIN_ID	NUMBER		Yes	System generated unique identifier. Primary key column of the table.
DNZ_CHR_ID	NUMBER		Yes	Contract ID. Denormalized for performance.
EXCEPTION_YN	VARCHAR2	(3)	Yes	It indicates the lines that are de-selected from a set of lines comming under the same parent.
ASSET_NUMBER	VARCHAR2	(150)		Item name.
ITEM_DESCRIPTION	VARCHAR2	(1995)		Item description.
RESIDUAL_PERCENTAGE	NUMBER	(5)		The percentage of original equipment cost to be used for residual value
PRESCRIBED_ASSET_YN	VARCHAR2	(3)		Indicates wheter asset is a prescribed asset or not
RESIDUAL_VALUE	NUMBER	(20)		Residual value
RE_LEASE_YN	VARCHAR2	(3)		Indicates whether asset is a re-leased asset or not
PREVIOUS_CONTRACT	VARCHAR2	(40)		Previous Lessors Contract Number
RESIDUAL_GRNTY_AMOUNT	NUMBER	(14)		Residual guaranty amount
RESIDUAL_CODE	VARCHAR2	(30)		Residual code
RVI_PREMIUM	NUMBER	(14)		RVI Premium
DATE_DELIVERY_EXPECTED	DATE			Date on which delivery of asset is expected
DATE_FUNDING_EXPECTED	DATE			Date on which funding is expected
EXPECTED_ASSET_COST	NUMBER			Expected Asset Cost
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive flexfield category column
ATTRIBUTE1	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE2	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE3	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE4	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE5	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE6	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE7	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE8	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE9	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE10	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE11	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE12	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE13	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE14	VARCHAR2	(450)		Descriptive flexfield column
ATTRIBUTE15	VARCHAR2	(450)		Descriptive flexfield column
CLEV_MODEL_ID	VARCHAR2	(0)		Placeholder for Model line Identifier
INVENTORY_ITEM_ID	VARCHAR2	(0)		Placeholder for Inventory Item Identifier
INVENTORY_ORG_ID	VARCHAR2	(0)		Placeholder for Inventory Organization Identifier
NUMBER_OF_ITEMS	VARCHAR2	(0)		Placeholder for Number of items
PRICE_UNIT	VARCHAR2	(0)		Placeholder for Unit cost
INVENTORY_ITEM_NAME	VARCHAR2	(0)		Placeholder for Inventory item name
CLEV_FA_ID	VARCHAR2	(0)		Placeholder for Fixed Asset Line Identifier
MODEL_NUMBER	VARCHAR2	(0)		Placeholder for Model number
YEAR_BUILT	VARCHAR2	(0)		Place holder for Year of Manufacture
FA_LOCATION_ID	VARCHAR2	(0)		Placeholder for Fixed Asset Location Identifier
FA_LOCATION_NAME	VARCHAR2	(0)		Placeholder for Fixed Asset Location name
MANUFACTURER_NAME	VARCHAR2	(0)		Placeholder for Manufacturer name
ASSET_KEY_ID	VARCHAR2	(0)		Placeholder for Asset Key Identifier
ASSET_KEY_NAME	VARCHAR2	(0)		Placeholder for Asset Key name
CLEV_IB_ID	VARCHAR2	(0)		Placeholder for Install Base Item Line Identifier
PARTY_SITE_USE_ID	VARCHAR2	(0)		Placeholder for Install Base Location Identifier
PARTY_SITE_NAME	VARCHAR2	(0)		Placeholder for Install Base Location name
ASSET_ID	VARCHAR2	(0)		Asset Identifier

Query Text

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


SELECT CLEV_FIN_ID
,      DNZ_CHR_ID
,      EXCEPTION_YN
,      ASSET_NUMBER
,      ITEM_DESCRIPTION
,      RESIDUAL_PERCENTAGE
,      PRESCRIBED_ASSET_YN
,      RESIDUAL_VALUE
,      RE_LEASE_YN
,      PREVIOUS_CONTRACT
,      RESIDUAL_GRNTY_AMOUNT
,      RESIDUAL_CODE
,      RVI_PREMIUM
,      DATE_DELIVERY_EXPECTED
,      DATE_FUNDING_EXPECTED
,      EXPECTED_ASSET_COST
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLEV_MODEL_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      NUMBER_OF_ITEMS
,      PRICE_UNIT
,      INVENTORY_ITEM_NAME
,      CLEV_FA_ID
,      MODEL_NUMBER
,      YEAR_BUILT
,      FA_LOCATION_ID
,      FA_LOCATION_NAME
,      MANUFACTURER_NAME
,      ASSET_KEY_ID
,      ASSET_KEY_NAME
,      CLEV_IB_ID
,      PARTY_SITE_USE_ID
,      PARTY_SITE_NAME
,      ASSET_ID
FROM APPS.OKL_OR_ASSET_INFO_UV;

Dependencies

[top of page]

APPS.OKL_OR_ASSET_INFO_UV references the following:

APPS: OKC_K_LINES_B; OKC_K_LINES_TL; OKL_K_LINES

APPS.OKL_OR_ASSET_INFO_UV is not referenced by any database object