FA Depreciation Summary Tax Register (Russia)

select
	DTI.STATE 	STATE,
	DTI.ASSET_NUMBER,
	DTI.ASSET_DESCRIPTION,
	DTI.TAX_ASSET_TYPE	TAX_ASSET_TYPE,
	DTI.ASSET_ID	ASSET_ID,
	DTI.END_UNITS_ASSIGNED,
	DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED	ADD_UNITS_ASSIGNED,
	DTI.END_COST,
	DTI.INCREASE_COST,
	decode(:p_decision_cost,'AUTO',DTI.EVALUATED_NBV, DTI.THEORETICAL_NBV)	ASSET_NBV,
	DTI.ERA_NAME_NUM,
	DTI.ADD_ERA_YEAR,
	DTI.ADD_MONTH,
	DTI.END_LIFE,
	DTI.THEORETICAL_RESIDUAL_RATE	ASSET_RESIDUAL_RATE,
	DTI.EXCEPTION_CODE,
	DTI.EXCEPTION_RATE,
	DTI.THEORETICAL_TAXABLE_COST	ASSET_TAXABLE_COST,
	DTI.ALL_REASON_CODE,
	DTI.ALL_DESCRIPTION,
	DTI.ADDDEC_REASON_CODE,
	DTI.ADDDEC_DESCRIPTION	
from	FA_DEPRN_TAX_REP_ITF	DTI
where   &H_WHERE
and	REQUEST_ID = :p_request_id
and     BOOK_TYPE_CODE = :p_book
and	STATE = nvl(:p_state,state)
and	YEAR = :p_year
and 	((:check_amount >= 0 and nvl(:p_decision_cost,'N') <>'EVALUATED')
	or (:check_amount < 0 and nvl(:p_decision_cost,'N') = 'THEORETICAL'))
UNION
select
	DTI.STATE		STATE,
	DTI.ASSET_NUMBER,
	DTI.ASSET_DESCRIPTION,
	DTI.TAX_ASSET_TYPE	TAX_ASSET_TYPE,
	DTI.ASSET_ID	ASSET_ID,
	DTI.END_UNITS_ASSIGNED,
	DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED	ADD_UNITS_ASSIGNED,
	DTI.END_COST,
	DTI.INCREASE_COST,
	DTI.EVALUATED_NBV	ASSET_NBV,
	DTI.ERA_NAME_NUM,
	DTI.ADD_ERA_YEAR,
	DTI.ADD_MONTH,
	DTI.END_LIFE,
	DTI.EVALUATED_RESIDUAL_RATE	ASSET_RESIDUAL_RATE,
	DTI.EXCEPTION_CODE,
	DTI.EXCEPTION_RATE,
	DTI.EVALUATED_TAXABLE_COST	ASSET_TAXABLE_COST,
	DTI.ALL_REASON_CODE,
	DTI.ALL_DESCRIPTION,
	DTI.ADDDEC_REASON_CODE,
	DTI.ADDDEC_DESCRIPTION
from 	FA_DEPRN_TAX_REP_ITF	DTI
where 	&H_WHERE
and           REQUEST_ID= :p_request_id
and           BOOK_TYPE_CODE = :p_book
and	STATE = nvl(:p_state,state)
and 	YEAR = :p_year
and	((:check_amount < 0 and nvl(:p_decision_cost,'N') <>'THEORETICAL')
	or (:check_amount >= 0 and nvl(:p_decision_cost,'N') = 'EVALUATED')) 
 and DTI.STATE=:sum_state
order by STATE,TAX_ASSET_TYPE, ASSET_ID