eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_LEASE_QUOTES_V

Source

View Text - Preformatted


SELECT LSQ.ROWID ROW_ID ,LSQ.ID ID ,LSQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,LSQ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY ,LSQ.ATTRIBUTE1 ATTRIBUTE1 ,LSQ.ATTRIBUTE2 ATTRIBUTE2 ,LSQ.ATTRIBUTE3 ATTRIBUTE3 ,LSQ.ATTRIBUTE4 ATTRIBUTE4 ,LSQ.ATTRIBUTE5 ATTRIBUTE5 ,LSQ.ATTRIBUTE6 ATTRIBUTE6 ,LSQ.ATTRIBUTE7 ATTRIBUTE7 ,LSQ.ATTRIBUTE8 ATTRIBUTE8 ,LSQ.ATTRIBUTE9 ATTRIBUTE9 ,LSQ.ATTRIBUTE10 ATTRIBUTE10 ,LSQ.ATTRIBUTE11 ATTRIBUTE11 ,LSQ.ATTRIBUTE12 ATTRIBUTE12 ,LSQ.ATTRIBUTE13 ATTRIBUTE13 ,LSQ.ATTRIBUTE14 ATTRIBUTE14 ,LSQ.ATTRIBUTE15 ATTRIBUTE15 ,LSQ.CREATED_BY CREATED_BY ,LSQ.CREATION_DATE CREATION_DATE ,LSQ.LAST_UPDATED_BY LAST_UPDATED_BY ,LSQ.LAST_UPDATE_DATE LAST_UPDATE_DATE ,LSQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,LSQ.REFERENCE_NUMBER REFERENCE_NUMBER ,LSQ.STATUS STATUS ,LSQ.PARENT_OBJECT_CODE PARENT_OBJECT_CODE ,LSQ.PARENT_OBJECT_ID PARENT_OBJECT_ID ,LSQ.VALID_FROM VALID_FROM ,LSQ.VALID_TO VALID_TO ,LSQ.CUSTOMER_BOOKCLASS CUSTOMER_BOOKCLASS ,LSQ.CUSTOMER_TAXOWNER CUSTOMER_TAXOWNER ,LSQ.EXPECTED_START_DATE EXPECTED_START_DATE ,LSQ.EXPECTED_FUNDING_DATE EXPECTED_FUNDING_DATE ,LSQ.EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE ,LSQ.PRICING_METHOD PRICING_METHOD ,LSQ.TERM TERM ,LSQ.PRODUCT_ID PRODUCT_ID ,LSQ.END_OF_TERM_OPTION_ID END_OF_TERM_OPTION_ID ,LSQ.STRUCTURED_PRICING STRUCTURED_PRICING ,LSQ.LINE_LEVEL_PRICING LINE_LEVEL_PRICING ,LSQ.RATE_TEMPLATE_ID RATE_TEMPLATE_ID ,LSQ.RATE_CARD_ID RATE_CARD_ID ,LSQ.LEASE_RATE_FACTOR LEASE_RATE_FACTOR ,LSQ.TARGET_RATE_TYPE TARGET_RATE_TYPE ,LSQ.TARGET_RATE TARGET_RATE ,LSQ.TARGET_AMOUNT TARGET_AMOUNT ,LSQ.TARGET_FREQUENCY TARGET_FREQUENCY ,LSQ.TARGET_ARREARS_YN TARGET_ARREARS_YN ,LSQ.TARGET_PERIODS TARGET_PERIODS ,LSQ.IIR IIR ,LSQ.BOOKING_YIELD BOOKING_YIELD ,LSQ.PIRR PIRR ,LSQ.AIRR AIRR ,LSQ.SUB_IIR SUB_IIR ,LSQ.SUB_BOOKING_YIELD SUB_BOOKING_YIELD ,LSQ.SUB_PIRR SUB_PIRR ,LSQ.SUB_AIRR SUB_AIRR ,LSQ.USAGE_CATEGORY USAGE_CATEGORY ,LSQ.USAGE_INDUSTRY_CLASS USAGE_INDUSTRY_CLASS ,LSQ.USAGE_INDUSTRY_CODE USAGE_INDUSTRY_CODE ,LSQ.USAGE_AMOUNT USAGE_AMOUNT ,LSQ.USAGE_LOCATION_ID USAGE_LOCATION_ID ,LSQ.PROPERTY_TAX_APPLICABLE PROPERTY_TAX_APPLICABLE ,LSQ.PROPERTY_TAX_BILLING_TYPE PROPERTY_TAX_BILLING_TYPE ,LSQ.UPFRONT_TAX_TREATMENT UPFRONT_TAX_TREATMENT ,LSQ.UPFRONT_TAX_STREAM_TYPE UPFRONT_TAX_STREAM_TYPE ,LSQ.TRANSFER_OF_TITLE TRANSFER_OF_TITLE ,LSQ.AGE_OF_EQUIPMENT AGE_OF_EQUIPMENT ,LSQ.PURCHASE_OF_LEASE PURCHASE_OF_LEASE ,LSQ.SALE_AND_LEASE_BACK SALE_AND_LEASE_BACK ,LSQ.INTEREST_DISCLOSED INTEREST_DISCLOSED ,LSQ.PRIMARY_QUOTE PRIMARY_QUOTE ,LSQT.SHORT_DESCRIPTION SHORT_DESCRIPTION ,LSQT.DESCRIPTION DESCRIPTION ,LSQT.COMMENTS COMMENTS ,LSQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID ,LSQ.LINE_INTENDED_USE LINE_INTENDED_USE FROM OKL_LEASE_QUOTES_B LSQ,OKL_LEASE_QUOTES_TL LSQT WHERE LSQ.ID = LSQT.ID AND LSQT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT LSQ.ROWID ROW_ID
, LSQ.ID ID
, LSQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LSQ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LSQ.ATTRIBUTE1 ATTRIBUTE1
, LSQ.ATTRIBUTE2 ATTRIBUTE2
, LSQ.ATTRIBUTE3 ATTRIBUTE3
, LSQ.ATTRIBUTE4 ATTRIBUTE4
, LSQ.ATTRIBUTE5 ATTRIBUTE5
, LSQ.ATTRIBUTE6 ATTRIBUTE6
, LSQ.ATTRIBUTE7 ATTRIBUTE7
, LSQ.ATTRIBUTE8 ATTRIBUTE8
, LSQ.ATTRIBUTE9 ATTRIBUTE9
, LSQ.ATTRIBUTE10 ATTRIBUTE10
, LSQ.ATTRIBUTE11 ATTRIBUTE11
, LSQ.ATTRIBUTE12 ATTRIBUTE12
, LSQ.ATTRIBUTE13 ATTRIBUTE13
, LSQ.ATTRIBUTE14 ATTRIBUTE14
, LSQ.ATTRIBUTE15 ATTRIBUTE15
, LSQ.CREATED_BY CREATED_BY
, LSQ.CREATION_DATE CREATION_DATE
, LSQ.LAST_UPDATED_BY LAST_UPDATED_BY
, LSQ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LSQ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LSQ.REFERENCE_NUMBER REFERENCE_NUMBER
, LSQ.STATUS STATUS
, LSQ.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
, LSQ.PARENT_OBJECT_ID PARENT_OBJECT_ID
, LSQ.VALID_FROM VALID_FROM
, LSQ.VALID_TO VALID_TO
, LSQ.CUSTOMER_BOOKCLASS CUSTOMER_BOOKCLASS
, LSQ.CUSTOMER_TAXOWNER CUSTOMER_TAXOWNER
, LSQ.EXPECTED_START_DATE EXPECTED_START_DATE
, LSQ.EXPECTED_FUNDING_DATE EXPECTED_FUNDING_DATE
, LSQ.EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE
, LSQ.PRICING_METHOD PRICING_METHOD
, LSQ.TERM TERM
, LSQ.PRODUCT_ID PRODUCT_ID
, LSQ.END_OF_TERM_OPTION_ID END_OF_TERM_OPTION_ID
, LSQ.STRUCTURED_PRICING STRUCTURED_PRICING
, LSQ.LINE_LEVEL_PRICING LINE_LEVEL_PRICING
, LSQ.RATE_TEMPLATE_ID RATE_TEMPLATE_ID
, LSQ.RATE_CARD_ID RATE_CARD_ID
, LSQ.LEASE_RATE_FACTOR LEASE_RATE_FACTOR
, LSQ.TARGET_RATE_TYPE TARGET_RATE_TYPE
, LSQ.TARGET_RATE TARGET_RATE
, LSQ.TARGET_AMOUNT TARGET_AMOUNT
, LSQ.TARGET_FREQUENCY TARGET_FREQUENCY
, LSQ.TARGET_ARREARS_YN TARGET_ARREARS_YN
, LSQ.TARGET_PERIODS TARGET_PERIODS
, LSQ.IIR IIR
, LSQ.BOOKING_YIELD BOOKING_YIELD
, LSQ.PIRR PIRR
, LSQ.AIRR AIRR
, LSQ.SUB_IIR SUB_IIR
, LSQ.SUB_BOOKING_YIELD SUB_BOOKING_YIELD
, LSQ.SUB_PIRR SUB_PIRR
, LSQ.SUB_AIRR SUB_AIRR
, LSQ.USAGE_CATEGORY USAGE_CATEGORY
, LSQ.USAGE_INDUSTRY_CLASS USAGE_INDUSTRY_CLASS
, LSQ.USAGE_INDUSTRY_CODE USAGE_INDUSTRY_CODE
, LSQ.USAGE_AMOUNT USAGE_AMOUNT
, LSQ.USAGE_LOCATION_ID USAGE_LOCATION_ID
, LSQ.PROPERTY_TAX_APPLICABLE PROPERTY_TAX_APPLICABLE
, LSQ.PROPERTY_TAX_BILLING_TYPE PROPERTY_TAX_BILLING_TYPE
, LSQ.UPFRONT_TAX_TREATMENT UPFRONT_TAX_TREATMENT
, LSQ.UPFRONT_TAX_STREAM_TYPE UPFRONT_TAX_STREAM_TYPE
, LSQ.TRANSFER_OF_TITLE TRANSFER_OF_TITLE
, LSQ.AGE_OF_EQUIPMENT AGE_OF_EQUIPMENT
, LSQ.PURCHASE_OF_LEASE PURCHASE_OF_LEASE
, LSQ.SALE_AND_LEASE_BACK SALE_AND_LEASE_BACK
, LSQ.INTEREST_DISCLOSED INTEREST_DISCLOSED
, LSQ.PRIMARY_QUOTE PRIMARY_QUOTE
, LSQT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, LSQT.DESCRIPTION DESCRIPTION
, LSQT.COMMENTS COMMENTS
, LSQ.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LSQ.LINE_INTENDED_USE LINE_INTENDED_USE
FROM OKL_LEASE_QUOTES_B LSQ
, OKL_LEASE_QUOTES_TL LSQT
WHERE LSQ.ID = LSQT.ID
AND LSQT.LANGUAGE = USERENV('LANG')