ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709B51A9E05362FB09050512 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 JG JGZZFAAD_XML US JG Statutory Asset Cost/Reserve Detail Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Statutory Asset Cost/Reserve Detail Report 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 BI Publisher &lp_dynamic_col :cp_date_format :lp_dynamic_col :p_asset_info :p_balancing_segment :p_book_type_code :p_conc_request_id :p_from_period :p_precision :p_precision_width :p_report_type :p_statutory_report :p_summary :p_to_period :rp_acct_valueset_name :rp_company_name :rp_currency_code :rp_precision :rp_report_name :rp_sob_id :rp_sob_name 1 -20 :p_coa_id Number select sob.chart_of_accounts_id from gl_sets_of_books sob, fa_book_controls bc where bc.book_type_code=:$flex$.book and sob.set_of_books_id=bc.set_of_books_id and rownum=1 Y US COA ID COA ID 2 10 :p_report_type LOV Oracle JGZZ_FA_REPORT_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JGZZ_JGSTRGRH_TITLE' and lookup_code in ('COST','RESERVE') order by value,description Y US Report Type Report Type 3 20 :p_statutory_report LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='N' Y US Official Run Official Run 4 30 :p_book_type_code LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y US Book Book 5 40 :p_balancing_segment Char Y US Balancing Segment Balancing Segment 6 50 :p_from_period LOV Oracle FA_CORP_PERIOD_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) order by period_counter Y US From Period From Period 7 60 :p_to_period LOV Oracle FA_CORP_PERIOD_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) order by period_counter Y US To Period To Period 8 70 :p_summary LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='Y' Y US Parent Totals Parent Totals 9 80 :p_precision LOV Oracle GL_NLS_FRA_PRECISION Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='GL_NLS_FRA_PRECISION' order by meaning select meaning from gl_lookups where lookup_type = 'GL_NLS_FRA_PRECISION' and lookup_code = '1' Y US Precision Precision 10 90 :p_precision_width Number 2 Y US Precision Width Precision Width 11 100 :p_asset_info LOV Oracle JGZZ_REPORT_INFO_LENGTH Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JGZZ_REPORT_INFO_LENGTH' order by lookup_code select meaning from fnd_lookups where lookup_type='JGZZ_REPORT_INFO_LENGTH' and lookup_code='S' Y US Asset Information Asset Information :$flex$.book Book COA ID :$flex$.fa_corp_book Book From Period :$flex$.fa_corp_book Book To Period