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_EXPIRED_LINES_V

Object Details

Object Name:	OKI_EXPIRED_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKI.OKI_EXPIRED_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_EXPIRED_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 expired line.
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.
STATUS_MEANING	VARCHAR2	(90)	Yes	The external description of the status of the contract.
TRN_CODE	VARCHAR2	(30)		The line 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.
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	VARCHAR2	(0)		The negotiated price of the line renewed by this line.
CURRENCY_CODE_RENEWED	VARCHAR2	(0)		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	VARCHAR2	(0)		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	VARCHAR2	(0)		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)	Yes	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.

Query Text

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


SELECT CONTRACT_LINE_ID
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_CONTRACT_NUMBER
,      SCS_CODE
,      LINE_NUMBER
,      START_DATE
,      END_DATE
,      STS_CODE
,      STATUS_MEANING
,      TRN_CODE
,      TERMINATION_MEANING
,      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
FROM APPS.OKI_EXPIRED_LINES_V;

Dependencies

[top of page]

APPS.OKI_EXPIRED_LINES_V references the following:

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

APPS.OKI_EXPIRED_LINES_V is referenced by following:

APPS: OKI_RNW_BY_STS_DTL_V