DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKI_SOLD_ITEM_LINES_V

Object Details
Object Name: OKI_SOLD_ITEM_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKI.OKI_SOLD_ITEM_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_SOLD_ITM_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 top 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.
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 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.
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 sold 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.
SOLD_ITEM VARCHAR2 (240)
The description of the sold item.
ITEM_ID NUMBER

The item identifier from the item master for the sold item.
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item segments
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
,      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
,      SOLD_ITEM
,      ITEM_ID
,      CONCATENATED_SEGMENTS
,      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_SOLD_ITEM_LINES_V;

Dependencies

[top of page]

APPS.OKI_SOLD_ITEM_LINES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewOKC_STATUSES_V
PL/SQL PackageOKC_UTIL - show dependent code
SynonymOKI_SOLD_ITM_LINES
ViewOKX_SYSTEM_ITEMS_V

APPS.OKI_SOLD_ITEM_LINES_V is not referenced by any database object