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: OKI.OKI_COV_PRD_LINES

Object Details

Object Name:	OKI_COV_PRD_LINES
Object Type:	TABLE
Owner:	OKI
FND Design Data:	OKI.OKI_COV_PRD_LINES
Subobject Name:
Status:	VALID

This table holding information about covered product lines in Contracts for Service, and the products covered by those lines. It is maintained by the Load Covered Product Lines, Contracts Intelligence concurrent manager job.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_COV_PRD_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLE_ID
OKI_COV_PRD_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID
OKI_COV_PRD_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_NUMBER
OKI_COV_PRD_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COVERED_PRODUCT_ID
OKI_COV_PRD_LINES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_CLE_ID
OKI_COV_PRD_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE
OKI_COV_PRD_LINES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPLETE_CONTRACT_NUMBER
OKI_COV_PRD_LINES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_NAME
OKI_COV_PRD_LINES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
OKI_COV_PRD_LINES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IS_EXP_NOT_RENEWED_YN

Columns

Name	Datatype	Length	Mandatory	Comments
CLE_ID	NUMBER		Yes	Internal contract line identifier.
CHR_ID	NUMBER		Yes	The contract header identifier for the contract in which this line appears.
PARENT_CLE_ID	NUMBER			Internal line identifier of the parent top line of the covered product line.
SCS_CODE	VARCHAR2	(30)		The category (sub-class) code for the contract.
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number for this contract.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier for this contract.
COMPLETE_CONTRACT_NUMBER	VARCHAR2	(241)		Concatenated contract number and modifier.
LINE_NUMBER	VARCHAR2	(150)		External line number.
START_DATE	DATE			The starting effective date of the line.
END_DATE	DATE			The ending effective date of the line.
STS_CODE	VARCHAR2	(30)		The code value representing the status type of the line, such as ACTIVE or ENTERED.
TRN_CODE	VARCHAR2	(30)		The line termination reason code.
DATE_TERMINATED	DATE			Date the line was terminated.
DATE_RENEWED	DATE			The date the line was renewed.
NUMBER_OF_ITEMS	NUMBER	(15)		Number of covered items for the line.
UOM_CODE	VARCHAR2	(3)		Unit of measure code for the number of items.
UNIT_PRICE	NUMBER			Unit price for the covered product.
UNIT_PRICE_PERCENT	NUMBER	(6)		Percentage of the covered item price used to price the service, if percentage pricing of service is used.
PRICE_NEGOTIATED	NUMBER			The line price as negotiated. The final price of the line.
CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code for the line.
PRICE_NEGOTIATED_RENEWED	NUMBER			The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED	VARCHAR2	(15)		The transaction currency code of the line renewed by this line.
SOB_PRICE_UNIT	NUMBER			The unit price converted to the set of books currency.
SOB_PRICE_NEGOTIATED	NUMBER			The negotiated price in the set of books currency.
SOB_PRICE_NEGOTIATED_RENEWED	NUMBER			The price of the renewed line in the set of books currency.
SOB_CURRENCY_CODE	VARCHAR2	(15)		The set of books currency code.
BASE_PRICE_UNIT	NUMBER			Unit price for the covered product, in the base currency.
BASE_PRICE_NEGOTIATED	NUMBER			The line price as negotiated, in the base currency.
BASE_PRICE_NEGOTIATED_RENEWED	NUMBER			The line negotiated price of the line renewed by this line, in the base currency.
BASE_CURRENCY_CODE	VARCHAR2	(15)		The currency code of the base currency.
SERVICE_ITEM	VARCHAR2	(240)		The description of the service.
COVERED_PRODUCT_ID	NUMBER			The internal identifier of the covered product in Install Base.
CUSTOMER_PRODUCT_ITEM_ID	NUMBER			The internal identifier of the install base item covered by this line.
COV_PROD_QUANTITY	NUMBER			The quantity of the covered product in Install Base.
COV_PROD_UOM	VARCHAR2	(25)		The unit of measure of the quantity of the covered product in Install Base.
INSTALLATION_DATE	DATE			The date on which the covered product was installed.
COV_PROD_ORDER_DATE	DATE			The date of the sales order that shipped the covered product.
COV_PROD_ORDER_NUMBER	NUMBER	(15)		The order number of the sales order that shipped the covered product.
COV_PROD_ORDER_LINE	NUMBER	(15)		The line number for this covered product on the sales order.
COV_PROD_NET_AMOUNT	NUMBER	(28)		The net amount of the purchase/rental of the covered product.
COV_PROD_ORDER_LINE_ID	NUMBER			The internal line identifier for this covered product on the sales order.
SYSTEM_ID	NUMBER			The internal identifier of the Install Base system referenced by the covered product.
PRODUCT_AGREEMENT_ID	NUMBER			The identifier of the sales agreement used when purchasing the product.
COV_PROD_BILL_TO_SITE_ID	NUMBER			The covered product (Install Base) bill to address internal identifier
COV_PROD_SHIP_TO_SITE_ID	NUMBER			The covered product (Install Base) ship to address internal identifier
COV_PROD_INSTALL_SITE_ID	NUMBER			The covered product (Install Base) installed at address internal identifier
COV_PROD_BILL_TO_CONTACT_ID	NUMBER	(15)		The covered product (Install Base) bill to contact internal identifier
COV_PROD_SHIP_TO_CONTACT_ID	NUMBER	(15)		The covered product (Install Base) ship to contact internal identifier
AUTHORING_ORG_ID	NUMBER			The internal identifier of the operating unit in which the contract was authored.
INVENTORY_ORGANIZATION_ID	NUMBER			The internal identifier for the inventory organization.
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column.
ATTRIBUTE_CATEGORY	VARCHAR2	(90)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE2	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE3	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE4	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE5	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE6	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE7	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE8	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE9	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE10	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE11	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE12	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE13	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE14	VARCHAR2	(450)		Descriptive Flexfield segment column.
ATTRIBUTE15	VARCHAR2	(450)		Descriptive Flexfield segment column.
SECURITY_GROUP_ID	NUMBER			Used for application hosting.
DURATION	NUMBER			Duration of the line
PERIOD	VARCHAR2	(30)		Period code of the duration
STE_CODE	VARCHAR2	(30)		Status type code
CONCATENATED_SEGMENTS	VARCHAR2	(640)		Item segments
SERIAL_NUMBER	VARCHAR2	(30)		Serial number
REFERENCE_NUMBER	VARCHAR2	(30)		Reference number
SYSTEM_NAME	VARCHAR2	(50)		Install base system name
PRICING_ATTRIBUTE1	VARCHAR2	(30)		Pricing attribute 1
PRICING_ATTRIBUTE2	VARCHAR2	(30)		Pricing attribute 2
PRICING_ATTRIBUTE3	VARCHAR2	(30)		Pricing attribute 3
PRICING_ATTRIBUTE4	VARCHAR2	(30)		Pricing attribute 4
PRICING_ATTRIBUTE5	VARCHAR2	(30)		Pricing attribute 5
PRICING_ATTRIBUTE6	VARCHAR2	(30)		Pricing attribute 6
PRICING_ATTRIBUTE7	VARCHAR2	(30)		Pricing attribute 7
PRICING_ATTRIBUTE8	VARCHAR2	(30)		Pricing attribute 8
PRICING_ATTRIBUTE9	VARCHAR2	(30)		Pricing attribute 9
PRICING_ATTRIBUTE10	VARCHAR2	(30)		Pricing attribute 10
END_PERIOD_NUM	NUMBER	(15)		The number of the general ledger period in which the line ends.
END_PERIOD_NAME	VARCHAR2	(15)		The name of the general ledger period in which the line ends.
END_QUARTER	NUMBER	(15)		The general legder quarter in qhich the line ends
END_YEAR	NUMBER	(15)		The general ledger year in which the line ends
IS_EXP_NOT_RENEWED_YN	VARCHAR2	(1)		Flag indicating if the line is expired without a renewal

