FA Japanese Depreciable Assets Tax Summary

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

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