DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on FA_DISTRIBUTION_HISTORY

Line 270: FROM fa_distribution_history

266: CURSOR fa_dist_cur(p_asset_id IN number, p_book_type_code in varchar2) IS
267: SELECT location_id,
268: distribution_id,
269: units_assigned
270: FROM fa_distribution_history
271: WHERE asset_id = p_asset_id
272: AND book_type_code = p_book_type_code
273: AND date_ineffective is null
274: ORDER BY date_effective desc; -- latest one first