Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_CO_FA_ASSET_APPRS_V |
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'