ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2813869E053B46B63588994 SELECT (SELECT meaning FROM PA_LOOKUPS WHERE LOOKUP_TYPE ='PA_RP_CURRENCY_TYPES' AND lookup_code = :CurrencyType ) currency_type, ( Select meaning FROM PA_LOOKUPS WHERE lookup_type = 'PA_RP_CALENDAR_TYPES' AND lookup_code = :CalendarType ) calendar_type, ( select name from PA_ORGANIZATIONS_PROJECT_V where active_flag = 'Y' and organization_id = :OrganizationId ) organization_name, (select org.name from PA_IMPLEMENTATIONS_ALL imp, HR_ORGANIZATION_UNITS org WHERE imp.org_id = org.organization_id and imp.org_id = :OrgId ) ou_name, (select name from pa_fin_plan_types_vl where trunc(sysdate) between start_date_active and nvl(END_DATE_ACTIVE,trunc(sysdate) ) and FIN_PLAN_TYPE_ID = :CostPlanType ) cost_plan_type_name, (select name from pa_fin_plan_types_vl where trunc(sysdate) between start_date_active and nvl(END_DATE_ACTIVE,trunc(sysdate) ) and FIN_PLAN_TYPE_ID = :RevPlanType ) rev_plan_type_name, (select customer_name from pa_customer_lov_v where customer_id = :Customer ) customer_name, (SELECT meaning FROM PA_LOOKUPS WHERE lookup_type = 'PA_RP_REPORTING_PERIODS' AND lookup_code = :RepPeriod ) reporting_period, (SELECT meaning FROM PA_LOOKUPS WHERE lookup_type = 'PA_RP_PERIOD_TYPES' AND lookup_code = :PeriodTypeId ) period_type, (SELECT project_status_name FROM pa_project_statuses WHERE status_type = 'PROJECT' AND SYSDATE between start_date_active AND nvl(end_date_active, SYSDATE) and project_status_code = :ProjStatus ) project_status, :SpecPrdName spec_period_name, :FromProj from_project, :ToProj to_project, :ProjType project_type, :ProjMgr project_manager, :Factor factor from dual Y PA PARPPROJMGR AR PA حزمة تقارير مدير المشروعات Application: المشروعات Source: حزمة تقارير مدير المشروعات Short Name: PARPPROJMGR DB package: D PA Auswertungspaket Projektmanager Application: Projects Source: Auswertungspaket Projektmanager Short Name: PARPPROJMGR DB package: F PA Kit d'édition d'états pour chef de projet Application: Projects Source: Kit d'édition d'états pour chef de projet Short Name: PARPPROJMGR DB package: US PA Project Manager Reporting Pack Application: Projects Source: Project Manager Reporting Pack Short Name: PARPPROJMGR DB package: ZHS PA 项目经理报告包 Application: 项目 Source: 项目经理报告包 Short Name: PARPPROJMGR DB package: BI Publisher :calendartype :costplantype :currencytype :customer :factor :fromproj :organizationid :orgid :periodtypeid :projmgr :projstatus :projtype :repperiod :revplantype :specprdname :toproj 1 10 :reportingpackid LOV Oracle PA_RP_PACK_NAMES Y select rp_id id, rp_name value, descriptions description from pa_rp_definitions_vl where nvl(obsolete_flag,'N')<>'Y' order by rp_name Y AR حزمة التقارير D Auswertungspaket F Kit d'édition d'états US Reporting Pack ZHS 报告包 2 20 :orgid LOV Oracle PA_SRS_RP_OPERATING_UNITS Y select organization_id id, name value, null description from hr_operating_units hr where mo_global.check_access(organization_id)='Y' order by name AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 3 30 :organizationid LOV Oracle PA_SRS_RP_ORGANIZATIONS Y select organization_id id, name value, null description from hr_all_organization_units_vl where organization_id in (select porg.organization_id from pa_all_organizations porg,hr_operating_units hr where hr.organization_id=porg.org_id and porg.pa_org_use_type='PROJECTS' and hr.organization_id=nvl(:$flex$.pa_srs_rp_operating_units,hr.organization_id) and mo_global.check_access(hr.organization_id)='Y') order by name AR تنظيم المشروع D Projektorganisation F Organisation du projet US Project Organization ZHS 项目组织 4 40 :projtype LOV Oracle PA_RP_SRS_PROJECT_TYPES Y select project_type id, project_type value, description description from pa_project_types where org_id=nvl(:$flex$.pa_srs_rp_operating_units,org_id) order by project_type AR نوع المشروع D Projektart F Type de projet US Project Type ZHS 项目类型 5 50 :projmgr LOV Oracle PA_RP_PROJ_MANAGER Y select manager_id id, manager_name value, manager_name description from pa_proj_manager_v order by value,description AR مدير المشروع D Projektmanager F Chef de projet US Project Manager ZHS 项目经理 6 60 :fromproj Char AR من المشروع D Von Projekt F Projet - De US Project From ZHS 项目自 7 70 :toproj Char AR إلى المشروع D Bis Projekt F Projet - A US Project To ZHS 项目至 8 80 :projstatus LOV Oracle PA_SRS_PROJECT_STATUS Y select project_status_code id, project_status_name value, null description from pa_project_statuses where status_type='PROJECT' and sysdate between start_date_active and nvl(end_date_active,sysdate) order by value,description AR موقف المشروع D Projektstatus F Statut du projet US Project Status ZHS 项目状态 9 90 :calendartype LOV Oracle PA_RP_CALENDAR_TYPES Y select lookup_code id, meaning value, meaning description from fnd_lookup_values_vl where lookup_type='PA_RP_CALENDAR_TYPES' order by value,description Select meaning from fnd_lookup_values_vl where lookup_Type = 'PA_RP_CALENDAR_TYPES' and lookup_code = 'P' Y AR التقويم D Kalender F Calendrier US Calendar ZHS 日历 10 100 :repperiod LOV Oracle PA_RP_REPORTING_PERIODS Y select lookup_code id, meaning value, meaning description from fnd_lookup_values_vl where lookup_type='PA_RP_REPORTING_PERIODS' order by value,description select meaning from FND_LOOKUP_VALUES_VL where lookup_type = 'PA_RP_REPORTING_PERIODS' and lookup_code = 'CURRENT' AR فترة التقرير D Auswertungsperiode F Période de reporting US Reporting Period ZHS 报告期 11 110 :specprdname LOV Oracle PA_RP_CALENDAR_PERIODS Y select period_name id, period_name value, period_name description from pa_rp_calendar_period_names_v where 'SPECIFIC'=:$flex$.pa_rp_reporting_periods and org_id=:$flex$.pa_srs_rp_operating_units and calendar_type=:$flex$.pa_rp_calendar_types order by value,description AR اسم الفترة D Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 12 120 :periodtypeid LOV Oracle PA_RP_PERIOD_TYPES Y select lookup_code id, meaning value, meaning description from pa_lookups where lookup_type='PA_RP_PERIOD_TYPES' order by to_number(lookup_code) asc select meaning from pa_lookups WHERE lookup_type ='PA_RP_PERIOD_TYPES' and lookup_code = '32' Y AR نوع الفترة D Periodenart F Type de période US Period Type ZHS 期间类型 13 130 :currencytype LOV Oracle PA_RP_CURRENCY_TYPE Y select lookup_code id, meaning value, meaning description from fnd_lookup_values_vl where lookup_type='PA_RP_CURRENCY_TYPES' order by value,description select meaning from fnd_lookup_values_vl where lookup_type = 'PA_RP_CURRENCY_TYPES' and lookup_code = 'PC' Y AR نوع العملة D Währungsart F Type de devise US Currency Type ZHS 币种类型 14 140 :customer LOV Oracle PA_RP_CUSTOMER Y select customer_id id, customer_name value, customer_name description from pa_customer_lov_v order by value,description AR العميل D Kunde F Client US Customer ZHS 客户 15 150 :factor LOV Oracle PA_RP_FACTORING Y select lookup_code id, meaning value, meaning description from fnd_lookup_values_vl where lookup_type='PA_FP_ADV_DISPLAY_FACTORS' order by value,description select meaning from fnd_lookup_values_vl where lookup_type = 'PA_FP_ADV_DISPLAY_FACTORS' and lookup_code = 'ONE' Y AR السمسرة F Facteur d'affichage US Factoring ZHS 代收帐款 16 160 :costplantype LOV Oracle PA_FP_PLAN_TYPES Y Y select fin_plan_type_id id, name value, null description from pa_fin_plan_types_vl where trunc(sysdate) between start_date_active and nvl(end_date_active,trunc(sysdate)) order by value,description AR نوع خطة التكلفة D Kostenplanart F Type de plan de coût US Cost Plan Type ZHS 成本计划类型 17 170 :revplantype LOV Oracle PA_FP_PLAN_TYPES Y Y select fin_plan_type_id id, name value, null description from pa_fin_plan_types_vl where trunc(sysdate) between start_date_active and nvl(end_date_active,trunc(sysdate)) order by value,description AR نوع خطة الإيرادات D Umsatzplanart F Type de plan de produit US Revenue Plan Type ZHS 收入计划类型 :$flex$.pa_rp_calendar_types Calendar Period Name :$flex$.pa_rp_reporting_periods Reporting Period Period Name :$flex$.pa_srs_rp_operating_units Operating Unit Period Name :$flex$.pa_srs_rp_operating_units Operating Unit Project Organization :$flex$.pa_srs_rp_operating_units Operating Unit Project Type