VIEW: APPS.OKL_QUICK_QUOTES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')