ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2C13869E053B46B63588994Y select t1.project_id, t1.task_id q_task_task_id, pt.direct_flag direct, p.project_name, p.project_number, p.project_status, p.start_date, p.completion_date, substr(p.organization_name,1,60) project_organization , upper(pt.project_type_class_code) ptcc , p.project_currency_code, pr.multi_currency_billing_flag, pl.meaning inv_proc_curr_type, pr.projfunc_currency_code, pl1.meaning projfunc_bil_rate_date_code, (select user_conversion_type from pa_conversion_types_v where conversion_type = pr.projfunc_bil_rate_type) projfunc_bil_rate_type, pr.projfunc_bil_rate_date, pr.projfunc_bil_exchange_rate, pl2.meaning project_bil_rate_date_code, (select user_conversion_type from pa_conversion_types_v where conversion_type = pr.project_bil_rate_type) project_bil_rate_type, pr.project_bil_rate_date, pr.project_bil_exchange_rate, pl3.meaning funding_rate_date_code, (select user_conversion_type from pa_conversion_types_v where conversion_type = pr.funding_rate_type) funding_rate_type, pr.funding_rate_date, pr.funding_exchange_rate, gl.user_conversion_type projfunc_cost_rate_type, t1.taskfunc_cost_rate_date projfunc_cost_rate_date, t1.cc_process_labor_flag, t1.cc_process_nl_flag, ltp.name ltp_name, t1.labor_tp_fixed_date, nltp.name nltp_name, t1.nl_tp_fixed_date, t2.task_number cc_tax_task_number, pr.baseline_funding_flag, t1.customer_id, t1.invoice_method, t1.revenue_accrual_method, PA_PAXPRTSK_XMLP_PKG.cf_revenue_accrual_mthformula(t1.revenue_accrual_method, t1.project_id) CF_REVENUE_ACCRUAL_MTH, PA_PAXPRTSK_XMLP_PKG.cf_inv_mthformula(t1.invoice_method, t1.project_id) CF_INV_MTH, PA_PAXPRTSK_XMLP_PKG.cf_customer_numberformula(t1.customer_id, t1.project_id) CF_CUSTOMER_NUMBER, PA_PAXPRTSK_XMLP_PKG.cf_customer_nameformula(t1.customer_id, t1.project_id) CF_CUSTOMER_NAME from pa_proj_info_view p, pa_projects_all pr, pa_project_types pt, pa_tasks t1, pa_tasks t2, pa_lookups pl, pa_lookups pl1, pa_lookups pl2, pa_lookups pl3, pa_cc_tp_schedules ltp, pa_cc_tp_schedules nltp, GL_DAILY_CONVERSION_TYPES_V gl where p.project_id = pr.project_id and p.project_type = pt.project_type and p.project_id = t1.project_id and pr.CC_TAX_task_id = t2.task_id(+) and pr.invproc_currency_type = pl.lookup_code(+) and nvl(pl.lookup_type,'INVPROCE_CURR_TYPE') = 'INVPROCE_CURR_TYPE' and pr.projfunc_bil_rate_date_code = pl1.lookup_code(+) and nvl(pl1.lookup_type,'BILL_RATE_DATE_CODE') = 'BILL_RATE_DATE_CODE' and pr.project_bil_rate_date_code = pl2.lookup_code(+) and nvl(pl2.lookup_type,'BILL_RATE_DATE_CODE') = 'BILL_RATE_DATE_CODE' and pr.funding_rate_date_code = pl3.lookup_code(+) and nvl(pl3.lookup_type,'BILL_RATE_DATE_CODE') = 'BILL_RATE_DATE_CODE' and t1.labor_tp_schedule_id = ltp.tp_schedule_id(+) and t1.nl_tp_schedule_id = nltp.tp_schedule_id(+) and p.project_id = :proj and decode(:top_task_id, '', t1.parent_task_id,'All', t1.parent_task_id, null) is null and decode(:top_task_id, '', t1.task_id,'All', t1.task_id, :top_task_id) = t1.task_id and t1.taskfunc_cost_rate_type = gl.conversion_type(+) ORDER BY t1.task_number PA PAXPRTSK_XML AR PA تفاصيل المهمة (بتنسيق XML) Application: المشروعات Source: AUD: تفاصيل المهمة (بتنسيق XML) Short Name: PAXPRTSK_XML DB package: PA_PAXPRTSK_XMLP_PKG D PA Teilprojekt - Details Application: Projects Source: PA: Teilprojekt - Details (XML) Short Name: PAXPRTSK_XML DB package: PA_PAXPRTSK_XMLP_PKG F PA Détails des tâches Application: Projects Source: AUD : Détails des tâches (XML) Short Name: PAXPRTSK_XML DB package: PA_PAXPRTSK_XMLP_PKG US PA Task Details Application: Projects Source: AUD: Task Details (XML) Short Name: PAXPRTSK_XML DB package: PA_PAXPRTSK_XMLP_PKG ZHS PA AUD：任务详细信息 Application: 项目 Source: AUD：任务详细信息 (XML) Short Name: PAXPRTSK_XML DB package: PA_PAXPRTSK_XMLP_PKG BI Publisher :c_company_name_header :c_display_st_det :c_display_sub :c_display_subtask_details :c_display_subtasks :c_no_data_found :c_project_name :c_project_number :c_task_id :c_task_name :c_task_number :c_top_task_id :display_subtask_details :display_subtasks :operating_unit :p_conc_request_id :p_costing :p_debug_mode :p_rule_optimizer :proj :top_task_id 1 10 :proj LOV Oracle PA_SRS_PROJECT_AND_TEMPLATE_ID Y Y select project_id id, project_number value, project_name description from pa_projects_basic_v order by project_number_sort_order Y AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 2 20 :top_task_id LOV Oracle PA_SRS_TASKS_TEMPLATE Y select task_id id, task_number value, task_name description from pa_tasks_all_v where :$flex$.pa_srs_project_and_template_id=project_id order by task_number AR رقم المهمة D Teilprojektnummer F Numéro de tâche US Task Number ZHS 任务编号 3 30 :display_subtasks 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 AR تقسيم المهام الفرعية D Aufgaben aufgliedern F Eclater sous-tâches US Explode Subtasks ZHS 展开子任务 4 40 :display_subtask_details 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 AR عرض تفاصيل المهمة D Teilprojektdetails anzeigen F Afficher les détails des tâches US Display Task Details ZHS 显示任务详细信息