VIEW: APPS.OKL_LEASE_OPPORTUNITIES_V

Source

View Text - Preformatted

SELECT LOP.ID ,LOP.OBJECT_VERSION_NUMBER ,LOP.ATTRIBUTE_CATEGORY ,LOP.ATTRIBUTE1 ,LOP.ATTRIBUTE2 ,LOP.ATTRIBUTE3 ,LOP.ATTRIBUTE4 ,LOP.ATTRIBUTE5 ,LOP.ATTRIBUTE6 ,LOP.ATTRIBUTE7 ,LOP.ATTRIBUTE8 ,LOP.ATTRIBUTE9 ,LOP.ATTRIBUTE10 ,LOP.ATTRIBUTE11 ,LOP.ATTRIBUTE12 ,LOP.ATTRIBUTE13 ,LOP.ATTRIBUTE14 ,LOP.ATTRIBUTE15 ,LOP.CREATED_BY ,LOP.CREATION_DATE ,LOP.LAST_UPDATED_BY ,LOP.LAST_UPDATE_DATE ,LOP.LAST_UPDATE_LOGIN ,LOP.REFERENCE_NUMBER ,LOP.STATUS ,LOP.VALID_FROM ,LOP.EXPECTED_START_DATE ,LOP.ORG_ID ,LOP.INV_ORG_ID ,LOP.PROSPECT_ID ,LOP.PROSPECT_ADDRESS_ID ,LOP.CUST_ACCT_ID ,LOP.CURRENCY_CODE ,LOP.CURRENCY_CONVERSION_TYPE ,LOP.CURRENCY_CONVERSION_RATE ,LOP.CURRENCY_CONVERSION_DATE ,LOP.PROGRAM_AGREEMENT_ID ,LOP.MASTER_LEASE_ID ,LOP.SALES_REP_ID ,LOP.SALES_TERRITORY_ID ,LOP.SUPPLIER_ID ,LOP.DELIVERY_DATE ,LOP.FUNDING_DATE ,LOP.PROPERTY_TAX_APPLICABLE ,LOP.PROPERTY_TAX_BILLING_TYPE ,LOP.UPFRONT_TAX_TREATMENT ,LOP.INSTALL_SITE_ID ,LOP.USAGE_CATEGORY ,LOP.USAGE_INDUSTRY_CLASS ,LOP.USAGE_INDUSTRY_CODE ,LOP.USAGE_AMOUNT ,LOP.USAGE_LOCATION_ID ,LOP.ORIGINATING_VENDOR_ID ,LOPT.SHORT_DESCRIPTION ,LOPT.DESCRIPTION ,LOPT.COMMENTS ,LOP.LEGAL_ENTITY_ID ,LOP.LINE_INTENDED_USE FROM OKL_LEASE_OPPORTUNITIES_B LOP,OKL_LEASE_OPPORTUNITIES_TL LOPT WHERE LOP.ID = LOPT.ID AND LOPT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT LOP.ID
, LOP.OBJECT_VERSION_NUMBER
, LOP.ATTRIBUTE_CATEGORY
, LOP.ATTRIBUTE1
, LOP.ATTRIBUTE2
, LOP.ATTRIBUTE3
, LOP.ATTRIBUTE4
, LOP.ATTRIBUTE5
, LOP.ATTRIBUTE6
, LOP.ATTRIBUTE7
, LOP.ATTRIBUTE8
, LOP.ATTRIBUTE9
, LOP.ATTRIBUTE10
, LOP.ATTRIBUTE11
, LOP.ATTRIBUTE12
, LOP.ATTRIBUTE13
, LOP.ATTRIBUTE14
, LOP.ATTRIBUTE15
, LOP.CREATED_BY
, LOP.CREATION_DATE
, LOP.LAST_UPDATED_BY
, LOP.LAST_UPDATE_DATE
, LOP.LAST_UPDATE_LOGIN
, LOP.REFERENCE_NUMBER
, LOP.STATUS
, LOP.VALID_FROM
, LOP.EXPECTED_START_DATE
, LOP.ORG_ID
, LOP.INV_ORG_ID
, LOP.PROSPECT_ID
, LOP.PROSPECT_ADDRESS_ID
, LOP.CUST_ACCT_ID
, LOP.CURRENCY_CODE
, LOP.CURRENCY_CONVERSION_TYPE
, LOP.CURRENCY_CONVERSION_RATE
, LOP.CURRENCY_CONVERSION_DATE
, LOP.PROGRAM_AGREEMENT_ID
, LOP.MASTER_LEASE_ID
, LOP.SALES_REP_ID
, LOP.SALES_TERRITORY_ID
, LOP.SUPPLIER_ID
, LOP.DELIVERY_DATE
, LOP.FUNDING_DATE
, LOP.PROPERTY_TAX_APPLICABLE
, LOP.PROPERTY_TAX_BILLING_TYPE
, LOP.UPFRONT_TAX_TREATMENT
, LOP.INSTALL_SITE_ID
, LOP.USAGE_CATEGORY
, LOP.USAGE_INDUSTRY_CLASS
, LOP.USAGE_INDUSTRY_CODE
, LOP.USAGE_AMOUNT
, LOP.USAGE_LOCATION_ID
, LOP.ORIGINATING_VENDOR_ID
, LOPT.SHORT_DESCRIPTION
, LOPT.DESCRIPTION
, LOPT.COMMENTS
, LOP.LEGAL_ENTITY_ID
, LOP.LINE_INTENDED_USE
FROM OKL_LEASE_OPPORTUNITIES_B LOP
, OKL_LEASE_OPPORTUNITIES_TL LOPT
WHERE LOP.ID = LOPT.ID
AND LOPT.LANGUAGE = USERENV('LANG')