Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_LEASEAPP_TEMPL_VERSIONS_B and OKL_LEASEAPP_TEMPL_VERSIONS_TL |
Implementation/DBA Data: | APPS.OKL_LEASEAPP_TEMPL_VERSIONS_V |
SELECT LAV.ROWID ROW_ID
, LAV.ID ID
, LAV.OBJECT_VERSION_NUMBER
, LAV.ATTRIBUTE_CATEGORY
, LAV.ATTRIBUTE1
, LAV.ATTRIBUTE2
, LAV.ATTRIBUTE3
, LAV.ATTRIBUTE4
, LAV.ATTRIBUTE5
, LAV.ATTRIBUTE6
, LAV.ATTRIBUTE7
, LAV.ATTRIBUTE8
, LAV.ATTRIBUTE9
, LAV.ATTRIBUTE10
, LAV.ATTRIBUTE11
, LAV.ATTRIBUTE12
, LAV.ATTRIBUTE13
, LAV.ATTRIBUTE14
, LAV.ATTRIBUTE15
, LAV.CREATED_BY
, LAV.CREATION_DATE
, LAV.LAST_UPDATED_BY
, LAV.LAST_UPDATE_DATE
, LAV.LAST_UPDATE_LOGIN
, LAV.VERSION_NUMBER VERSION_NUMBER
, LAV.VERSION_STATUS VERSION_STATUS
, LAV.LEASEAPP_TEMPLATE_ID LEASEAPP_TEMPLATE_ID
, LAV.VALID_FROM VALID_FROM
, LAV.VALID_TO VALID_TO
, LAV.CHECKLIST_ID
, LAV.CONTRACT_TEMPLATE_ID
, LAVT.SHORT_DESCRIPTION SHORT_DESCRIPTION
FROM OKL_LEASEAPP_TEMPL_VERSIONS_B LAV
, OKL_LEASEAPP_TEMPL_VERSIONS_TL LAVT
WHERE LAV.ID = LAVT.ID
AND LAVT.LANGUAGE = USERENV('LANG')