ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4709C51A9E05362FB09050512 select i.asset_number, i.description, i.company, substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH) parent_account, i.asset_cost_acct cost_account, i.account_description, i.date_placed_in_service, a.commitment, a.investment_law, nvl(sum(i.cost), 0) cost, nvl(sum(i.ltd_deprn), 0) reserve, nvl(sum(i.nbv), 0) nbv, i.serial_number, i.tag_number, i.category, i.employee_name, i.employee_number, nvl(i.life_yr_mo,0), nvl(i.ytd_deprn,0), nvl(i.deprn_amount,0), nvl(i.nbv_beginning_fy,0), i.deprn_expense_acct, i.accum_deprn_acct, i.expense_acct_description, i.functional_currency_code, i.cost_center, i.cost_center_description, i.company_description, i.category_description, i.organization_name, i.major_category_description, i.minor_category_description, JG_JGZZFALE_XMLP_PKG.cf_parent_acct_descrformula(substr ( i.asset_cost_acct , 1 , :P_PRECISION * :P_PRECISION_WIDTH )) CF_PARENT_ACCT_DESCR from fa_additions a, fa_deprn_rep_itf i where i.request_id = :P_CONC_REQUEST_ID and i.company = :P_BALANCING_SEGMENT and a.asset_number = i.asset_number group by i.asset_number, i.description, i.company, substr(i.asset_cost_acct, 1, :P_PRECISION * :P_PRECISION_WIDTH), i.asset_cost_acct, i.account_description, i.date_placed_in_service, a.commitment, a.investment_law, i.serial_number, i.tag_number, i.category, i.employee_name, i.employee_number, i.life_yr_mo, nvl(i.ytd_deprn,0), nvl(i.deprn_amount,0), nvl(i.nbv_beginning_fy,0), i.deprn_expense_acct, i.accum_deprn_acct, i.expense_acct_description, i.functional_currency_code, i.cost_center, i.cost_center_description, i.company_description, i.category_description, i.organization_name, i.major_category_description, i.minor_category_description order by i.asset_cost_acct, i.asset_number Y JG JGZZFALE_XML US JG Statutory Asset Ledger Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Statutory Asset Ledger Report Application: Regional Localizations Source: Statutory Asset Ledger Report (XML) - Not Supported: Reserved For Future Use Short Name: JGZZFALE_XML DB package: JG_JGZZFALE_XMLP_PKG BI Publisher :cp_date_format :p_balancing_segment :p_book_type_code :p_conc_request_id :p_period :p_precision :p_precision_width :p_statutory_report :p_summary :rp_acct_valueset_name :rp_bal_seg :rp_book :rp_company_name :rp_currency_code :rp_official_run :rp_parent_totals :rp_period :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_ledgers_public_v sob, fa_book_controls bc where bc.book_type_code=:$flex$.book and sob.ledger_id=bc.set_of_books_id and rownum=1 Y US COA ID COA ID 2 10 :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 3 20 :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 4 30 :p_balancing_segment Char Y US Balancing Segment Balancing Segment 5 40 :p_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 Period Period 6 50 :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 7 60 :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 Y US Precision Precision 8 70 :p_precision_width Number 2 Y US Precision Width Precision Width 9 80 :p_country LOV Oracle FND_TERRITORIES Y select territory_code id, territory_code value, description description from fnd_territories_vl order by value,description Y US Country Country 10 90 :p_global1 LOV Oracle JGZZ_ASSET_GLOBAL_ATTRIBUTES Y select application_column_name id, form_above_prompt value, null description from fnd_descr_flex_col_usage_tl where application_id=7003 and descriptive_flexfield_name= 'JG_FA_ADDITIONS' and descriptive_flex_context_code='JE.'|| :$flex$.fnd_territories|| '.FAXASSET.ASSET' and language= userenv('LANG') order by value,description US First Global Attribute First Global Attribute 11 100 :p_global2 LOV Oracle JGZZ_ASSET_GLOBAL_ATTRIBUTES Y select application_column_name id, form_above_prompt value, null description from fnd_descr_flex_col_usage_tl where application_id=7003 and descriptive_flexfield_name= 'JG_FA_ADDITIONS' and descriptive_flex_context_code='JE.'|| :$flex$.fnd_territories|| '.FAXASSET.ASSET' and language= userenv('LANG') order by value,description US Second Global Attribute Second Global Attribute