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_AM_ASSET_RETURNS_UV

Object Details

Object Name:	OKL_AM_ASSET_RETURNS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_AM_ASSET_RETURNS_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
ASSET_NUMBER	VARCHAR2	(150)		Asset Number
ITEM_DESCRIPTION	VARCHAR2	(1995)		Item description.
COMMENTS	VARCHAR2	(1995)		User entered comments
CHR_ID	NUMBER			Contract Identifier
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
CHR_STS_CODE	VARCHAR2	(30)	Yes
CHR_STS_MEANING	VARCHAR2	(90)	Yes
CLE_STS_CODE	VARCHAR2	(30)	Yes
CLE_STS_MEANING	VARCHAR2	(90)	Yes
KLE_ID	NUMBER		Yes	Foreign key to view OKL_K_LINES_V
COMMMERCIALLY_REAS_SALE_YN	VARCHAR2	(3)		Is the asset available for sale following repossession.
DATE_HOLD_UNTIL	DATE			Represents when collections/litigation will release the asset for sale. Date should default to 15 days from the date repossession required.
DATE_REPOSSESSION_ACTUAL	DATE			The actual date the repossession took place.
DATE_REPOSSESSION_REQUIRED	DATE			Required repossession date.
DATE_RETURNED	DATE			The date the asset was actually returned
DATE_RETURN_DUE	DATE			The scheduled date for the asset return
DATE_RETURN_NOTIFIED	DATE			the date notification was received of intent to return asset
RELOCATE_ASSET_YN	VARCHAR2	(3)		Does the asset need to be relocated before being remarketed.
VOLUNTARY_YN	VARCHAR2	(3)		Repossession type, voluntary or involuntary.
RMR_ID	NUMBER
ARS_CODE	VARCHAR2	(30)	Yes
ASSET_RETURN_STATUS	VARCHAR2	(80)	Yes	QuickCode meaning
ART1_CODE	VARCHAR2	(30)	Yes
ASSET_RETURN_TYPE	VARCHAR2	(80)	Yes	QuickCode meaning
ID	NUMBER		Yes	Primary key column
DATE_TITLE_RECEIVED	DATE
REMARKETER_NAME	VARCHAR2	(30)		Team Name
AGENT_ID	NUMBER			Supplier unique identifier
AGENT_NAME	VARCHAR2	(240)		Supplier name
IMR_ID	NUMBER
SECURITY_DEP_TRX_AP_ID	NUMBER
ASSET_RELOCATED_YN	VARCHAR2	(3)
REPURCHASE_AGMT_YN	VARCHAR2	(3)
NEW_ITEM_DESCRIPTION	VARCHAR2	(1995)
NEW_ITEM_PRICE	NUMBER	(14)
INVENTORY_ITEM_NUMBER	VARCHAR2	(40)
QUANTITY	NUMBER
FLOOR_PRICE	NUMBER	(14)
END_DATE	DATE			End Date
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
MTL_DESCRIPTION	VARCHAR2	(240)
MTL_ORGANIZATION_ID	NUMBER
PRICE_UNIT	NUMBER
OEC	NUMBER
RESIDUAL_VALUE	NUMBER	(20)
TITLE_CUSTODIAN	VARCHAR2	(4000)
LIKE_KIND_YN	VARCHAR2	(3)
ORG_ID	NUMBER	(15)		Operating Unit identifier
LESSEE_KPR_ID	NUMBER		Yes
LESSEE_PARTY_ID	NUMBER	(15)	Yes
LESSEE_PARTY_NAME	VARCHAR2	(360)	Yes
NEW_ITEM_NUMBER	VARCHAR2	(40)		New Item Number
LEGAL_ENTITY_ID	NUMBER			Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES
ASSET_FMV_AMOUNT	NUMBER			Asset FMV Amount

Query Text

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


SELECT ASSET_NUMBER
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      CONTRACT_NUMBER
,      CHR_STS_CODE
,      CHR_STS_MEANING
,      CLE_STS_CODE
,      CLE_STS_MEANING
,      KLE_ID
,      COMMMERCIALLY_REAS_SALE_YN
,      DATE_HOLD_UNTIL
,      DATE_REPOSSESSION_ACTUAL
,      DATE_REPOSSESSION_REQUIRED
,      DATE_RETURNED
,      DATE_RETURN_DUE
,      DATE_RETURN_NOTIFIED
,      RELOCATE_ASSET_YN
,      VOLUNTARY_YN
,      RMR_ID
,      ARS_CODE
,      ASSET_RETURN_STATUS
,      ART1_CODE
,      ASSET_RETURN_TYPE
,      ID
,      DATE_TITLE_RECEIVED
,      REMARKETER_NAME
,      AGENT_ID
,      AGENT_NAME
,      IMR_ID
,      SECURITY_DEP_TRX_AP_ID
,      ASSET_RELOCATED_YN
,      REPURCHASE_AGMT_YN
,      NEW_ITEM_DESCRIPTION
,      NEW_ITEM_PRICE
,      INVENTORY_ITEM_NUMBER
,      QUANTITY
,      FLOOR_PRICE
,      END_DATE
,      CREATED_BY
,      MTL_DESCRIPTION
,      MTL_ORGANIZATION_ID
,      PRICE_UNIT
,      OEC
,      RESIDUAL_VALUE
,      TITLE_CUSTODIAN
,      LIKE_KIND_YN
,      ORG_ID
,      LESSEE_KPR_ID
,      LESSEE_PARTY_ID
,      LESSEE_PARTY_NAME
,      NEW_ITEM_NUMBER
,      LEGAL_ENTITY_ID
,      ASSET_FMV_AMOUNT
FROM APPS.OKL_AM_ASSET_RETURNS_UV;

Dependencies

[top of page]

APPS.OKL_AM_ASSET_RETURNS_UV references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_PARTIES; MTL_SYSTEM_ITEMS_B; OKC_K_HEADERS_ALL_B; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_PARTY_ROLES_V; OKC_LINE_STYLES_B; OKC_STATUSES_V; OKL_AM_REMARKET_TEAMS_UV; OKL_AM_UTIL_PVT - show dependent code; OKL_ASSET_RETURNS_ALL_B; OKL_ASSET_RETURNS_TL; OKL_K_LINES_FULL_V; OKL_SYSTEM_PARAMS; OKX_VENDORS_V

APPS.OKL_AM_ASSET_RETURNS_UV is referenced by following:

APPS: OKL_AM_ASSET_RETURN_PVT - show dependent code; OKL_AM_REPURCHASE_ASSET_PVT - show dependent code