DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 2483: from fa_distribution_history

2479: select units_assigned,
2480: location_id,
2481: distribution_id,
2482: code_combination_id
2483: from fa_distribution_history
2484: where asset_id = p_asset_id
2485: and book_type_code = p_corporate_book
2486: and transaction_header_id_out is null
2487: and retirement_id is null;

Line 2694: from fa_distribution_history

2690: cursor l_dist_curs(p_asset_id IN NUMBER,
2691: p_corporate_book IN VARCHAR2) is
2692: select units_assigned,
2693: distribution_id
2694: from fa_distribution_history
2695: where asset_id = p_asset_id
2696: and book_type_code = p_corporate_book
2697: and transaction_header_id_out is null
2698: and retirement_id is null;