FND Design Data [Home] [Help]

View: OKL_QUICK_QUOTE_LINES_V

Product: OKL - Lease and Finance Management
Description: View for OKL_QUICK_QUOTE_LINES_B and OKL_QUICK_QUOTE_LINES_TL
Implementation/DBA Data: ViewAPPS.OKL_QUICK_QUOTE_LINES_V
View Text

SELECT QQL.ROWID ROW_ID
, QQL.ID ID
, QQL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, QQL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, QQL.ATTRIBUTE1 ATTRIBUTE1
, QQL.ATTRIBUTE2 ATTRIBUTE2
, QQL.ATTRIBUTE3 ATTRIBUTE3
, QQL.ATTRIBUTE4 ATTRIBUTE4
, QQL.ATTRIBUTE5 ATTRIBUTE5
, QQL.ATTRIBUTE6 ATTRIBUTE6
, QQL.ATTRIBUTE7 ATTRIBUTE7
, QQL.ATTRIBUTE8 ATTRIBUTE8
, QQL.ATTRIBUTE9 ATTRIBUTE9
, QQL.ATTRIBUTE10 ATTRIBUTE10
, QQL.ATTRIBUTE11 ATTRIBUTE11
, QQL.ATTRIBUTE12 ATTRIBUTE12
, QQL.ATTRIBUTE13 ATTRIBUTE13
, QQL.ATTRIBUTE14 ATTRIBUTE14
, QQL.ATTRIBUTE15 ATTRIBUTE15
, QQL.CREATED_BY CREATED_BY
, QQL.CREATION_DATE CREATION_DATE
, QQL.LAST_UPDATED_BY LAST_UPDATED_BY
, QQL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QQL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QQL.QUICK_QUOTE_ID QUICK_QUOTE_ID
, QQL.TYPE TYPE
, QQL.BASIS BASIS
, QQL.VALUE VALUE
, QQL.END_OF_TERM_VALUE_DEFAULT END_OF_TERM_VALUE_DEFAULT
, QQL.END_OF_TERM_VALUE END_OF_TERM_VALUE
, QQL.PERCENTAGE_OF_TOTAL_COST PERCENTAGE_OF_TOTAL_COST
, QQL.ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, QQL.ITEM_CATEGORY_SET_ID ITEM_CATEGORY_SET_ID
, QQL.LEASE_RATE_FACTOR LEASE_RATE_FACTOR
, QQLT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, QQLT.DESCRIPTION DESCRIPTION
, QQLT.COMMENTS COMMENTS
FROM OKL_QUICK_QUOTE_LINES_B QQL
, OKL_QUICK_QUOTE_LINES_TL QQLT
WHERE QQL.ID = QQLT.ID
AND QQLT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
QUICK_QUOTE_ID
TYPE
BASIS
VALUE
END_OF_TERM_VALUE_DEFAULT
END_OF_TERM_VALUE
PERCENTAGE_OF_TOTAL_COST
ITEM_CATEGORY_ID
ITEM_CATEGORY_SET_ID
LEASE_RATE_FACTOR
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS