FA Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters

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,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_REASON_CODE,DTI.ADDDEC_REASON_CODE) ALL_REASON_CODE,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_DESCRIPTION,DTI.ADDDEC_DESCRIPTION) ALL_DESCRIPTION,
	DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_REASON_CODE,DTI.ADDDEC_REASON_CODE) ADDDEC_REASON_CODE,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_DESCRIPTION,DTI.ADDDEC_DESCRIPTION) 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=:CODE
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,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_REASON_CODE,DTI.ADDDEC_REASON_CODE) ALL_REASON_CODE,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_DESCRIPTION,DTI.ADDDEC_DESCRIPTION) ALL_DESCRIPTION,
	DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_REASON_CODE,DTI.ADDDEC_REASON_CODE) ADDDEC_REASON_CODE,
    DECODE(:P_CLASSIFICATION,'ALL',DTI.ALL_DESCRIPTION,DTI.ADDDEC_DESCRIPTION) 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     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=:CODE
order by STATE,TAX_ASSET_TYPE, ASSET_ID