DBA Data[Home] [Help]

APPS.CSE_FA_TXN_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 467: FROM fa_distribution_history

463: units_assigned,
464: transaction_units,
465: location_id,
466: assigned_to
467: FROM fa_distribution_history
468: WHERE retirement_id = p_retirement_id;
469:
470: BEGIN
471: x_return_status := fnd_api.g_ret_sts_success;

Line 580: FROM fa_distribution_history

576: CURSOR fa_dist_cur(p_asset_id number,p_book_type_code varchar2, p_fa_location_id number) IS
577: SELECT distribution_id,
578: assigned_to,
579: units_assigned
580: FROM fa_distribution_history
581: WHERE asset_id = p_asset_id
582: AND book_type_code = p_book_type_code
583: AND location_id = p_fa_location_id
584: AND date_ineffective is null;