[Home] [Help]
180: cursor c_assets_uom is
181: select ad.asset_number,
182: bk.asset_id
183: from fa_additions_b ad,
184: fa_books bk,
185: fa_mass_changes mch,
186: fa_methods me
187: where mch.mass_change_id = p_mass_change_id
188: and bk.transaction_header_id_out is null
230: bk.date_effective,
231: bk.date_placed_in_service,
232: bk.group_asset_id
233: from fa_additions_b ad,
234: fa_books bk,
235: fa_mass_changes mch
236: where ad.asset_number >=
237: nvl(mch.from_asset_number,
238: ad.asset_number)
507: value1 => l_asset_number(l_loop_count));
508:
509: BEGIN
510:
511: update fa_books bk
512: set bk.unit_of_measure = l_to_uom,
513: bk.last_update_date = sysdate,
514: bk.last_updated_by = l_userid,
515: bk.last_update_login = l_login,
618:
619: select count(*)
620: into l_count
621: from fa_book_controls bc,
622: fa_books bk,
623: fa_methods me
624: where bk.book_type_code = bc.book_type_code
625: and bk.asset_id = l_asset_id(l_loop_count)
626: and bk.date_ineffective is null
647:
648: select count(*)
649: into l_count
650: from fa_book_controls bc,
651: fa_books bk,
652: fa_methods me
653: where bk.book_type_code = bc.distribution_source_book
654: and bk.asset_id = l_asset_id(l_loop_count)
655: and bk.date_ineffective is null
815: l_old_salvage_value,
816: l_old_deprn_limit_type,
817: l_old_deprn_limit,
818: l_old_deprn_limit_amount
819: from fa_books
820: where book_type_code = l_book_type_code
821: and asset_id = l_asset_id(l_loop_count)
822: and transaction_header_id_out is null;
823:
898: -- Update UOM in TAX books if PROD method
899: if (nvl(l_from_uom, 'NULL') <> nvl(l_to_uom, 'NULL')) then
900:
901: -- 'FA_MASSCHG_UPDATE_TAX_UOM'
902: update fa_books bk
903: set bk.unit_of_measure = l_to_uom,
904: bk.last_update_date = sysdate,
905: bk.last_updated_by = l_userid,
906: bk.last_update_login = l_login,