ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F28C3869E053B46B63588994 SELECT PP.PROJECT_ID, PP.SEGMENT1, PT.PROJECT_TYPE_CLASS_CODE, NVL(SUM(TOT_REVENUE),0) + NVL(SUM(I_TOT_REVENUE),0) TXN_REVENUE, NVL(SUM(TOT_RAW_COST),0)+ NVL(SUM(I_TOT_RAW_COST),0) TXN_RAW_COST, NVL(SUM(TOT_BURDENED_COST),0)+ NVL(SUM(I_TOT_BURDENED_COST),0) TXN_BURDENED_COST, NVL(SUM(TOT_QUANTITY),0)+ NVL(SUM(I_TOT_QUANTITY),0) TXN_QUANTITY, NVL(SUM(TOT_LABOR_HOURS),0) + NVL(SUM(I_TOT_LABOR_HOURS),0) TXN_LABOR_HOURS, NVL(SUM(TOT_BILLABLE_RAW_COST),0) + NVL(SUM(I_TOT_BILLABLE_RAW_COST),0) TXN_BILLABLE_RAW_COST, NVL(SUM(TOT_BILLABLE_BURDENED_COST),0) + NVL(SUM(I_TOT_BILLABLE_BURDENED_COST),0) TXN_BILLABLE_BURDENED_COST, NVL(SUM(TOT_BILLABLE_QUANTITY),0) + NVL(SUM(I_TOT_BILLABLE_QUANTITY),0) TXN_BILLABLE_QUANTITY, NVL(SUM(TOT_BILLABLE_LABOR_HOURS),0) + NVL(SUM(I_TOT_BILLABLE_LABOR_HOURS),0) TXN_BILLABLE_LABOR_HOURS, PP.PROJECT_CURRENCY_CODE, PA_PAXACRTA_XMLP_PKG.cf_corbformula(PT.PROJECT_TYPE_CLASS_CODE) CF_CorB, PA_PAXACRTA_XMLP_PKG.cf_notcorbformula(PT.PROJECT_TYPE_CLASS_CODE) CF_NotCorB FROM PA_TXN_ACCUM PTA, PA_PROJECT_ACCUM_HEADERS PAH, PA_PROJECTS PP, PA_PROJECT_TYPES PT WHERE PTA.PROJECT_ID = PAH.PROJECT_ID AND PT.PROJECT_TYPE = PP.PROJECT_TYPE AND PP.PROJECT_ID = PAH.PROJECT_ID AND PAH.REQUEST_ID = :P_CONC_REQUEST_ID AND PAH.RESOURCE_LIST_MEMBER_ID = 0 AND PAH.TASK_ID = 0 AND exists ( SELECT 'Yes' FROM pa_txn_accum_details ptad WHERE pta.txn_accum_id = ptad.txn_accum_id AND ptad.line_type IN ('C','R','E') ) GROUP BY PP.PROJECT_ID,PP.SEGMENT1, PT.PROJECT_TYPE_CLASS_CODE, PP.PROJECT_CURRENCY_CODE UNION SELECT PP.PROJECT_ID, PP.SEGMENT1, PT.PROJECT_TYPE_CLASS_CODE, 0 TXN_REVENUE, 0 TXN_RAW_COST, 0 TXN_BURDENED_COST, 0 TXN_QUANTITY, 0 TXN_LABOR_HOURS, 0 TXN_BILLABLE_RAW_COST, 0 TXN_BILLABLE_BURDENED_COST, 0 TXN_BILLABLE_QUANTITY, 0 TXN_BILLABLE_LABOR_HOURS, PP.PROJECT_CURRENCY_CODE, PA_PAXACRTA_XMLP_PKG.cf_corbformula(PT.PROJECT_TYPE_CLASS_CODE) CF_CorB, PA_PAXACRTA_XMLP_PKG.cf_notcorbformula(PT.PROJECT_TYPE_CLASS_CODE) CF_NotCorB FROM PA_PROJECTS PP, PA_PROJECT_TYPES PT WHERE PT.PROJECT_TYPE = PP.PROJECT_TYPE AND NOT EXISTS (SELECT PTA.PROJECT_ID FROM PA_TXN_ACCUM PTA WHERE PTA.PROJECT_ID = PP.PROJECT_ID) AND NOT EXISTS (SELECT PAH.PROJECT_ID FROM PA_PROJECT_ACCUM_HEADERS PAH WHERE PP.PROJECT_ID = PAH.PROJECT_ID AND PAH.REQUEST_ID = :P_CONC_REQUEST_ID AND PAH.RESOURCE_LIST_MEMBER_ID = 0 AND PAH.TASK_ID = 0) AND PP.SEGMENT1 BETWEEN NVL(:P_PROJECT_NUM_FROM, PP.SEGMENT1) AND NVL(:P_PROJECT_NUM_TO, PP.SEGMENT1) GROUP BY PP.PROJECT_ID,PP.SEGMENT1, PT.PROJECT_TYPE_CLASS_CODE, PP.PROJECT_CURRENCY_CODE Y PA PAXACRTA_XML AR PA تجديد مبالغ الحركة الإجمالية (بتنسيق XML) Application: المشروعات Source: PRC: تجديد مبالغ الحركة الإجمالية (بتنسيق XML) Short Name: PAXACRTA_XML DB package: PA_PAXACRTA_XMLP_PKG D PA Transaktionssummen neu berechnen Application: Projects Source: PA: Transaktionssummen neu berechnen (XML) Short Name: PAXACRTA_XML DB package: PA_PAXACRTA_XMLP_PKG F PA Rafraîchir les montants de synthèse mouvement Application: Projects Source: PRC : Rafraîchir les montants de synthèse mouvement (XML) Short Name: PAXACRTA_XML DB package: PA_PAXACRTA_XMLP_PKG US PA Refresh Transaction Summary Amounts Application: Projects Source: PRC: Refresh Transaction Summary Amounts (XML) Short Name: PAXACRTA_XML DB package: PA_PAXACRTA_XMLP_PKG ZHS PA PRC：刷新事务处理汇总额 Application: 项目 Source: PRC：刷新事务处理汇总额 (XML) Short Name: PAXACRTA_XML DB package: PA_PAXACRTA_XMLP_PKG BI Publisher :c_company_name_header :c_conc_request_id :c_dummy_data :c_no_data_found :c_retcode :operating_unit :p_billable :p_capital :p_conc_request_id :p_debug_mode :p_end_pa_period :p_nonbillable :p_noncapital :p_project_num_from :p_project_num_to :p_rule_optimizer :p_start_pa_period :p_system_linkage_function 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_start_pa_period LOV Oracle PA_SRS_PERIODS Y select period_name id, period_name value, null description from pa_periods order by start_date desc AR من فترة محاسبة المشروعات D Von PA-Periode F Période PA - De US From PA Period ZHS 自 PA 期间 4 40 :p_end_pa_period LOV Oracle PA_SRS_PERIODS Y select period_name id, period_name value, null description from pa_periods order by start_date desc AR إلى فترة محاسبة المشروعات D Bis PA-Periode F Période PA - A US To PA Period ZHS 至 PA 期间 5 50 :p_system_linkage_function LOV Oracle PA_SRS_SYSTEM_LINKAGE_FUNC Y select function id, meaning value, null description from pa_system_linkages order by meaning AR طبقة نوع المصروفات D Aufwandsartklasse F Classe de type de dépense US Expenditure Type Class ZHS 支出类型分类