DBA Data[Home] [Help]

APPS.CSE_FA_TXN_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 660: FROM fa_distribution_history

656: units_assigned,
657: transaction_units,
658: location_id,
659: assigned_to
660: FROM fa_distribution_history
661: WHERE retirement_id = p_retirement_id;
662:
663: BEGIN
664: x_return_status := fnd_api.g_ret_sts_success;

Line 773: FROM fa_distribution_history

769: CURSOR fa_dist_cur(p_asset_id number,p_book_type_code varchar2, p_fa_location_id number) IS
770: SELECT distribution_id,
771: assigned_to,
772: units_assigned
773: FROM fa_distribution_history
774: WHERE asset_id = p_asset_id
775: AND book_type_code = p_book_type_code
776: AND location_id = p_fa_location_id
777: AND date_ineffective is null;