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

VIEW: APPS.OKL_AM_ASSET_DETAILS_CHR_UV

Object Details
Object Name: OKL_AM_ASSET_DETAILS_CHR_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AM_ASSET_DETAILS_CHR_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
ID NUMBER
Yes Primary key column
NAME VARCHAR2 (150)
Name
ITEM_DESCRIPTION VARCHAR2 (1995)
Item description.
CHR_ID NUMBER

Contract Identifier
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract Number
CONTRACT_STATUS VARCHAR2 (30) Yes Line status code defined in FND_LOOKUPS.
START_DATE DATE

Start Date
END_DATE DATE

End Date
LINE_STATUS VARCHAR2 (30) Yes Line status code defined in FND_LOOKUPS.
ORIGINAL_COST NUMBER

SERIAL_NUMBER VARCHAR2 (35)
IN_SERVICE_DATE DATE

MANUFACTURER_NAME VARCHAR2 (360)
MODEL_NUMBER VARCHAR2 (40)
ASSET_TYPE VARCHAR2 (11)
LIFE_IN_MONTHS NUMBER (4)
NEW_USED VARCHAR2 (4)
SALVAGE_VALUE NUMBER

DEPRECIATION_CATEGORY NUMBER (15)
DEPRN_START_DATE DATE

DEPRN_CATEGORY_DESC VARCHAR2 (40)
Query Text

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


SELECT ID
,      NAME
,      ITEM_DESCRIPTION
,      CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_STATUS
,      START_DATE
,      END_DATE
,      LINE_STATUS
,      ORIGINAL_COST
,      SERIAL_NUMBER
,      IN_SERVICE_DATE
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      ASSET_TYPE
,      LIFE_IN_MONTHS
,      NEW_USED
,      SALVAGE_VALUE
,      DEPRECIATION_CATEGORY
,      DEPRN_START_DATE
,      DEPRN_CATEGORY_DESC
FROM APPS.OKL_AM_ASSET_DETAILS_CHR_UV;

Dependencies

[top of page]

APPS.OKL_AM_ASSET_DETAILS_CHR_UV references the following:

SchemaAPPS
ViewFA_CATEGORIES_VL
SynonymOKC_K_HEADERS_B
ViewOKC_LINE_STYLES_V
PL/SQL PackageOKL_AM_UTIL_PVT - show dependent code
ViewOKL_K_LINES_FULL_V
ViewOKX_ASSET_LINES_V

APPS.OKL_AM_ASSET_DETAILS_CHR_UV is not referenced by any database object