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

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