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

VIEW: APPS.OKL_SERVICE_LINES_V

Object Details
Object Name: OKL_SERVICE_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_SERVICE_LINES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


OKL Service Integration JTF View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Service contracts service line identifier
ID2 CHAR (1)
Service Contracts service line identifier
NAME VARCHAR2 (150)
Service name
DESCRIPTION VARCHAR2 (1995)
Service description
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Service status code . Indicates whether service line is active
STS_CODE VARCHAR2 (30) Yes Service line status
ORG_ID NUMBER
Yes Operating unit identifier
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
,      ORG_ID
FROM APPS.OKL_SERVICE_LINES_V;

Dependencies

[top of page]

APPS.OKL_SERVICE_LINES_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_B

APPS.OKL_SERVICE_LINES_V is not referenced by any database object