FA Japanese Depreciable Assets Tax Summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Assets
Source: Japanese Depreciable Assets Tax Summary Report
Short Name: FADTXS
DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG
Run FA Japanese Depreciable Assets Tax Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select ta.CODE
      ,ta.NAME NAME
      ,ta.TAX_REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.SHORT_YEAR_DEPRN_FLAG) SHORT_YEAR_DEPRN_FLAG
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.BONUS_DEPRN_FLAG) BONUS_DEPRN_FLAG
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.NON_TAXABLE_ASSETS_FLAG) NON_TAXABLE_ASSETS_FLAG
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.TAX_STANDARD_EXCEPTION_FLAG) TAX_STANDARD_EXCEPTION_FLAG
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.SPECIAL_DEPRN_FLAG) SPECIAL_DEPRN_FLAG
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fnd_meaning('YES_NO',ta.DEPRN_METHOD_UNDER_TAX_LAW) DEPRN_METHOD_UNDER_TAX_LAW
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_METHOD_TYPE',decode(nvl(ta.DEPRN_METHOD_UNDER_TAX_LAW,'A'),'A','AMOUNT','R','RATE','AMOUNT')) DEPRN_METHOD_UNDER_TAX_LAW_D
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.BLUE_RETURN_FLAG) BLUE_RETURN_FLAG
      ,ta.ASSET_ADDRESS1 ASSET_ADDRESS1
      ,ta.ASSET_ADDRESS2 ASSET_ADDRESS2
      ,ta.ASSET_ADDRESS3 ASSET_ADDRESS3
      ,ta.PRINCIPAL_LOCATION_NUMBER PRINCIPAL_LOCATION_NUMBER
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.get_fa_meaning('JP_YES_NO',ta.LEASED_ASSETS_FLAG) LEASED_ASSETS_FLAG
      ,ta.LESSOR_NAME LESSOR_NAME
      ,ta.LESSOR_ADDRESS LESSOR_ADDRESS
      ,ta.LESSOR_PHONE LESSOR_PHONE
      ,ta.LOCATION_OWNERSHIP LOCATION_OWNERSHIP
      ,ta.OWNED_LOCATION_NUMBERS OWNED_LOCATION_NUMBERS
      ,ta.LEASED_LOCATION_NUMBERS LEASED_LOCATION_NUMBERS
      ,ta.REFERENCE_LINE1 REFERENCE_LINE1
      ,ta.REFERENCE_LINE2 REFERENCE_LINE2
      ,ta.REFERENCE_LINE3 REFERENCE_LINE3
      ,ta.REFERENCE_LINE4 REFERENCE_LINE4
      ,ta.REFERENCE_LINE5 REFERENCE_LINE5
      ,ta.REFERENCE_LINE6 REFERENCE_LINE6
      ,FA_JAPAN_DEP_TAX_SUMMARY_PKG.d_decisionformula(ta.CODE) DECISION
from FA_DEPRN_TAX_AUTHORITIES ta
where ta.code=nvl(:P_STATE,ta.code)
and ta.company_id = (select company_id 
                     from fa_deprn_tax_entities 
                     where book_type_code = :P_BOOK)
and exists 
(select 1 from FA_DEPRN_TAX_REP_ITF itf
where itf.request_id = :p_request_id
  and itf.book_type_code = :p_book
  and itf.year = :p_year
  and itf.state = ta.code) ORDER BY ta.CODE
Parameter Name SQL text Validation
Request ID 
 
 Number
Book 
 
 LOV Oracle
Year 
 
 Number
State 
 
 Char
Download
Related Blitz Reports
FA Depreciation Summary Tax Register (Russia) FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 Characters FA Japanese Detail by Asset Type (Addition/All Assets) Report 132 Characters XLA Distribution Links Summary GL Account Analysis (Distributions) FA Japanese Detail by Asset Type (Decrease Assets) GL Account Analysis 11g GL Account Analysis (Distributions) 11g FA Depreciation Reserve
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™