Query Text

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


SELECT CLE_ID
,      CHR_ID
,      PARENT_CLE_ID
,      SCS_CODE
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      LINE_NUMBER
,      START_DATE
,      END_DATE
,      STS_CODE
,      TRN_CODE
,      DATE_TERMINATED
,      DATE_RENEWED
,      NUMBER_OF_ITEMS
,      UOM_CODE
,      UNIT_PRICE
,      UNIT_PRICE_PERCENT
,      PRICE_NEGOTIATED
,      CURRENCY_CODE
,      PRICE_NEGOTIATED_RENEWED
,      CURRENCY_CODE_RENEWED
,      SOB_PRICE_UNIT
,      SOB_PRICE_NEGOTIATED
,      SOB_PRICE_NEGOTIATED_RENEWED
,      SOB_CURRENCY_CODE
,      BASE_PRICE_UNIT
,      BASE_PRICE_NEGOTIATED
,      BASE_PRICE_NEGOTIATED_RENEWED
,      BASE_CURRENCY_CODE
,      SERVICE_ITEM
,      COVERED_PRODUCT_ID
,      CUSTOMER_PRODUCT_ITEM_ID
,      COV_PROD_QUANTITY
,      COV_PROD_UOM
,      INSTALLATION_DATE
,      COV_PROD_ORDER_DATE
,      COV_PROD_ORDER_NUMBER
,      COV_PROD_ORDER_LINE
,      COV_PROD_NET_AMOUNT
,      COV_PROD_ORDER_LINE_ID
,      SYSTEM_ID
,      PRODUCT_AGREEMENT_ID
,      COV_PROD_BILL_TO_SITE_ID
,      COV_PROD_SHIP_TO_SITE_ID
,      COV_PROD_INSTALL_SITE_ID
,      COV_PROD_BILL_TO_CONTACT_ID
,      COV_PROD_SHIP_TO_CONTACT_ID
,      AUTHORING_ORG_ID
,      INVENTORY_ORGANIZATION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      DURATION
,      PERIOD
,      STE_CODE
,      CONCATENATED_SEGMENTS
,      SERIAL_NUMBER
,      REFERENCE_NUMBER
,      SYSTEM_NAME
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      END_PERIOD_NUM
,      END_PERIOD_NAME
,      END_QUARTER
,      END_YEAR
,      IS_EXP_NOT_RENEWED_YN
FROM OKI.OKI_COV_PRD_LINES;

Dependencies

[top of page]

OKI.OKI_COV_PRD_LINES does not reference any database object

OKI.OKI_COV_PRD_LINES is referenced by following:

APPS: OKI_COV_PRD_LINES