VIEW: APPS.OKL_LEASEAPP_TEMPL_VERSIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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