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

VIEW: APPS.OKL_CS_SERVICE_LINES_UV

Object Details
Object Name: OKL_CS_SERVICE_LINES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_SERVICE_LINES_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
CLE_ID NUMBER
Yes System generated unique identifier. Primary key column of the table.
SERVICE_NAME VARCHAR2 (240)
Item name.
AMOUNT NUMBER

Amount
START_DATE DATE

The beginning of the active period, one second after midnight on the date indicated.
END_DATE DATE

The end of the active period, one second before midnight on the date indicated.
STATUS VARCHAR2 (90) Yes Short meaning associated with code value.
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract (RFP,Proposal etc.) Legal Identifier.
CONTRACT_ID NUMBER
Yes Contract ID. Denormalized for performance.
CURRENCY_CODE VARCHAR2 (15)
Unique identifier of Currency code. Refers to CURRENCY_CODE in FND_CURRENCIES.
Query Text

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


SELECT CLE_ID
,      SERVICE_NAME
,      AMOUNT
,      START_DATE
,      END_DATE
,      STATUS
,      CONTRACT_NUMBER
,      CONTRACT_ID
,      CURRENCY_CODE
FROM APPS.OKL_CS_SERVICE_LINES_UV;

Dependencies

[top of page]

APPS.OKL_CS_SERVICE_LINES_UV references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_ITEMS
SynonymOKC_K_LINES_B
SynonymOKC_LINE_STYLES_B
SynonymOKC_STATUSES_B
SynonymOKC_STATUSES_TL
SynonymOKL_K_LINES
ViewOKX_SYSTEM_ITEMS_V

APPS.OKL_CS_SERVICE_LINES_UV is not referenced by any database object