VIEW: APPS.JL_CO_FA_ASSET_APPRS_V

Source

View Text - Preformatted

SELECT jla.rowid row_id, jla.APPRAISAL_ID, jla.ASSET_NUMBER, jla.APPRAISAL_VALUE, jl_zz_fa_functions_pkg.asset_desc(jla.asset_number) description, jla.status, flkp.meaning status_desc, jla.LAST_UPDATE_DATE, jla.LAST_UPDATED_BY, jla.CREATION_DATE, jla.CREATED_BY, jla.LAST_UPDATE_LOGIN, jla.ATTRIBUTE_CATEGORY, jla.ATTRIBUTE1, jla.ATTRIBUTE2, jla.ATTRIBUTE3, jla.ATTRIBUTE4, jla.ATTRIBUTE5, jla.ATTRIBUTE6, jla.ATTRIBUTE7, jla.ATTRIBUTE8, jla.ATTRIBUTE9, jla.ATTRIBUTE10, jla.ATTRIBUTE11, jla.ATTRIBUTE12, jla.ATTRIBUTE13, jla.ATTRIBUTE14, jla.ATTRIBUTE15 from jl_co_fa_asset_apprs jla, fnd_lookups flkp WHERE jla.status = flkp.lookup_code and flkp.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS'

View Text - HTML Formatted

SELECT JLA.ROWID ROW_ID
, JLA.APPRAISAL_ID
, JLA.ASSET_NUMBER
, JLA.APPRAISAL_VALUE
, JL_ZZ_FA_FUNCTIONS_PKG.ASSET_DESC(JLA.ASSET_NUMBER) DESCRIPTION
, JLA.STATUS
, FLKP.MEANING STATUS_DESC
, JLA.LAST_UPDATE_DATE
, JLA.LAST_UPDATED_BY
, JLA.CREATION_DATE
, JLA.CREATED_BY
, JLA.LAST_UPDATE_LOGIN
, JLA.ATTRIBUTE_CATEGORY
, JLA.ATTRIBUTE1
, JLA.ATTRIBUTE2
, JLA.ATTRIBUTE3
, JLA.ATTRIBUTE4
, JLA.ATTRIBUTE5
, JLA.ATTRIBUTE6
, JLA.ATTRIBUTE7
, JLA.ATTRIBUTE8
, JLA.ATTRIBUTE9
, JLA.ATTRIBUTE10
, JLA.ATTRIBUTE11
, JLA.ATTRIBUTE12
, JLA.ATTRIBUTE13
, JLA.ATTRIBUTE14
, JLA.ATTRIBUTE15
FROM JL_CO_FA_ASSET_APPRS JLA
, FND_LOOKUPS FLKP
WHERE JLA.STATUS = FLKP.LOOKUP_CODE
AND FLKP.LOOKUP_TYPE = 'JLCO_FA_ASSET_APPRAISAL_STATUS'