FA Depreciation Summary Tax Register (Russia)
Description
Categories: BI Publisher
Application: Assets
Source: Depreciation Summary Tax Register (Russia)
Short Name: FADSTR
DB package: FADTXA
Source: Depreciation Summary Tax Register (Russia)
Short Name: FADSTR
DB package: FADTXA
Run
FA Depreciation Summary Tax Register (Russia) and other Oracle EBS reports with Blitz Report™ on our demo environment
select DTI.STATE STATE, DTI.ASSET_NUMBER, DTI.ASSET_DESCRIPTION, DTI.TAX_ASSET_TYPE TAX_ASSET_TYPE, DTI.ASSET_ID ASSET_ID, DTI.END_UNITS_ASSIGNED, DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED ADD_UNITS_ASSIGNED, DTI.END_COST, DTI.INCREASE_COST, decode(:p_decision_cost,'AUTO',DTI.EVALUATED_NBV, DTI.THEORETICAL_NBV) ASSET_NBV, DTI.ERA_NAME_NUM, DTI.ADD_ERA_YEAR, DTI.ADD_MONTH, DTI.END_LIFE, DTI.THEORETICAL_RESIDUAL_RATE ASSET_RESIDUAL_RATE, DTI.EXCEPTION_CODE, DTI.EXCEPTION_RATE, DTI.THEORETICAL_TAXABLE_COST ASSET_TAXABLE_COST, DTI.ALL_REASON_CODE, DTI.ALL_DESCRIPTION, DTI.ADDDEC_REASON_CODE, DTI.ADDDEC_DESCRIPTION from FA_DEPRN_TAX_REP_ITF DTI where &H_WHERE and REQUEST_ID = :p_request_id and BOOK_TYPE_CODE = :p_book and STATE = nvl(:p_state,state) and YEAR = :p_year and ((:check_amount >= 0 and nvl(:p_decision_cost,'N') <>'EVALUATED') or (:check_amount < 0 and nvl(:p_decision_cost,'N') = 'THEORETICAL')) UNION select DTI.STATE STATE, DTI.ASSET_NUMBER, DTI.ASSET_DESCRIPTION, DTI.TAX_ASSET_TYPE TAX_ASSET_TYPE, DTI.ASSET_ID ASSET_ID, DTI.END_UNITS_ASSIGNED, DTI.END_UNITS_ASSIGNED - DTI.START_UNITS_ASSIGNED ADD_UNITS_ASSIGNED, DTI.END_COST, DTI.INCREASE_COST, DTI.EVALUATED_NBV ASSET_NBV, DTI.ERA_NAME_NUM, DTI.ADD_ERA_YEAR, DTI.ADD_MONTH, DTI.END_LIFE, DTI.EVALUATED_RESIDUAL_RATE ASSET_RESIDUAL_RATE, DTI.EXCEPTION_CODE, DTI.EXCEPTION_RATE, DTI.EVALUATED_TAXABLE_COST ASSET_TAXABLE_COST, DTI.ALL_REASON_CODE, DTI.ALL_DESCRIPTION, DTI.ADDDEC_REASON_CODE, DTI.ADDDEC_DESCRIPTION from FA_DEPRN_TAX_REP_ITF DTI where &H_WHERE and REQUEST_ID= :p_request_id and BOOK_TYPE_CODE = :p_book and STATE = nvl(:p_state,state) and YEAR = :p_year and ((:check_amount < 0 and nvl(:p_decision_cost,'N') <>'THEORETICAL') or (:check_amount >= 0 and nvl(:p_decision_cost,'N') = 'EVALUATED')) and DTI.STATE=:sum_state order by STATE,TAX_ASSET_TYPE, ASSET_ID |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book Name |
|
LOV Oracle | |
Period Name |
|
LOV Oracle |