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_AVAIL_ASSETS_UV

Object Details

Object Name:	IEX_REPOS_AVAIL_ASSETS_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
ID1	NUMBER		Yes
ID2	CHAR	(1)
NAME	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(80)
ITEM_DESCRIPTION	VARCHAR2	(1995)
COMMENTS	VARCHAR2	(1995)
CHR_ID	NUMBER
DNZ_CHR_ID	NUMBER		Yes
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract (RFP,Proposal etc.) Legal Identifier.
LTY_CODE	VARCHAR2	(30)	Yes
LSE_TYPE	VARCHAR2	(10)	Yes
LSE_PARENT_ID	NUMBER
PARENT_LINE_ID	NUMBER
LINE_NUMBER	VARCHAR2	(150)	Yes
DATE_TERMINATED	DATE
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
STATUS	VARCHAR2	(1)
ASSET_ID	NUMBER	(15)	Yes
QUANTITY	NUMBER		Yes
UNIT_OF_MEASURE_CODE	VARCHAR2	(3)
ASSET_NUMBER	VARCHAR2	(15)	Yes
CORPORATE_BOOK	VARCHAR2	(15)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
ORIGINAL_COST	NUMBER
COST	NUMBER		Yes
ADJUSTED_COST	NUMBER		Yes
TAG_NUMBER	VARCHAR2	(15)
CURRENT_UNITS	NUMBER		Yes
SERIAL_NUMBER	VARCHAR2	(35)
REVAL_CEILING	NUMBER
NEW_USED	VARCHAR2	(4)	Yes
IN_SERVICE_DATE	DATE		Yes
MANUFACTURER_NAME	VARCHAR2	(360)
MODEL_NUMBER	VARCHAR2	(40)
ASSET_TYPE	VARCHAR2	(11)	Yes
SALVAGE_VALUE	NUMBER		Yes
PERCENT_SALVAGE_VALUE	NUMBER
DEPRECIATION_CATEGORY	NUMBER	(15)	Yes
DEPRN_START_DATE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes
BASIC_RATE	NUMBER
ADJUSTED_RATE	NUMBER
RECOVERABLE_COST	NUMBER		Yes
ORG_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
PROPERTY_TYPE_CODE	VARCHAR2	(10)
PROPERTY_1245_1250_CODE	VARCHAR2	(4)
IN_USE_FLAG	VARCHAR2	(3)	Yes
OWNED_LEASED	VARCHAR2	(15)	Yes
INVENTORIAL	VARCHAR2	(3)
LINE_STATUS	VARCHAR2	(30)	Yes
DELINQUENCY_ID	NUMBER		Yes
CASE_ID	NUMBER		Yes

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      DNZ_CHR_ID
,      CONTRACT_NUMBER
,      LTY_CODE
,      LSE_TYPE
,      LSE_PARENT_ID
,      PARENT_LINE_ID
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ASSET_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      ASSET_NUMBER
,      CORPORATE_BOOK
,      LIFE_IN_MONTHS
,      ORIGINAL_COST
,      COST
,      ADJUSTED_COST
,      TAG_NUMBER
,      CURRENT_UNITS
,      SERIAL_NUMBER
,      REVAL_CEILING
,      NEW_USED
,      IN_SERVICE_DATE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      ASSET_TYPE
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      DEPRECIATION_CATEGORY
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      RATE_ADJUSTMENT_FACTOR
,      BASIC_RATE
,      ADJUSTED_RATE
,      RECOVERABLE_COST
,      ORG_ID
,      SET_OF_BOOKS_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      INVENTORIAL
,      LINE_STATUS
,      DELINQUENCY_ID
,      CASE_ID
FROM APPS.IEX_REPOS_AVAIL_ASSETS_UV;

Dependencies

[top of page]

APPS.IEX_REPOS_AVAIL_ASSETS_UV references the following:

APPS: IEX_CASE_OBJECTS; IEX_DELINQUENCIES; IEX_REPOS_OBJECTS; OKC_K_HEADERS_V; OKC_UTIL - show dependent code; OKL_CNSLD_AR_STRMS_B; OKX_ASSET_LINES_V

APPS.IEX_REPOS_AVAIL_ASSETS_UV is not referenced by any database object