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 ...
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
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 Name | SQL text | Validation | |
---|---|---|---|
Request ID | Number | ||
Book | LOV Oracle | ||
Year | Number | ||
State | |||
Location Structure ID | Number |