FND Design Data [Home] [Help]

View: OKL_QUICK_QUOTES_V

Product: OKL - Lease and Finance Management
Description: View for OKL_QUICK_QUOTES_B and OKL_QUICK_QUOTES_TL
Implementation/DBA Data: ViewAPPS.OKL_QUICK_QUOTES_V
View Text

SELECT QQH.ROWID
, QQH.ID
, QQH.OBJECT_VERSION_NUMBER
, QQH.ATTRIBUTE_CATEGORY
, QQH.ATTRIBUTE1
, QQH.ATTRIBUTE2
, QQH.ATTRIBUTE3
, QQH.ATTRIBUTE4
, QQH.ATTRIBUTE5
, QQH.ATTRIBUTE6
, QQH.ATTRIBUTE7
, QQH.ATTRIBUTE8
, QQH.ATTRIBUTE9
, QQH.ATTRIBUTE10
, QQH.ATTRIBUTE11
, QQH.ATTRIBUTE12
, QQH.ATTRIBUTE13
, QQH.ATTRIBUTE14
, QQH.ATTRIBUTE15
, QQH.CREATED_BY
, QQH.CREATION_DATE
, QQH.LAST_UPDATED_BY
, QQH.LAST_UPDATE_DATE
, QQH.LAST_UPDATE_LOGIN
, QQH.REFERENCE_NUMBER
, QQH.EXPECTED_START_DATE
, QQH.ORG_ID
, QQH.INV_ORG_ID
, QQH.CURRENCY_CODE
, QQH.TERM
, QQH.END_OF_TERM_OPTION_ID
, QQH.PRICING_METHOD
, QQH.LEASE_OPPORTUNITY_ID
, QQH.ORIGINATING_VENDOR_ID
, QQH.PROGRAM_AGREEMENT_ID
, QQH.SALES_REP_ID
, QQH.SALES_TERRITORY_ID
, QQH.STRUCTURED_PRICING
, QQH.LINE_LEVEL_PRICING
, QQH.RATE_TEMPLATE_ID
, QQH.RATE_CARD_ID
, QQH.LEASE_RATE_FACTOR
, QQH.TARGET_RATE_TYPE
, QQH.TARGET_RATE
, QQH.TARGET_AMOUNT
, QQH.TARGET_FREQUENCY
, QQH.TARGET_ARREARS
, QQH.TARGET_PERIODS
, QQH.IIR
, QQH.SUB_IIR
, QQH.BOOKING_YIELD
, QQH.SUB_BOOKING_YIELD
, QQH.PIRR
, QQH.SUB_PIRR
, QQH.AIRR
, QQH.SUB_AIRR
, QQHT.SHORT_DESCRIPTION
, QQHT.DESCRIPTION
, QQHT.COMMENTS
, QQH.STS_CODE
FROM OKL_QUICK_QUOTES_B QQH
, OKL_QUICK_QUOTES_TL QQHT
WHERE QQH.ID = QQHT.ID
AND QQHT.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
REFERENCE_NUMBER
EXPECTED_START_DATE
ORG_ID
INV_ORG_ID
CURRENCY_CODE
TERM
END_OF_TERM_OPTION_ID
PRICING_METHOD
LEASE_OPPORTUNITY_ID
ORIGINATING_VENDOR_ID
PROGRAM_AGREEMENT_ID
SALES_REP_ID
SALES_TERRITORY_ID
STRUCTURED_PRICING
LINE_LEVEL_PRICING
RATE_TEMPLATE_ID
RATE_CARD_ID
LEASE_RATE_FACTOR
TARGET_RATE_TYPE
TARGET_RATE
TARGET_AMOUNT
TARGET_FREQUENCY
TARGET_ARREARS
TARGET_PERIODS
IIR
SUB_IIR
BOOKING_YIELD
SUB_BOOKING_YIELD
PIRR
SUB_PIRR
AIRR
SUB_AIRR
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS
STS_CODE