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

VIEW: APPS.OKL_LA_COV_ASSET_UV

Object Details
Object Name: OKL_LA_COV_ASSET_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LA_COV_ASSET_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
ID1 NUMBER

Unique identifier for covered asset. Primary key
ID2 CHAR (1)
Primary Key
CHR_ID NUMBER

Contract identifier
CONTRACT_NUMBER VARCHAR2 (120)
Contract number
NAME VARCHAR2 (150)
Name
DESCRIPTION VARCHAR2 (1995)
Description
SERV_TOP_LINE_ID NUMBER

Service top line identifier
OKS_COV_LINE_ID NUMBER

Contracts for service covered line identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
ITEM_ID NUMBER

SERIAL_NUMBER_CONTROL_CODE NUMBER

LEASE_ITEM_QTY NUMBER

SERVICE_ITEM_QTY NUMBER

PRICE_NEGOTIATED NUMBER

SRV_PROD_INSTANCE_ID NUMBER

Query Text

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


SELECT ID1
,      ID2
,      CHR_ID
,      CONTRACT_NUMBER
,      NAME
,      DESCRIPTION
,      SERV_TOP_LINE_ID
,      OKS_COV_LINE_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_ID
,      SERIAL_NUMBER_CONTROL_CODE
,      LEASE_ITEM_QTY
,      SERVICE_ITEM_QTY
,      PRICE_NEGOTIATED
,      SRV_PROD_INSTANCE_ID
FROM APPS.OKL_LA_COV_ASSET_UV;

Dependencies

[top of page]

APPS.OKL_LA_COV_ASSET_UV references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
SynonymMTL_SYSTEM_ITEMS_B
SynonymOKC_K_HEADERS_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_K_REL_OBJS
SynonymOKC_LINE_STYLES_B
SynonymOKC_STATUSES_B
APPS.OKL_LA_COV_ASSET_UV is referenced by following:

SchemaAPPS
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_SERVICE_INTEGRATION_PVT - show dependent code