DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 2479: from fa_distribution_history

2475: select units_assigned,
2476: location_id,
2477: distribution_id,
2478: code_combination_id
2479: from fa_distribution_history
2480: where asset_id = p_asset_id
2481: and book_type_code = p_corporate_book
2482: and transaction_header_id_out is null
2483: and retirement_id is null;

Line 2690: from fa_distribution_history

2686: cursor l_dist_curs(p_asset_id IN NUMBER,
2687: p_corporate_book IN VARCHAR2) is
2688: select units_assigned,
2689: distribution_id
2690: from fa_distribution_history
2691: where asset_id = p_asset_id
2692: and book_type_code = p_corporate_book
2693: and transaction_header_id_out is null
2694: and retirement_id is null;