ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F02D3869E053B46B63588994 SELECT BC.BOOK_TYPE_CODE BOOK_TYPE_CODE1, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_company_flex_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY, fnd_flex_xml_publisher_apis.process_kff_combination_1('major_cat_flex', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'BASED_CATEGORY', 'Y', 'VALUE') MAJOR_CATEGORY, &MINOR_CAT_FLEX MINOR_CATEGORY, FA.ASSET_CATEGORY_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_cost_flex_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CENTER, FA.ASSET_NUMBER, FA.DESCRIPTION, BAL.DATA_SOURCE BALANCE_TYPE, BAL.DISPLAY_ORDER, NVL(SUM(DECODE(BAL.Source_Type_Code, 'COST', NVL(BAL.Amount,0), NULL)), 0) REVALUED_COST, NVL(SUM(DECODE(BAL.Source_Type_Code, 'REVAL_RSV', NVL(BAL.Amount,0), NULL)), 0) REVALUATION_RESERVE, NVL(SUM(DECODE(BAL.Source_Type_Code, 'OP_EXPENSE', NVL(BAL.Amount,0), NULL)), 0) OPERATING_ACCT, NVL(SUM(DECODE(BAL.Source_Type_Code, 'DEP_RSV', NVL(BAL.Amount,0), NULL)), 0) ACCUMULATED_DEPRECIATION, NVL(SUM(DECODE(BAL.Source_Type_Code, 'BACKLOG', NVL(BAL.Amount,0), NULL)), 0) ACCUMULATED_BACKLOG, IGI_IGIIARPR_XMLP_PKG.cf_rep_toleranceformula(:s_rep_b_reval_cost, :s_rep_a_reval_cost) CF_rep_tolerance, IGI_IGIIARPR_XMLP_PKG.CP_rep_format_diff_p CP_rep_format_diff, IGI_IGIIARPR_XMLP_PKG.cf_co_toleranceformula(:s_co_b_reval_cost, :s_co_a_reval_cost) CF_co_tolerance, IGI_IGIIARPR_XMLP_PKG.CP_co_format_diff_p CP_co_format_diff, IGI_IGIIARPR_XMLP_PKG.cf_mc_toleranceformula(:s_mc_b_reval_cost, :s_mc_a_reval_cost) CF_mc_tolerance, IGI_IGIIARPR_XMLP_PKG.CP_mc_format_diff_p CP_mc_format_diff, IGI_IGIIARPR_XMLP_PKG.cf_major_catformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('major_cat_flex', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'BASED_CATEGORY', 'Y', 'VALUE')) CF_major_cat, IGI_IGIIARPR_XMLP_PKG.cf_cat_toleranceformula(:s_cat_b_reval_cost, :s_cat_a_reval_cost) CF_cat_tolerance, IGI_IGIIARPR_XMLP_PKG.f_minor_category_p f_minor_category, IGI_IGIIARPR_XMLP_PKG.CP_major_category_p CP_major_category, IGI_IGIIARPR_XMLP_PKG.CP_cat_format_diff_p CP_cat_format_diff, IGI_IGIIARPR_XMLP_PKG.cf_cc_toleranceformula(:s_cc_b_reval_cost, :s_cc_a_reval_cost) CF_cc_tolerance, IGI_IGIIARPR_XMLP_PKG.CP_cc_format_diff_p CP_cc_format_diff, IGI_IGIIARPR_XMLP_PKG.CF_calc_acct_valueFormula(FA.ASSET_CATEGORY_ID,fnd_flex_xml_publisher_apis.process_kff_combination_1('cp_account_segment', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE')) CF_calc_acct_value, IGI_IGIIARPR_XMLP_PKG.CP_cost_acct_p CP_cost_acct, IGI_IGIIARPR_XMLP_PKG.CP_reval_res_acct_p CP_reval_res_acct, IGI_IGIIARPR_XMLP_PKG.CP_backlog_acct_p CP_backlog_acct, IGI_IGIIARPR_XMLP_PKG.CP_operating_acct_p CP_operating_acct, IGI_IGIIARPR_XMLP_PKG.CP_acc_deprn_acct_p CP_acc_deprn_acct, IGI_IGIIARPR_XMLP_PKG.cf_calc_toleranceformula(:s_a_b_reval_cost, :s_a_a_reval_cost) CF_calc_tolerance, IGI_IGIIARPR_XMLP_PKG.CP_a_format_diff_p CP_a_format_diff, IGI_IGIIARPR_XMLP_PKG.cf_calc_placeholdersformula() CF_calc_placeholders, IGI_IGIIARPR_XMLP_PKG.b_revalued_costformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'COST' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) b_revalued_cost, IGI_IGIIARPR_XMLP_PKG.a_revalued_costformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'COST' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) a_revalued_cost, IGI_IGIIARPR_XMLP_PKG.b_reval_reserveformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'REVAL_RSV' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) b_reval_reserve, IGI_IGIIARPR_XMLP_PKG.a_reval_reserveformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'REVAL_RSV' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) a_reval_reserve, IGI_IGIIARPR_XMLP_PKG.b_operating_acctformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'OP_EXPENSE' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) b_operating_acct, IGI_IGIIARPR_XMLP_PKG.a_operating_acctformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'OP_EXPENSE' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) a_operating_acct, IGI_IGIIARPR_XMLP_PKG.b_acc_deprnformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'DEP_RSV' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) b_acc_deprn, IGI_IGIIARPR_XMLP_PKG.a_acc_deprnformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'DEP_RSV' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) a_acc_deprn, IGI_IGIIARPR_XMLP_PKG.b_acc_backlogformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BACKLOG' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) b_acc_backlog, IGI_IGIIARPR_XMLP_PKG.a_acc_backlogformula(BAL.DATA_SOURCE, NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BACKLOG' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) a_acc_backlog, IGI_IGIIARPR_XMLP_PKG.f_reval_reserve_diff_p f_reval_reserve_diff, IGI_IGIIARPR_XMLP_PKG.f_reval_cost_diff_p f_reval_cost_diff, IGI_IGIIARPR_XMLP_PKG.f_operating_acct_diff_p f_operating_acct_diff, IGI_IGIIARPR_XMLP_PKG.f_acc_deprn_diff_p f_acc_deprn_diff, IGI_IGIIARPR_XMLP_PKG.f_acc_backlog_diff_p f_acc_backlog_diff FROM IGI_IAC_BALANCES_REPORT BAL, FA_CATEGORIES FC, GL_CODE_COMBINATIONS CC, FA_DISTRIBUTION_HISTORY DH, FA_ADDITIONS FA, FA_BOOKS BC WHERE BAL.ASSET_ID = DH.ASSET_ID AND BAL.distribution_ccid = DH.code_combination_id AND DH.code_combination_id = CC.code_combination_id AND DH.asset_id = FA.asset_id AND FA.asset_id = BAL.asset_id AND FA.asset_category_id = FC.category_id AND FA.asset_id = BC.asset_id AND BC.date_ineffective IS NULL AND BC.transaction_header_id_out IS NULL AND DH.date_ineffective IS NULL AND DH.transaction_header_id_out IS NULL AND :do_insert = 1 and BC.BOOK_TYPE_CODE=:book_type_code GROUP BY BC.BOOK_TYPE_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_company_flex_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('major_cat_flex', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'BASED_CATEGORY', 'Y', 'VALUE'), &MINOR_CAT_FLEX, FA.ASSET_CATEGORY_ID, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_cost_flex_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), FA.ASSET_NUMBER, FA.DESCRIPTION, BAL.DATA_SOURCE, BAL.DISPLAY_ORDER, fnd_flex_xml_publisher_apis.process_kff_combination_1('cp_account_segment', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ORDER BY 1,2,3,4,6,7,10 Y IGI IGIIARPR_XML AR IGI محاسبة التضخم : تقرير تفاصيل معاينة إعادة تقييم الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الماليات الدولية للقطاع العام Source: محاسبة التضخم : تقرير تفاصيل معاينة إعادة تقييم الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG D IGI Inflation Accounting: Anlagenneubewertung - Vorschau - Details- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Public Sector Financials International Source: Inflation Accounting: Anlagenneubewertung - Vorschau - Details (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG F IGI Comptabilité d'inflation : Etat détaillé de prévisualisation des réévaluations d'immobilisations- Non pris en charge : réservé pour une utilisation ultérieure Application: Public Sector Financials International Source: Comptabilité d'inflation : Etat détaillé de prévisualisation des réévaluations d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG US IGI Inflation Accounting : Asset Revaluation Preview Detail - draft Application: Public Sector Financials International Source: Inflation Accounting : Asset Revaluation Preview Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG ZHS IGI 通货膨胀会计：资产重估预览明细报表- 不支持：已保留供将来使用 Application: Public Sector Financials International Source: 通货膨胀会计：资产重估预览明细报表 (XML) - 不支持：已保留供将来使用 Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG BI Publisher &minor_cat_flex :accounting_flex_structure :book_type_code :cf_a_reval_cost :cf_asset_tolerance :cf_b_reval_cost :cf_tolerance_level :cp_a_format_diff :cp_acc_deprn_acct :cp_account_segment :cp_backlog_acct :cp_cat_format_diff :cp_cc_format_diff :cp_co_format_diff :cp_cost_acct :cp_curr_code :cp_major_category :cp_mc_format_diff :cp_operating_acct :cp_period_name :cp_rep_format_diff :cp_reval_res_acct :do_insert :f_acc_backlog_diff :f_acc_deprn_diff :f_minor_category :f_operating_acct_diff :f_reval_cost_diff :f_reval_reserve_diff :insert_info_var :p_book :p_book_type_code :p_conc_request_id :p_fiscal_year :p_period_counter :p_revaluation_id :rp_company_name :rp_report_name :s_a_a_reval_cost :s_a_b_reval_cost :s_cat_a_reval_cost :s_cat_b_reval_cost :s_cc_a_reval_cost :s_cc_b_reval_cost :s_co_a_reval_cost :s_co_b_reval_cost :s_mc_a_reval_cost :s_mc_b_reval_cost :s_rep_a_reval_cost :s_rep_b_reval_cost