ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2AD3869E053B46B63588994Y select distinct substr(p.organization_name,1,60) project_organization, p.manager_name project_manager, p.project_id project_id7, p.project_type, p.project_number, p.project_name, NVL(pr.retn_accounting_flag,'N') retn_accounting_flag, iv.total_revenue_amount, iv.total_invoiced_amount, f.meaning costs_burdened, pr.projfunc_currency_code, iv.write_off_invoice_amount, iv.pfc_invoiced_amount, iv.pfc_total_invoice_amount, iv.pfc_write_off_invoice_amount, iv.unbilled_retention, PA_PAXMGPSD_XMLP_PKG.unbilled_receivablesformula(NVL ( pr.retn_accounting_flag , 'N' ), iv.total_revenue_amount, iv.pfc_total_invoice_amount, iv.unbilled_retention) Unbilled_Receivables, PA_PAXMGPSD_XMLP_PKG.unearned_revenueformula(NVL ( pr.retn_accounting_flag , 'N' ), iv.pfc_total_invoice_amount, iv.total_revenue_amount, iv.unbilled_retention) Unearned_Revenue, PA_PAXMGPSD_XMLP_PKG.unbilled_retnformula(NVL ( pr.retn_accounting_flag , 'N' ), iv.unbilled_retention) unbilled_retn from pa_project_types pt, pa_proj_invoice_summary_view iv, pa_proj_info_view p, pa_projects pr, fnd_lookups f where pr.template_flag != 'Y' and pr.project_id = p.project_id and p.project_id = iv.project_id (+) and pt.burden_cost_flag = f.lookup_code and f.lookup_type = 'YES_NO' and pt.project_type = p.project_type &p_project_type &p_project &p_project_manager and nvl(p.organization_id,-999) = nvl(:org_id,nvl(p.organization_id,-999)) and pr.project_id in (select P.project_id from pa_projects P, pa_project_status_controls S where P.project_status_code = S.project_status_code and S.status_type = 'PROJECT' and S.action_code = 'STATUS_REPORTING' and S.enabled_flag='Y') order by project_organization, p.manager_name, p.project_number PA PAXMGPSD_XML AR PA الإيرادات والتكلفة والموازنات حسب الموارد (مستوى المشروع) (بتنسيق XML) Application: المشروعات Source: MGT: الإيرادات والتكلفة والموازنات حسب الموارد (مستوى المشروع) (بتنسيق XML) Short Name: PAXMGPSD_XML DB package: PA_PAXMGPSD_XMLP_PKG D PA Umsatz, Kosten, Budgets nach Ressource (Projektebene) Application: Projects Source: PA: Umsatz, Kosten, Budgets nach Ressource (Projektebene) (XML) Short Name: PAXMGPSD_XML DB package: PA_PAXMGPSD_XMLP_PKG F PA Produit, coût et budgets par ressource (au niveau projet) Application: Projects Source: MGT : Produit, coût et budgets par ressource (au niveau projet) (XML) Short Name: PAXMGPSD_XML DB package: PA_PAXMGPSD_XMLP_PKG US PA Revenue, Cost, Budgets by Resources (Project Level) Application: Projects Source: MGT: Revenue, Cost, Budgets by Resources (Project Level) (XML) Short Name: PAXMGPSD_XML DB package: PA_PAXMGPSD_XMLP_PKG ZHS PA MGT：按资源（项目层）列出的收入、成本和预算 Application: 项目 Source: MGT：按资源（项目层）列出的收入、成本和预算 (XML) Short Name: PAXMGPSD_XML DB package: PA_PAXMGPSD_XMLP_PKG BI Publisher &p_project &p_project_manager &p_project_type :c_company_name_header :c_cost_bgt_code :c_cost_bgt_name :c_end_date :c_mgr :c_no_data_found :c_org :c_proj_name :c_proj_num :c_rev_bgt_code :c_rev_bgt_name :c_start_date :cost_bgt_code :operating_unit :org_id :p_conc_request_id :p_debug_mode :p_project :p_project_manager :p_project_type :p_rule_optimizer :pa_period :proj :proj_type :project_manager_id :rev_bgt_code 1 10 :org_id LOV Oracle PA_SRS_PROJECT_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_project_v where active_flag='Y' order by value,description AR تنظيم المشروع D Projektorganisation F Organisation du projet US Project Organization ZHS 项目组织 2 20 :project_manager_id LOV Oracle PA_SRS_PROJECT_MANAGERS Y select person_id id, full_name value, employee_number description from pa_project_managers_v order by value,description AR مدير المشروع D Projektmanager F Chef de projet US Project Manager ZHS 项目经理 3 30 :proj LOV Oracle PA_SRS_PROJECT_ID Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' order by project_number_sort_order AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 4 40 :proj_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 项目类型 5 50 :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 Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 6 60 :cost_bgt_code LOV Oracle PA_SRS_BUDGET_TYPE_COST Y select budget_type_code id, budget_type value, description description from pa_budget_types where budget_amount_code='C' order by budget_type select budget_type from pa_budget_types where budget_type_code = 'AC' Y AR نوع موازنة التكلفة D Kostenbudgetart F Type de coûts budgétés US Cost Budget Type ZHS 成本预算类型 7 70 :rev_bgt_code LOV Oracle PA_SRS_BUDGET_TYPE_REV Y select budget_type_code id, budget_type value, description description from pa_budget_types where budget_amount_code='R' order by budget_type select budget_type from pa_budget_types where budget_type_code = 'AR' Y AR نوع موازنة الإيرادات D Umsatzbudgetart F Type de produit budgété US Revenue Budget Type ZHS 收入预算类型