Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_CO_FA_APPRAISAL_BOOKS_V |
SELECT A.ROWID
, A.APPRAISAL_ID
, A.BOOK_TYPE_CODE
, B.BOOK_TYPE_NAME
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM JL_CO_FA_APPRAISAL_BOOKS A
, FA_BOOK_CONTROLS B
WHERE A.BOOK_TYPE_CODE = B.BOOK_TYPE_CODE