ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F28B3869E053B46B63588994 SELECT PAH.PROJECT_ACCUM_ID PROJECT_ACCUM_ID2, PBT.BUDGET_TYPE, BASE_RAW_COST_ITD, BASE_RAW_COST_YTD, BASE_RAW_COST_PP, BASE_RAW_COST_PTD, BASE_BURDENED_COST_ITD, BASE_BURDENED_COST_YTD, BASE_BURDENED_COST_PP, BASE_BURDENED_COST_PTD, ORIG_RAW_COST_ITD, ORIG_RAW_COST_YTD, ORIG_RAW_COST_PP, ORIG_RAW_COST_PTD, ORIG_BURDENED_COST_ITD, ORIG_BURDENED_COST_YTD, ORIG_BURDENED_COST_PP, ORIG_BURDENED_COST_PTD, BASE_REVENUE_ITD, BASE_REVENUE_YTD, BASE_REVENUE_PP, BASE_REVENUE_PTD, ORIG_REVENUE_ITD, ORIG_REVENUE_YTD, ORIG_REVENUE_PP, ORIG_REVENUE_PTD, ORIG_LABOR_HOURS_ITD, ORIG_LABOR_HOURS_YTD, ORIG_LABOR_HOURS_PP, ORIG_LABOR_HOURS_PTD, BASE_LABOR_HOURS_ITD, BASE_LABOR_HOURS_YTD, BASE_LABOR_HOURS_PP, BASE_LABOR_HOURS_PTD, ORIG_QUANTITY_YTD, ORIG_QUANTITY_ITD, ORIG_QUANTITY_PP, ORIG_QUANTITY_PTD, BASE_QUANTITY_YTD, BASE_QUANTITY_ITD, BASE_QUANTITY_PP, BASE_QUANTITY_PTD, ORIG_LABOR_HOURS_TOT, BASE_LABOR_HOURS_TOT, ORIG_QUANTITY_TOT, BASE_QUANTITY_TOT, BASE_RAW_COST_TOT, BASE_BURDENED_COST_TOT, ORIG_RAW_COST_TOT, ORIG_BURDENED_COST_TOT, BASE_REVENUE_TOT, ORIG_REVENUE_TOT, BASE_UNIT_OF_MEASURE, ORIG_UNIT_OF_MEASURE FROM PA_BUDGET_TYPES PBT, PA_PROJECT_ACCUM_HEADERS PAH, PA_PROJECT_ACCUM_BUDGETS PAB WHERE PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID and pab.fin_plan_type_id is NULL union SELECT PAH.PROJECT_ACCUM_ID, PBT.BUDGET_TYPE, BASE_RAW_COST_ITD, BASE_RAW_COST_YTD, BASE_RAW_COST_PP, BASE_RAW_COST_PTD, BASE_BURDENED_COST_ITD, BASE_BURDENED_COST_YTD, BASE_BURDENED_COST_PP, BASE_BURDENED_COST_PTD, ORIG_RAW_COST_ITD, ORIG_RAW_COST_YTD, ORIG_RAW_COST_PP, ORIG_RAW_COST_PTD, ORIG_BURDENED_COST_ITD, ORIG_BURDENED_COST_YTD, ORIG_BURDENED_COST_PP, ORIG_BURDENED_COST_PTD, BASE_REVENUE_ITD, BASE_REVENUE_YTD, BASE_REVENUE_PP, BASE_REVENUE_PTD, ORIG_REVENUE_ITD, ORIG_REVENUE_YTD, ORIG_REVENUE_PP, ORIG_REVENUE_PTD, ORIG_LABOR_HOURS_ITD, ORIG_LABOR_HOURS_YTD, ORIG_LABOR_HOURS_PP, ORIG_LABOR_HOURS_PTD, BASE_LABOR_HOURS_ITD, BASE_LABOR_HOURS_YTD, BASE_LABOR_HOURS_PP, BASE_LABOR_HOURS_PTD, ORIG_QUANTITY_YTD, ORIG_QUANTITY_ITD, ORIG_QUANTITY_PP, ORIG_QUANTITY_PTD, BASE_QUANTITY_YTD, BASE_QUANTITY_ITD, BASE_QUANTITY_PP, BASE_QUANTITY_PTD, ORIG_LABOR_HOURS_TOT, BASE_LABOR_HOURS_TOT, ORIG_QUANTITY_TOT, BASE_QUANTITY_TOT, BASE_RAW_COST_TOT, BASE_BURDENED_COST_TOT, ORIG_RAW_COST_TOT, ORIG_BURDENED_COST_TOT, BASE_REVENUE_TOT, ORIG_REVENUE_TOT, BASE_UNIT_OF_MEASURE, ORIG_UNIT_OF_MEASURE FROM PA_BUDGET_TYPES PBT, PA_PROJECT_ACCUM_HEADERS PAH, PA_PROJECT_ACCUM_BUDGETS PAB WHERE PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID and pab.fin_plan_type_id is NULL union all SELECT PAH.PROJECT_ACCUM_ID, substr(tl.name,1,30) BUDGET_TYPE, BASE_RAW_COST_ITD, BASE_RAW_COST_YTD, BASE_RAW_COST_PP, BASE_RAW_COST_PTD, BASE_BURDENED_COST_ITD, BASE_BURDENED_COST_YTD, BASE_BURDENED_COST_PP, BASE_BURDENED_COST_PTD, ORIG_RAW_COST_ITD, ORIG_RAW_COST_YTD, ORIG_RAW_COST_PP, ORIG_RAW_COST_PTD, ORIG_BURDENED_COST_ITD, ORIG_BURDENED_COST_YTD, ORIG_BURDENED_COST_PP, ORIG_BURDENED_COST_PTD, BASE_REVENUE_ITD, BASE_REVENUE_YTD, BASE_REVENUE_PP, BASE_REVENUE_PTD, ORIG_REVENUE_ITD, ORIG_REVENUE_YTD, ORIG_REVENUE_PP, ORIG_REVENUE_PTD, ORIG_LABOR_HOURS_ITD, ORIG_LABOR_HOURS_YTD, ORIG_LABOR_HOURS_PP, ORIG_LABOR_HOURS_PTD, BASE_LABOR_HOURS_ITD, BASE_LABOR_HOURS_YTD, BASE_LABOR_HOURS_PP, BASE_LABOR_HOURS_PTD, ORIG_QUANTITY_YTD, ORIG_QUANTITY_ITD, ORIG_QUANTITY_PP, ORIG_QUANTITY_PTD, BASE_QUANTITY_YTD, BASE_QUANTITY_ITD, BASE_QUANTITY_PP, BASE_QUANTITY_PTD, ORIG_LABOR_HOURS_TOT, BASE_LABOR_HOURS_TOT, ORIG_QUANTITY_TOT, BASE_QUANTITY_TOT, BASE_RAW_COST_TOT, BASE_BURDENED_COST_TOT, ORIG_RAW_COST_TOT, ORIG_BURDENED_COST_TOT, BASE_REVENUE_TOT, ORIG_REVENUE_TOT, BASE_UNIT_OF_MEASURE, ORIG_UNIT_OF_MEASURE FROM pa_fin_plan_types_tl tl, PA_PROJECT_ACCUM_HEADERS PAH, PA_PROJECT_ACCUM_BUDGETS PAB WHERE PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID and tl.LANGUAGE = USERENV('LANG') and PAH.PROJECT_ACCUM_ID=:PROJECT_ACCUM_ID Y PA PAXACRPT_XML AR PA تجديد مبالغ المشروع الإجمالية (بتنسيق XML) Application: المشروعات Source: PRC: تجديد مبالغ المشروع الإجمالية (بتنسيق XML) Short Name: PAXACRPT_XML DB package: PA_PAXACRPT_XMLP_PKG D PA Projektsummen neu berechnen Application: Projects Source: PA: Projektsummen neu berechnen (XML) Short Name: PAXACRPT_XML DB package: PA_PAXACRPT_XMLP_PKG F PA Rafraîchir les montants de synthèse projet Application: Projects Source: PRC : Rafraîchir les montants de synthèse projet (XML) Short Name: PAXACRPT_XML DB package: PA_PAXACRPT_XMLP_PKG US PA Refresh Project Summary Amounts Application: Projects Source: PRC: Refresh Project Summary Amounts (XML) Short Name: PAXACRPT_XML DB package: PA_PAXACRPT_XMLP_PKG ZHS PA PRC：刷新项目汇总额 Application: 项目 Source: PRC：刷新项目汇总额 (XML) Short Name: PAXACRPT_XML DB package: PA_PAXACRPT_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_no_data_found :c_retcode :cp_round_currency :cp_round_currency_1 :cp_round_currency_2 :operating_unit :p_billable :p_capital :p_conc_request_id :p_debug_mode :p_num_batch_size :p_num_parallel_runs :p_project_num_from :p_project_num_to :p_project_type :p_rule_optimizer :p_through_date :project_accum_id 1 10 :p_project_num_from Char AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 2 20 :p_project_num_to Char AR إلى رقم المشروع D Bis Projektnummer F Au numéro de projet US To Project Number ZHS 至项目编号 3 30 :p_project_type LOV Oracle PA_SRS_PROJECT_TYPE Y select project_type id, project_type value, description description from pa_project_types order by project_type AR نوع المشروع D Projektart F Type de projet US Project Type ZHS 项目类型 4 40 :p_through_date Date AR خلال تاريخ D Bis Datum F Date limite US Through Date ZHS 截止日