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

Description
Categories: BI Publisher
Application: Assets
Source: Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters
Short Name: FADTXA180
DB package: FA_JAPAN_DEP_TAX_ADDITION_PKG
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=: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,
    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     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
Page Size
 
Number
Location Structure ID
 
Number
Net Book Value
 
LOV Oracle
Report Type
 
LOV Oracle
State
 
Year
 
Number
Book
 
LOV Oracle
Request ID
 
Number
Ask a question