Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_LEASE_APPLICATIONS_B and OKL_LEASE_APPLICATIONS_TL |
Implementation/DBA Data: | APPS.OKL_LEASE_APPLICATIONS_V |
SELECT LAP.ROWID
, LAP.ID
, LAP.OBJECT_VERSION_NUMBER
, LAP.ATTRIBUTE_CATEGORY
, LAP.ATTRIBUTE1
, LAP.ATTRIBUTE2
, LAP.ATTRIBUTE3
, LAP.ATTRIBUTE4
, LAP.ATTRIBUTE5
, LAP.ATTRIBUTE6
, LAP.ATTRIBUTE7
, LAP.ATTRIBUTE8
, LAP.ATTRIBUTE9
, LAP.ATTRIBUTE10
, LAP.ATTRIBUTE11
, LAP.ATTRIBUTE12
, LAP.ATTRIBUTE13
, LAP.ATTRIBUTE14
, LAP.ATTRIBUTE15
, LAP.CREATED_BY
, LAP.CREATION_DATE
, LAP.LAST_UPDATED_BY
, LAP.LAST_UPDATE_DATE
, LAP.LAST_UPDATE_LOGIN
, LAP.REFERENCE_NUMBER
, LAP.APPLICATION_STATUS
, LAP.VALID_FROM
, LAP.VALID_TO
, LAP.ORG_ID
, LAP.INV_ORG_ID
, LAP.PROSPECT_ID
, LAP.PROSPECT_ADDRESS_ID
, LAP.CUST_ACCT_ID
, LAP.INDUSTRY_CLASS
, LAP.INDUSTRY_CODE
, LAP.CURRENCY_CODE
, LAP.CURRENCY_CONVERSION_TYPE
, LAP.CURRENCY_CONVERSION_RATE
, LAP.CURRENCY_CONVERSION_DATE
, LAP.LEASEAPP_TEMPLATE_ID
, LAP.PARENT_LEASEAPP_ID
, LAP.CREDIT_LINE_ID
, LAP.PROGRAM_AGREEMENT_ID
, LAP.MASTER_LEASE_ID
, LAP.SALES_REP_ID
, LAP.SALES_TERRITORY_ID
, LAP.ORIGINATING_VENDOR_ID
, LAP.LEASE_OPPORTUNITY_ID
, LAP.CR_EXP_DAYS
, LAPT.SHORT_DESCRIPTION
, LAPT.COMMENTS
, LAP.ACTION
, LAP.ORIG_STATUS
FROM OKL_LEASE_APPLICATIONS_B LAP
, OKL_LEASE_APPLICATIONS_TL LAPT
WHERE LAP.ID = LAPT.ID
AND LAPT.LANGUAGE = USERENV('LANG')