FA Japanese Depreciable Assets Tax Summary

Description
Categories: BI Publisher
Columns: Code, Name, Tax Registration Number, Short Year Deprn Flag, Bonus Deprn Flag, Non Taxable Assets Flag, Tax Standard Exception Flag, Special Deprn Flag, Deprn Method Under Tax Law, Deprn Method Under Tax Law D ...
Application: Assets
Source: Japanese Depreciable Assets Tax Summary Report
Short Name: FADTXS
DB package: FA_JAPAN_DEP_TAX_SUMMARY_PKG
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 NameSQL textValidation
Request ID
 
Number
Book
 
LOV Oracle
Year
 
Number
State
 
Location Structure ID
 
Number