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

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Assets
Source: Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters
Short Name: FADTXA132
DB package: FA_JAPAN_DEP_TAX_ADDITION_PKG
Run FA Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Request ID
 
Number
Book
 
LOV Oracle
Year
 
Number
State
 
Char
Report Type
 
LOV Oracle
Net Book Value
 
LOV Oracle
Blitz Report™