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

VIEW: APPS.OKL_USAGE_LINES_V

Object Details
Object Name: OKL_USAGE_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_USAGE_LINES_V
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
Yes Primary key column. Foreign key to OKC_K_LINES_B.ID of service contract.
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (150)
Service name
DESCRIPTION VARCHAR2 (1995)
Service description
START_DATE_ACTIVE DATE

Effetive from date of service
END_DATE_ACTIVE DATE

Effective to date of service
STATUS VARCHAR2 (1)
Indicates whether service line in active or not
STS_CODE VARCHAR2 (30) Yes Status of setvice line. Foreign key to OKC_STATUSES_B.STE_CODE
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      STS_CODE
FROM APPS.OKL_USAGE_LINES_V;

Dependencies

[top of page]

APPS.OKL_USAGE_LINES_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B
APPS.OKL_USAGE_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code