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_CON_COV_LEVELS_INT_ALL

Object Details

Object Name:	OKS_CON_COV_LEVELS_INT_ALL
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_CON_COV_LEVELS_INT_ALL
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_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_LINE_ID	NUMBER		Yes	Contract Line Id
COVERED_LEVEL_LINE_ID	NUMBER		Yes	Covered Level Line Id
LINE_NUMBER	VARCHAR2	(150)		Line Number
COVERED_ITEM_ID	NUMBER			Covered Item Id
COVERED_ITEM_ORG_ID	NUMBER			Covered Item Org Id
COVERED_PARTY_ID	NUMBER			Covered Party Id
COVERED_PRODUCT_ID	NUMBER			Covered Product Id
COVERED_SITE_ID	NUMBER			Covered Site Id
COVERED_SYSTEM_ID	NUMBER			Covered System Id
COVERED_CUSTOMER_ID	NUMBER			Covered Customer Id
LINE_REF	VARCHAR2	(300)		Line Ref
LINE_STATUS_CODE	VARCHAR2	(30)		Line Status Code
START_DATE	DATE		Yes	Start Date
END_DATE	DATE		Yes	End Date
RENEWAL_TYPE	VARCHAR2	(100)		Renewal Type
INVOICE_TEXT	VARCHAR2	(300)		Text of the Invoice.
INVOICE_PRINT_FLAG	VARCHAR2	(1)		Invoice Print Flag
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield
PRICING_CONTEXT	VARCHAR2	(90)		Pricing Context
PRICING_ATTRIBUTE1	VARCHAR2	(720)		Pricing Attribute1
PRICING_ATTRIBUTE2	VARCHAR2	(720)		Pricing Attribute2
PRICING_ATTRIBUTE3	VARCHAR2	(720)		Pricing Attribute3
PRICING_ATTRIBUTE4	VARCHAR2	(720)		Pricing Attribute4
PRICING_ATTRIBUTE5	VARCHAR2	(720)		Pricing Attribute5
PRICING_ATTRIBUTE6	VARCHAR2	(720)		Pricing Attribute6
PRICING_ATTRIBUTE7	VARCHAR2	(720)		Pricing Attribute7
PRICING_ATTRIBUTE8	VARCHAR2	(720)		Pricing Attribute8
PRICING_ATTRIBUTE9	VARCHAR2	(720)		Pricing Attribute9
PRICING_ATTRIBUTE10	VARCHAR2	(720)		Pricing Attribute10
PRICING_ATTRIBUTE11	VARCHAR2	(720)		Pricing Attribute11
PRICING_ATTRIBUTE12	VARCHAR2	(720)		Pricing Attribute12
PRICING_ATTRIBUTE13	VARCHAR2	(720)		Pricing Attribute13
PRICING_ATTRIBUTE14	VARCHAR2	(720)		Pricing Attribute14
PRICING_ATTRIBUTE15	VARCHAR2	(720)		Pricing Attribute15
QUANTITY	NUMBER			Quantity
UNIT_OF_MEASURE_CODE	VARCHAR2	(30)		Unit Of Measure Code
PRICE_LIST_ID	NUMBER			Price List Id
PRICE_UNIT	NUMBER			Price Unit
PRICE_NEGOTIATED	NUMBER			Price Negotiated
PRICE_UNIT_PERCENT	NUMBER			Price Unit Percent
INTERFACED_STATUS_FLAG	VARCHAR2	(1)		Interfaced Status Flag
CURRENCY_CODE	VARCHAR2	(30)		Currency Code
CREATED_BY	NUMBER	(15)		ID of the user whom created the record.
CREATION_DATE	DATE			Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)		ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE			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 CONTRACT_LINE_ID
,      COVERED_LEVEL_LINE_ID
,      LINE_NUMBER
,      COVERED_ITEM_ID
,      COVERED_ITEM_ORG_ID
,      COVERED_PARTY_ID
,      COVERED_PRODUCT_ID
,      COVERED_SITE_ID
,      COVERED_SYSTEM_ID
,      COVERED_CUSTOMER_ID
,      LINE_REF
,      LINE_STATUS_CODE
,      START_DATE
,      END_DATE
,      RENEWAL_TYPE
,      INVOICE_TEXT
,      INVOICE_PRINT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      PRICE_LIST_ID
,      PRICE_UNIT
,      PRICE_NEGOTIATED
,      PRICE_UNIT_PERCENT
,      INTERFACED_STATUS_FLAG
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKS.OKS_CON_COV_LEVELS_INT_ALL;

Dependencies

[top of page]

OKS.OKS_CON_COV_LEVELS_INT_ALL does not reference any database object

OKS.OKS_CON_COV_LEVELS_INT_ALL is referenced by following:

OKS: OKS_CON_COV_LEVELS_INT_ALL#