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

VIEW: APPS.OKL_CS_LINE_VERSION_UV

Object Details
Object Name: OKL_CS_LINE_VERSION_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_LINE_VERSION_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
CONTRACT_ID NUMBER

Contract ID
CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
ASSET_NUMBER VARCHAR2 (150)
Asset Number
PARENT_LINE_ID NUMBER

Parent Line ID
ASSET_DESCRIPTION VARCHAR2 (1995)
Asset Description
NUMBER_OF_UNITS NUMBER

Number of Units
LINE_STATUS VARCHAR2 (30)
Line Status
ASSET_STATUS VARCHAR2 (90)
Asset Status
MAJOR_VERSION NUMBER (4)
Major Version
RESIDUAL_VALUE NUMBER

Residual Value
RESIDUAL_PERCENTAGE NUMBER

Residual Percentage
GURANTEED_AMOUNT NUMBER

Gauranteed Amount
OEC NUMBER

Original Equipment Cost
CAPITAL_AMOUNT NUMBER

Capital Amount
CURRENCY_CODE VARCHAR2 (15)
Currency Code
Query Text

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


SELECT CONTRACT_ID
,      CONTRACT_NUMBER
,      ASSET_NUMBER
,      PARENT_LINE_ID
,      ASSET_DESCRIPTION
,      NUMBER_OF_UNITS
,      LINE_STATUS
,      ASSET_STATUS
,      MAJOR_VERSION
,      RESIDUAL_VALUE
,      RESIDUAL_PERCENTAGE
,      GURANTEED_AMOUNT
,      OEC
,      CAPITAL_AMOUNT
,      CURRENCY_CODE
FROM APPS.OKL_CS_LINE_VERSION_UV;

Dependencies

[top of page]

APPS.OKL_CS_LINE_VERSION_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_BH
SynonymOKC_K_ITEMS
SynonymOKC_K_ITEMS_H
SynonymOKC_K_LINES_BH
ViewOKC_K_LINES_HV
SynonymOKC_K_LINES_TLH
SynonymOKC_LINE_STYLES_B
ViewOKC_STATUSES_V
SynonymOKL_K_HEADERS
SynonymOKL_K_LINES
SynonymOKL_K_LINES_H
SynonymOKL_TXL_ASSETS_B

APPS.OKL_CS_LINE_VERSION_UV is not referenced by any database object