JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- Application
- Regional Localizations
- Source
- Statutory Asset Cost/Reserve Detail Report (XML) - Not Supported: Reserved For Future Use
- Short Name
- JGZZFAAD_XML
- DB package
- JG_JGZZFAAD_XMLP_PKG
Imported from BI Publisher
Statutory Asset Cost/Reserve Detail Report
Statutory Asset Cost/Reserve Detail Report
SQL 63 lines
select i.asset_number, i.company, substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account, substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_acct, i.account, i.account_description, i.cost_account, i.date_placed_in_service, round(i.stl_depreciation_rate, 2) stl_depreciation_rate, i.concat_vendor_name vendor_name, i.concat_invoice_number invoice_number, i.concat_location location, i.concat_retirement_type retirement_type, nvl(sum(i.cost_begin_balance), 0) cost_begin_balance, nvl(sum(i.begin_balance), 0) begin_balance, nvl(sum(&lp_dynamic_col), 0) additions, nvl(sum(i.revaluations), 0) revaluations, nvl(sum(i.retirements), 0) * -1 retirements, nvl(sum(i.reclasses), 0) reclasses, nvl(sum(i.adjustments), 0) adjustments, nvl(sum(i.end_balance), 0) end_balance, JG_JGZZFAAD_XMLP_PKG.cf_pareant_acct_descrformula(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_parent_acct_descr, -- JG_JGZZFAAD_XMLP_PKG.cf_begin_balanceformula(:cs_begin_balance_rtot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_additions_cfformula(:cs_additions_rtot, nvl(sum(i.additions), 0)) cf_additions_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_retirements_cfformula(:cs_retirements_rtot, nvl(sum(i.retirements), 0) * -1) cf_retirements_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_revaluations_cfformula(:cs_revaluations_rtot, nvl(sum(i.revaluations), 0)) cf_revaluations_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_reclasses_cfformula(:cs_reclasses_rtot, nvl(sum(i.reclasses), 0)) cf_reclasses_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_adjustments_cfformula(:cs_adjustments_rtot, nvl(sum(i.adjustments), 0)) cf_adjustments_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_cfformul(:cs_cost_begin_balance_rtot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_cf, -- JG_JGZZFAAD_XMLP_PKG.cf_end_balance_cfformula(:cs_end_balance_rtot, nvl(sum(i.end_balance), 0)) cf_end_balance_cf, JG_JGZZFAAD_XMLP_PKG.cf_page_parent_acct_descrformu(substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH), substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH)) CF_page_parent_acct_descr -- JG_JGZZFAAD_XMLP_PKG.cf_cost_begin_balance_reptotfo(:CS_cost_begin_balance_reptot, nvl(sum(i.cost_begin_balance), 0)) cf_cost_begin_balance_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_begin_balance_reptotformula(:CS_begin_bal_reptot, nvl(sum(i.begin_balance), 0)) cf_begin_balance_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_additions_reptotformula(:CS_additions_reptot, nvl(sum(i.additions), 0)) cf_additions_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_adjustments_reptotformula(:CS_adjustments_reptot, nvl(sum(i.adjustments), 0)) cf_adjustments_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_reclases_reptotformula(:CS_reclasses_reptot, nvl(sum(i.reclasses), 0)) cf_reclasses_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_retirements_reptotformula(:CS_retirements_reptot, nvl(sum(i.retirements), 0) * -1) cf_retirements_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_revaluations_reptotformula(:CS_revaluations_reptot, nvl(sum(i.revaluations), 0)) cf_revaluations_reptot, -- JG_JGZZFAAD_XMLP_PKG.cf_end_balance_reptotformula(:CS_end_balance_reptot, nvl(sum(i.end_balance), 0)) cf_end_balance_reptot from fa_balances_rep_itf i where i.request_id = :P_CONC_REQUEST_ID and i.company = :P_BALANCING_SEGMENT group by i.asset_number, i.company, substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH), substr(i.cost_account, 1, :P_PRECISION * :P_PRECISION_WIDTH), i.account, i.account_description, i.cost_account, i.date_placed_in_service, round(i.stl_depreciation_rate, 2), i.concat_vendor_name, i.concat_invoice_number, i.concat_location, i.concat_retirement_type order by i.cost_account, i.asset_number |
Parameters 10
| Parameter | Type | List of values SQL |
|---|---|---|
| Report Type | LOV Oracle | |
| Official Run | LOV Oracle | |
| Book | LOV Oracle | |
| Balancing Segment | Char | |
| From Period | LOV Oracle | |
| To Period | LOV Oracle | |
| Parent Totals | LOV Oracle | |
| Precision | LOV Oracle | |
| Precision Width | Number | |
| Asset Information | LOV Oracle |