VIEW: APPS.OKL_LEASE_APPLICATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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