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.IEX_REPOS_OBJECTS_UV

Object Details

Object Name:	IEX_REPOS_OBJECTS_UV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REPOS_OBJECT_ID	NUMBER		Yes	Primary key
DELINQUENCY_ID	NUMBER			Delinquency ID for a repossession.
REPOSSESSION_ID	NUMBER		Yes	FK to IEX_REPOSSESSIONS
ASSET_ID	NUMBER	(15)	Yes	Asset identifier
RNA_ID	NUMBER		Yes	Repossession agent identifier. FK to PO_VENDORS
VENDOR_NAME	VARCHAR2	(240)
RNA_SITE_ID	NUMBER
SITE_NAME	VARCHAR2	(15)
SITE_DESCRIPTION	VARCHAR2	(80)
ART_ID	NUMBER
ACTIVE_YN	VARCHAR2	(1)
RELOCATE_ASSET_YN	VARCHAR2	(3)
ASSET_NUMBER	VARCHAR2	(15)
ASSET_NAME	VARCHAR2	(15)
ASSET_DESCRIPTION	VARCHAR2	(1995)
DNZ_CHR_ID	NUMBER
SERIAL_NUMBER	VARCHAR2	(35)
ART1_CODE	VARCHAR2	(30)
ARS_CODE	VARCHAR2	(30)
RETURN_STATUS	VARCHAR2	(80)
KLE_ID	NUMBER
DATE_REPOSSESSION_REQUIRED	DATE
DATE_REPOSSESSION_ACTUAL	DATE
DATE_HOLD_UNTIL	DATE
DATE_RETURNED	DATE
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)

Query Text

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


SELECT REPOS_OBJECT_ID
,      DELINQUENCY_ID
,      REPOSSESSION_ID
,      ASSET_ID
,      RNA_ID
,      VENDOR_NAME
,      RNA_SITE_ID
,      SITE_NAME
,      SITE_DESCRIPTION
,      ART_ID
,      ACTIVE_YN
,      RELOCATE_ASSET_YN
,      ASSET_NUMBER
,      ASSET_NAME
,      ASSET_DESCRIPTION
,      DNZ_CHR_ID
,      SERIAL_NUMBER
,      ART1_CODE
,      ARS_CODE
,      RETURN_STATUS
,      KLE_ID
,      DATE_REPOSSESSION_REQUIRED
,      DATE_REPOSSESSION_ACTUAL
,      DATE_HOLD_UNTIL
,      DATE_RETURNED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IEX_REPOS_OBJECTS_UV;

Dependencies

[top of page]

APPS.IEX_REPOS_OBJECTS_UV references the following:

APPS: ARP_ADDR_LABEL_PKG - show dependent code; FND_LOOKUP_VALUES; IEX_REPOSSESSIONS; IEX_REPOS_OBJECTS; OKL_ASSET_RETURNS_B; OKX_ASSET_LINES_V; OKX_VENDOR_SITES_V; PO_VENDORS

APPS.IEX_REPOS_OBJECTS_UV is not referenced by any database object