DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_BOOKS_MRC_V

Line 3274: fa_books_mrc_v inbk,

3270: , sum(inbk.salvage_value - nvl(outbk.salvage_value, 0))
3271: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3272: nvl(outbk.allowed_deprn_limit_amount, 0))
3273: from fa_transaction_headers th,
3274: fa_books_mrc_v inbk,
3275: fa_books_mrc_v outbk
3276: where inbk.asset_id = p_asset_id
3277: and inbk.book_type_code = p_book_type_code
3278: and outbk.asset_id(+) = p_asset_id

Line 3275: fa_books_mrc_v outbk

3271: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3272: nvl(outbk.allowed_deprn_limit_amount, 0))
3273: from fa_transaction_headers th,
3274: fa_books_mrc_v inbk,
3275: fa_books_mrc_v outbk
3276: where inbk.asset_id = p_asset_id
3277: and inbk.book_type_code = p_book_type_code
3278: and outbk.asset_id(+) = p_asset_id
3279: and outbk.book_type_code(+) = p_book_type_code