DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 210: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY

206: WHERE asset_id = p_asset_id
207: AND date_ineffective IS NULL;
208:
209: CURSOR get_dh_units IS
210: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY
211: WHERE asset_id = p_asset_id
212: AND date_ineffective is NULL;
213: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_units';
214: BEGIN

Line 769: fa_distribution_history dh,

765: dh.location_id,
766: dh.assigned_to,
767: ad.asset_number
768: from fa_book_controls bc,
769: fa_distribution_history dh,
770: fa_additions ad
771: where dh.asset_id = p_asset_hdr_rec.asset_id
772: and dh.book_type_code = bc.distribution_source_book
773: and bc.book_type_code = p_asset_hdr_rec.book_type_code