eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKS.OKS_K_LINES_TL

Object Details

Object Name:	OKS_K_LINES_TL
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_K_LINES_TL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_K_LINES_TL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID LANGUAGE

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Unique identifier for Service Contract line in OKS_K_LINES_B
LANGUAGE	VARCHAR2	(12)	Yes	Language Primary Key. Standard MLS column.
SOURCE_LANG	VARCHAR2	(12)	Yes	Source Language of the record.
SFWT_FLAG	VARCHAR2	(3)	Yes	Not used.
INVOICE_TEXT	VARCHAR2	(2000)		Invoice text associated with every Contract line and sub line. It passes to AR and displays on the invoice.
IB_TRX_DETAILS	VARCHAR2	(2000)		Not used.
STATUS_TEXT	VARCHAR2	(450)		Stores the status message returned by Pricing engine after a line or sub line is priced. Stores 'Success' if pricing is successful else stores the actual error message in case of failures. This value is displayed in 'Status' field of Price Calculation window for a Service line at sub line level. This value is also displayed in 'Status' field of Price Calculation window for a Subscription line.
REACT_TIME_NAME	VARCHAR2	(450)		Name entered for reaction time. This is a user entered value & is captured in the Coverage's UI
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.

Query Text

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


SELECT ID
,      LANGUAGE
,      SOURCE_LANG
,      SFWT_FLAG
,      INVOICE_TEXT
,      IB_TRX_DETAILS
,      STATUS_TEXT
,      REACT_TIME_NAME
,      SECURITY_GROUP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKS.OKS_K_LINES_TL;

Dependencies

[top of page]

OKS.OKS_K_LINES_TL does not reference any database object

OKS.OKS_K_LINES_TL is referenced by following:

APPS: OKS_K_LINES_TL