ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B63869E053B46B63588994 SELECT substr(p.organization_name,1,60) project_organization, p.member_name Project_Manager, p.project_number, p.project_name, sum(nvl(ei.adjusted_revenue,nvl(ei.raw_revenue, 0))) total_potential_revenue, sum(decode(ei.revenue_distributed_flag, 'Y', 0, nvl(ei.adjusted_revenue, nvl(ei.raw_revenue,0)))) partial_potential_revenue, sum(nvl(ei.accrued_revenue,0)) total_accrued_revenue, sum(decode(ei.revenue_distributed_flag, 'P', nvl(ei.accrued_revenue,0),0)) partial_accrued_revenue, count(ei.expenditure_item_id) total_item_count, count(decode(ei.revenue_distributed_flag, 'P', 1, null )) partial_item_count , PA_PAXPCPRS_XMLP_PKG.c_disp_org_pot_revformula(:C_org_pot_rev) C_disp_org_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_acc_revformula(:C_ORG_ACC_REV) C_disp_org_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_diff_revformula(:C_org_diff_rev) C_disp_org_diff_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_potformula(:C_org_tot_pot) C_disp_org_tot_pot, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_accformula(:C_org_tot_acc) C_disp_org_tot_acc, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_diffformula(:C_org_tot_diff) C_disp_org_tot_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_pot_revformula(:C_MGR_POT_REV) C_disp_mgr_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_acc_revformula(:C_mgr_acc_rev) C_disp_mgr_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_diff_revformula(:C_MGR_DIFF_REV) C_disp_mgr_diff_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_potformula(:C_MGR_TOT_POT) C_disp_mgr_tot_pot, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_accformula(:C_MGR_TOT_ACC) C_disp_mgr_tot_acc, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_diffformula(:C_MGR_TOT_DIFF) C_disp_mgr_tot_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_tot_pot_revformula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) )) C_disp_tot_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_tot_acc_revformula(sum ( nvl ( ei.accrued_revenue , 0 ) )) C_disp_tot_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_diffformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) ), sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) )) c_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_diffformula(PA_PAXPCPRS_XMLP_PKG.c_diffformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) ), sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) ))) C_disp_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_par_pot_revformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) )) C_disp_par_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_par_acc_revformula(sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) )) C_disp_par_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_diff2formula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ), sum ( nvl ( ei.accrued_revenue , 0 ) )) C_diff2, PA_PAXPCPRS_XMLP_PKG.c_disp_diff2formula(PA_PAXPCPRS_XMLP_PKG.c_diff2formula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ), sum ( nvl ( ei.accrued_revenue , 0 ) ))) C_disp_diff2 FROM pa_tasks t, pa_project_types pt, pa_expenditure_items_all ei, pa_proj_members_view p WHERE ( ( NVL(:include_closed_projects,'N') = 'N' and pa_project_stus_utils.is_project_status_closed(p.project_status_code) = 'N') or NVL(:include_closed_projects,'N') = 'Y') and p.organization_id = nvl(:project_organization,p.organization_id) and :proj is not null and p.project_id = :proj and p.project_id = t.project_id and ei.task_id = t.task_id and ei.expenditure_item_date <= :accrue_through_date and p.member_person_id = nvl(:project_manager, p.member_person_id) and p.project_role_type = 'PROJECT MANAGER' and p.project_type = pt.project_type and ei.billable_flag||'' = 'Y' and pt.direct_flag = 'Y' group by p.organization_name, p.member_name, p.project_number, p.project_name having count(decode(ei.revenue_distributed_flag, 'P', 1, null )) > 0 UNION ALL SELECT substr(p.organization_name,1,60) project_organization, p.member_name Project_Manager, p.project_number, p.project_name, sum(nvl(ei.adjusted_revenue,nvl(ei.raw_revenue, 0))) total_potential_revenue, sum(decode(ei.revenue_distributed_flag, 'Y', 0, nvl(ei.adjusted_revenue, nvl(ei.raw_revenue,0)))) partial_potential_revenue, sum(nvl(ei.accrued_revenue,0)) total_accrued_revenue, sum(decode(ei.revenue_distributed_flag, 'P', nvl(ei.accrued_revenue,0),0)) partial_accrued_revenue, count(ei.expenditure_item_id) total_item_count, count(decode(ei.revenue_distributed_flag, 'P', 1, null )) partial_item_count, PA_PAXPCPRS_XMLP_PKG.c_disp_org_pot_revformula(:C_org_pot_rev) C_disp_org_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_acc_revformula(:C_org_acc_rev) C_disp_org_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_diff_revformula(:C_org_diff_rev) C_disp_org_diff_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_potformula(:C_org_tot_pot) C_disp_org_tot_pot, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_accformula(:C_org_tot_acc) C_disp_org_tot_acc, PA_PAXPCPRS_XMLP_PKG.c_disp_org_tot_diffformula(:C_org_tot_diff) C_disp_org_tot_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_pot_revformula(:C_mgr_pot_rev) C_disp_mgr_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_acc_revformula(:C_mgr_acc_rev) C_disp_mgr_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_diff_revformula(:C_mgr_diff_rev) C_disp_mgr_diff_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_potformula(:C_mgr_tot_pot) C_disp_mgr_tot_pot, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_accformula(:C_mgr_tot_acc) C_disp_mgr_tot_acc, PA_PAXPCPRS_XMLP_PKG.c_disp_mgr_tot_diffformula(:C_mgr_tot_diff) C_disp_mgr_tot_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_tot_pot_revformula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) )) C_disp_tot_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_tot_acc_revformula(sum ( nvl ( ei.accrued_revenue , 0 ) )) C_disp_tot_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_diffformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) ), sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) )) c_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_diffformula(PA_PAXPCPRS_XMLP_PKG.c_diffformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) ), sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) ))) C_disp_diff, PA_PAXPCPRS_XMLP_PKG.c_disp_par_pot_revformula(sum ( decode ( ei.revenue_distributed_flag , 'Y' , 0 , nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ) )) C_disp_par_pot_rev, PA_PAXPCPRS_XMLP_PKG.c_disp_par_acc_revformula(sum ( decode ( ei.revenue_distributed_flag , 'P' , nvl ( ei.accrued_revenue , 0 ) , 0 ) )) C_disp_par_acc_rev, PA_PAXPCPRS_XMLP_PKG.c_diff2formula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ), sum ( nvl ( ei.accrued_revenue , 0 ) )) C_diff2, PA_PAXPCPRS_XMLP_PKG.c_disp_diff2formula(PA_PAXPCPRS_XMLP_PKG.c_diff2formula(sum ( nvl ( ei.adjusted_revenue , nvl ( ei.raw_revenue , 0 ) ) ), sum ( nvl ( ei.accrued_revenue , 0 ) ))) C_disp_diff2 FROM pa_tasks t, pa_project_types pt, pa_expenditure_items_all ei, pa_proj_members_view p WHERE ( ( NVL(:include_closed_projects,'N') = 'N' and pa_project_stus_utils.is_project_status_closed(p.project_status_code) = 'N') or NVL(:include_closed_projects,'N') = 'Y') and p.organization_id = nvl(:project_organization,p.organization_id) and :proj is null and p.project_id = t.project_id and ei.task_id = t.task_id and ei.expenditure_item_date <= :accrue_through_date and p.member_person_id = nvl(:project_manager, p.member_person_id) and p.project_role_type = 'PROJECT MANAGER' and p.project_type = pt.project_type and ei.billable_flag||'' = 'Y' and pt.direct_flag = 'Y' group by p.organization_name, p.member_name, p.project_number, p.project_name having count(decode(ei.revenue_distributed_flag, 'P', 1, null )) > 0 Y PA PAXPCPRS_XML AR PA إجمالي الإيرادات المحتملة (بتنسيق XML) Application: المشروعات Source: MGT: إجمالي الإيرادات المحتملة (بتنسيق XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG D PA Vorschau prognostizierte Umsätze Application: Projects Source: PA: Vorschau prognostizierte Umsätze (XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG F PA Synthèse du produit potentiel Application: Projects Source: MGT : Synthèse du produit potentiel (XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG US PA Potential Revenue Summary Application: Projects Source: MGT: Potential Revenue Summary (XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG ZHS PA MGT：潜在收入汇总 Application: 项目 Source: MGT：潜在收入汇总 (XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG BI Publisher :accrue_through_date :accrue_through_date1 :c_company_name_header :c_mgr_acc_rev :c_mgr_diff_rev :c_mgr_pot_rev :c_mgr_tot_acc :c_mgr_tot_diff :c_mgr_tot_pot :c_no_data_found :c_org_acc_rev :c_org_diff_rev :c_org_pot_rev :c_org_tot_acc :c_org_tot_diff :c_org_tot_pot :c_proj_manager :c_proj_number :c_proj_org :c_yes_no :include_closed_projects :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :proj :project_manager :project_organization 1 10 :accrue_through_date Date Y AR استحقاق خلال تاريخ D Abgrenzen bis F Date limite de comptabilisation US Accrue Thru Date ZHS 应计截止日 2 20 :project_organization 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 项目组织 3 30 :project_manager 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 项目经理 4 40 :proj LOV Oracle PA_SRS_PROJECT_ID_CONTRACT Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v where template_flag!='Y' and project_type_class_code='CONTRACT' and cc_prvdr_flag='N' order by project_number_sort_order AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 5 50 :include_closed_projects LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' AR هل تريد تضمين المشروعات المقفلة؟ D Mit geschlossenen Projekten? F Inclure les projets fermés ? US Include Closed Projects? ZHS 是否包括已关闭项目？