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]

VIEW: APPS.OKI_COV_PROD_LINES_V

Object Details

Object Name:	OKI_COV_PROD_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_COV_PROD_LINES_V
Subobject Name:
Status:	VALID

View Type

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

A view over OKI_COV_PROD_LINES containing language specific information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_LINE_ID	NUMBER		Yes	Internal contract line identifier.
CONTRACT_ID	NUMBER		Yes	The internal identifier of the contract for this covered product line.
PARENT_LINE_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.
DURATION	NUMBER			Duration of the line
PERIOD	VARCHAR2	(30)		Period code for the duration
STS_CODE	VARCHAR2	(30)		The code value representing the status type of the line, such as ACTIVE or ENTERED.
STATUS_MEANING	VARCHAR2	(90)	Yes	The external description of the status of the contract.
STATUS_TYPE_CODE	VARCHAR2	(30)		Status type code
STATUS_TYPE_MEANING	VARCHAR2	(80)	Yes	Status type meaning
TRN_CODE	VARCHAR2	(30)		The contract termination reason code.
TERMINATION_MEANING	VARCHAR2	(80)		The external description of the termination reason.
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.
COVERED_PRODUCT	VARCHAR2	(0)		The description of the covered product.
CONCATENATED_SEGMENTS	VARCHAR2	(640)		Item segments
SERIAL_NUMBER	VARCHAR2	(30)		Item serial number
REFERENCE_NUMBER	VARCHAR2	(30)		Item reference number
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.
SYSTEM_NAME	VARCHAR2	(50)		Install base system name
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
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.
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
CUSTOMER_PRODUCT_ITEM_ID	NUMBER			Customer product item id
INVENTORY_ORGANIZATION_ID	NUMBER			Inventory organization id

Query Text

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


SELECT CONTRACT_LINE_ID
,      CONTRACT_ID
,      PARENT_LINE_ID
,      SCS_CODE
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      LINE_NUMBER
,      START_DATE
,      END_DATE
,      DURATION
,      PERIOD
,      STS_CODE
,      STATUS_MEANING
,      STATUS_TYPE_CODE
,      STATUS_TYPE_MEANING
,      TRN_CODE
,      TERMINATION_MEANING
,      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
,      COVERED_PRODUCT
,      CONCATENATED_SEGMENTS
,      SERIAL_NUMBER
,      REFERENCE_NUMBER
,      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
,      SYSTEM_NAME
,      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
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      CUSTOMER_PRODUCT_ITEM_ID
,      INVENTORY_ORGANIZATION_ID
FROM APPS.OKI_COV_PROD_LINES_V;

Dependencies

[top of page]

APPS.OKI_COV_PROD_LINES_V references the following:

APPS: CSI_SYSTEMS_TL; FND_GLOBAL - show dependent code; FND_LOOKUPS; OKC_STATUSES_V; OKC_UTIL - show dependent code; OKI_COV_PRD_LINES

APPS.OKI_COV_PROD_LINES_V is not referenced by any database object