Oracle EBS FA摊销调整框控制逻辑
cursor check_amort is
select 'YES'
from fa_transaction_headers
where book_type_code = :fa_books_header.book_type_code
and asset_id = :fa_books_header.asset_id
and (transaction_subtype = 'AMORTIZED' OR transaction_key = 'UA')
and rownum < 2;
摊销调整 check box 控制逻辑
:fa_books_header.amortize_adj := 'NO';
--
OPEN check_amort;
FETCH check_amort INTO check_flag;
if (check_amort%found) then
:fa_books_header.amortize_adj := 'YES';
end if;
CLOSE check_amort;
--刘轶鹤