FA Japanese Depreciable Assets Tax Summary
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
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 |