FA Implementation Exception Report for UK Local Authority Accounting Implementation

 select b.asset_number,count(1) PENDING_TRX_ASSET_CNT from fa_transaction_headers a,fa_additions_v b 
				   where  a.asset_id = b.asset_id
					and a.book_type_code = :P_FA_BOOK 
					and to_date(a.transaction_date_entered) > 
						(select  to_date(calendar_period_open_date) from fa_deprn_periods 
						 where book_type_code = :P_FA_BOOK  and period_close_date is null)
					group by a.asset_id,b.asset_number
					having count(1) > 0