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

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
 
Related Blitz Reports
FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters FA Japanese Depreciable Assets Tax Summary FA Depreciation Summary Tax Register (Russia) JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use FA Mass Revaluation Preview - draft FA Hypothetical What If - draft FA Asset Impairments FA Asset Maintenance Report- Not Supported: Reserved For Future Use JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: