FA Implementation Exception Report for UK Local Authority Accounting Implementation
Description
Categories: BI Publisher
Application: Assets
Source: Implementation Exception Report for UK Local Authority Accounting Implementation
Short Name: FASRPREEX
DB package: FA_SORP_UPG_PKG
Source: Implementation Exception Report for UK Local Authority Accounting Implementation
Short Name: FASRPREEX
DB package: FA_SORP_UPG_PKG
Run
FA Implementation Exception Report for UK Local Authority Accounting Implementation and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Asset Book |
|
LOV Oracle | |
Display Mode |
|
LOV Oracle |