VIEW: APPS.FA_ASSET_MAINT_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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