Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_ASSET_MAINT_VIEW |
SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.DESCRIPTION
, AD.TAG_NUMBER
, AD.ASSET_CATEGORY_ID
, AD.SERIAL_NUMBER
, AD.ASSET_KEY_CCID
, AD.ASSET_TYPE
, AD.PARENT_ASSET_ID
, AD.MANUFACTURER_NAME
, AD.MODEL_NUMBER
, AD.PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, AD.IN_USE_FLAG
, AD.OWNED_LEASED
, AD.NEW_USED
, AD.UNIT_ADJUSTMENT_FLAG
, AD.ADD_COST_JE_FLAG
, AD.CONTEXT
, AD.LEASE_ID
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATED_BY
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.LAST_UPDATE_LOGIN
, AD.INVENTORIAL
, ME.BOOK_TYPE_CODE
FROM FA_ADDITIONS AD
, (SELECT DISTINCT ME1.ASSET_ID
, ME1.BOOK_TYPE_CODE
FROM FA_MAINT_EVENTS ME1
, FA_BOOK_CONTROLS_SEC BC
WHERE BC.BOOK_TYPE_CODE = ME1.BOOK_TYPE_CODE) ME
WHERE ME.ASSET_ID=AD.ASSET_ID