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

VIEW: APPS.OKL_LA_ASSET_DTLS_UV

Object Details
Object Name: OKL_LA_ASSET_DTLS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_ASSET_DTLS_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 Unique identifier for asset
CLE_ID NUMBER

Unique identifier for parent line
DNZ_CHR_ID NUMBER
Yes Denormalized contract header identifier
EXCEPTION_YN VARCHAR2 (3) Yes Exception flag
RESIDUAL_PERCENTAGE VARCHAR2 (40)
Residual percentage
PRESCRIBED_ASSET_YN VARCHAR2 (3)
Prescribed asset flag
RESIDUAL_VALUE VARCHAR2 (40)
Residual value
RE_LEASE_YN VARCHAR2 (3)
Re-lease asset flag
PREVIOUS_CONTRACT VARCHAR2 (40)
Previous contract
RESIDUAL_GRNTY_AMOUNT VARCHAR2 (40)
Residual guaranty amount
RESIDUAL_CODE VARCHAR2 (30)
Residual code
RVI_PREMIUM VARCHAR2 (40)
RVI premium
DATE_DELIVERY_EXPECTED VARCHAR2 (9)
Date Delivery Expected
DATE_FUNDING_EXPECTED VARCHAR2 (9)
Date Funding Expected
EXPECTED_ASSET_COST VARCHAR2 (40)
Query Text

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


SELECT ID
,      CLE_ID
,      DNZ_CHR_ID
,      EXCEPTION_YN
,      RESIDUAL_PERCENTAGE
,      PRESCRIBED_ASSET_YN
,      RESIDUAL_VALUE
,      RE_LEASE_YN
,      PREVIOUS_CONTRACT
,      RESIDUAL_GRNTY_AMOUNT
,      RESIDUAL_CODE
,      RVI_PREMIUM
,      DATE_DELIVERY_EXPECTED
,      DATE_FUNDING_EXPECTED
,      EXPECTED_ASSET_COST
FROM APPS.OKL_LA_ASSET_DTLS_UV;

Dependencies

[top of page]

APPS.OKL_LA_ASSET_DTLS_UV references the following:

SchemaAPPS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKL_K_LINES

APPS.OKL_LA_ASSET_DTLS_UV is not referenced by any database object