DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_MC_BOOKS

Line 3517: ,fa_mc_books inbk

3513: ,outbk.salvage_value outbk_salvage_value
3514: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3515: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3516: FROM fa_transaction_headers th
3517: ,fa_mc_books inbk
3518: ,fa_mc_books outbk
3519: WHERE inbk.asset_id = p_asset_id
3520: AND inbk.book_type_code = p_book_type_code
3521: AND outbk.asset_id (+) = p_asset_id -- inbk.asset_id

Line 3518: ,fa_mc_books outbk

3514: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3515: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3516: FROM fa_transaction_headers th
3517: ,fa_mc_books inbk
3518: ,fa_mc_books outbk
3519: WHERE inbk.asset_id = p_asset_id
3520: AND inbk.book_type_code = p_book_type_code
3521: AND outbk.asset_id (+) = p_asset_id -- inbk.asset_id
3522: AND outbk.book_type_code (+) = p_book_type_code -- inbk.book_type_code

Line 3552: ,fa_mc_books inbk

3548: ,outbk.salvage_value outbk_salvage_value
3549: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3550: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3551: FROM fa_transaction_headers th
3552: ,fa_mc_books inbk
3553: ,fa_mc_books outbk
3554: WHERE inbk.asset_id = p_asset_id
3555: AND inbk.book_type_code = p_book_type_code
3556: AND outbk.asset_id (+) = p_asset_id

Line 3553: ,fa_mc_books outbk

3549: ,inbk.allowed_deprn_limit_amount inbk_allowed_deprn_limit_amt
3550: ,outbk.allowed_deprn_limit_amount outbk_allowed_deprn_limit_amt
3551: FROM fa_transaction_headers th
3552: ,fa_mc_books inbk
3553: ,fa_mc_books outbk
3554: WHERE inbk.asset_id = p_asset_id
3555: AND inbk.book_type_code = p_book_type_code
3556: AND outbk.asset_id (+) = p_asset_id
3557: AND outbk.book_type_code (+) = p_book_type_code

Line 5162: from fa_mc_books bk

5158: select 'POSTED'
5159: from fa_mc_impairments
5160: where status = 'POSTED'
5161: and (asset_id = p_asset_id or cash_generating_unit_id = (select cash_generating_unit_id
5162: from fa_mc_books bk
5163: where bk.asset_id = p_asset_id
5164: and bk.book_type_code = p_book
5165: and bk.date_ineffective is null))
5166: and book_type_code = p_book