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_EXPIRED_LINES

Object Details

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

This table holds information about contract lines that have expired without renewal. It is maintained by the Load Expired 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_EXPIRED_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLE_ID
OKI_EXPIRED_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID

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.
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number for this contract.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier for the contract in which this line appears.
COMPLETE_CONTRACT_NUMBER	VARCHAR2	(241)		Concatenated contract number and modifier.
SCS_CODE	VARCHAR2	(30)		The category (sub-class) code for the contract.
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.
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 Ledger quarter in which the line ends.
END_YEAR	NUMBER	(15)		The General Ledger year in which the line ends.
UNIT_PRICE	NUMBER			Unit price for the line item.
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 line, 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.
AUTHORING_ORG_ID	NUMBER			The internal identifier of the operating unit in which the contract was authored.
ORGANIZATION_NAME	VARCHAR2	(240)		The name 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.

Query Text

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


SELECT CLE_ID
,      CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      SCS_CODE
,      LINE_NUMBER
,      START_DATE
,      END_DATE
,      STS_CODE
,      TRN_CODE
,      DATE_TERMINATED
,      DATE_RENEWED
,      END_PERIOD_NUM
,      END_PERIOD_NAME
,      END_QUARTER
,      END_YEAR
,      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
,      AUTHORING_ORG_ID
,      ORGANIZATION_NAME
,      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
FROM OKI.OKI_EXPIRED_LINES;

Dependencies

[top of page]

OKI.OKI_EXPIRED_LINES does not reference any database object

OKI.OKI_EXPIRED_LINES is referenced by following:

APPS: OKI_EXPIRED_LINES