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