DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IEX_REPOS_AVAIL_ASSETS_UV2

Object Details
Object Name: IEX_REPOS_AVAIL_ASSETS_UV2
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
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 VARCHAR2 (0)
CAS_ID VARCHAR2 (0)
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
,      CAS_ID
FROM APPS.IEX_REPOS_AVAIL_ASSETS_UV2;

Dependencies

[top of page]

APPS.IEX_REPOS_AVAIL_ASSETS_UV2 references the following:

SchemaAPPS
SynonymIEX_REPOS_OBJECTS
ViewOKC_K_HEADERS_V
PL/SQL PackageOKC_UTIL - show dependent code
ViewOKX_ASSET_LINES_V

APPS.IEX_REPOS_AVAIL_ASSETS_UV2 is not referenced by any database object