Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_QUICK_QUOTE_LINES_B and OKL_QUICK_QUOTE_LINES_TL |
Implementation/DBA Data: | APPS.OKL_QUICK_QUOTE_LINES_V |
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')