ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4711051A9E05362FB09050512Y SELECT pt.project_type r_project_type ,ppa.fa_period_name r_period_name ,p.segment1 r_project_number ,p.name r_project_name ,decode(:p_group_by_cat, 'Y',fnd_flex_ext.get_segs('OFA', 'CAT#', 101, ppa.asset_category_id), ppa.asset_name)r_column_1 ,decode(:p_group_by_cat, 'Y',ppa.asset_name ,fnd_flex_ext.get_segs('OFA', 'CAT#', 101, ppa.asset_category_id))r_column_2 ,pal.description r_description ,fnd_flex_ext.get_segs('SQLGL','GL#',:cp_coa_id,pal.cip_ccid) r_cip_ccid ,pal.&lp_pa_curr_asset_cost r_current_asset_cost ,pal.capital_event_id r_capital_event_id FROM &lp_pa_proj_asset_line pal, pa_projects p, pa_project_types pt, pa_project_assets ppa, gl_code_combinations cc, fa_deprn_periods fap WHERE pal.cip_ccid=cc.code_combination_id AND pal.project_id = p.project_id AND pal.line_type='R' AND pal.project_asset_id = ppa.project_asset_id AND p.project_type = pt.project_type AND pal.transfer_status_code ='T' AND fap.book_type_code = ppa.book_type_code AND pal.fa_period_name =fap.period_name AND fap.calendar_period_open_date >= nvl(:cp_min_open_date,fap.calendar_period_open_date) /* Bug 21891438 */ AND NVL(fap.calendar_period_close_date,TRUNC(SYSDATE)) <= NVL(nvl(:cp_max_close_date,fap.calendar_period_close_date),TRUNC(SYSDATE)) /*Added for bug 16816473 */ AND (:p_class_category IS NULL OR p.project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category) ) AND (:p_class_category IS NULL OR :p_class_code IS NULL OR p.project_id in ( SELECT project_id FROM pa_project_classes WHERE class_category = :p_class_category AND class_code = :p_class_code)) AND nvl(:p_project_type,pt.project_type)=pt.project_type AND nvl(:p_project_id,p.project_id)=p.project_id AND nvl (:p_project_org,p.carrying_out_organization_id) = p.carrying_out_organization_id AND &c_where AND &c_sob_id ORDER BY 2 ASC,1 ASC,3 ASC,4 ASC,5 ASC PA PACRCIPF_XML AR PA مبالغ CIP/RWIP التي تم ربطها حسب فترة الأصول الثابتة (بتنسيق XML) Imported from BI Publisher Description: تقرير يعرض مبالغ CIP وRWIP المرتبطة Application: المشروعات Source: AUD: مبالغ CIP/RWIP التي تم ربطها حسب فترة الأصول الثابتة (بتنسيق XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG D PA Übertragene IBBA-/AIBBA-Beträge nach AN-Periode Imported from BI Publisher Description: Auswertung, die die übertragenen IBBA- und AIBBA-Beträge anzeigt Application: Projects Source: PA: Übertragene IBBA-/AIBBA-Beträge nach AN-Periode (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG E PA Importes de Activos en Curso/Baja en Curso Transferidos por Período de FA Imported from BI Publisher Description: Informe que muestra los importes de activos en curso y baja en curso transferidos Application: Projects Source: AUD: Importes de Activos en Curso/Baja en Curso Transferidos por Período de FA (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG F PA Etat Montants PAS/CPAS transférés par période FA Imported from BI Publisher Description: Etat qui affiche les montants PAS et CPAS transférés Application: Projects Source: AUD : Etat Montants PAS/CPAS transférés par période FA (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG I PA rapporto Importi CIC/RWIP interfacciati per periodo FA Imported from BI Publisher Description: Rapporto che visualizza gli importi CIC e RWIP interfacciati Application: Projects Source: AUD: rapporto Importi CIC/RWIP interfacciati per periodo FA (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG JA PA FA期間レポート別インタフェース済CIP/RWIP金額 Imported from BI Publisher Description: インタフェース済CIPおよびRWIP金額を表示するレポート Application: Projects Source: AUD: FA期間レポート別インタフェース済CIP/RWIP金額(XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG KO PA FA 기간별로 인터페이스된 CIP/RWIP 금액 보고서 Imported from BI Publisher Description: 인터페이스된 CIP 및 RWIP 금액을 표시하는 보고서 Application: Projects Source: AUD: FA 기간별로 인터페이스된 CIP/RWIP 금액 보고서(XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG PTB PA Relatório de Quantias CIP/RWIP Interfaceadas por Período FA Imported from BI Publisher Description: Relatório que exibe as Quantias CIP e RWIP interfaceadas Application: Projetos Source: AUD: Relatório de Quantias CIP/RWIP Interfaceadas por Período FA (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG RU PA отчет об импортированных суммах НзС/НзЛ по периодам ОС Imported from BI Publisher Description: Отчет, содержащий импортированные суммы НзС и НзЛ Application: Проекты Source: АУД: отчет об импортированных суммах НзС/НзЛ по периодам ОС (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG S PA Rapport om överförda PGA-/utrangeringsbelopp efter FA-period Imported from BI Publisher Description: Rapport som visar överförda PGA- och utrangeringsbelopp Application: Projects Source: AUD: Rapport om överförda PGA-/utrangeringsbelopp efter FA-period (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG TR PA FA Dönemi Raporuna göre Arayüze Alınan CIP/RWIP Tutarları Imported from BI Publisher Description: Arayüze alınan CIP ve RWIP Tutarlarını görüntüleyen rapor Application: Proje Yönetimi Source: AUD: FA Dönemi Raporuna göre Arayüze Alınan CIP/RWIP Tutarları (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG US PA Interfaced CIP/RWIP Amounts by FA Period Imported from BI Publisher Description: Report that displayes the interfaced CIP and RWIP Amounts Application: Projects Source: AUD: Interfaced CIP/RWIP Amounts by FA Period Report (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG ZHS PA AUD：按 FA 期间列出的已传送的 CIP/RWIP 金额报表 Imported from BI Publisher Description: 用于显示已传送的 CIP 和 RWIP 金额的报表 Application: 项目 Source: AUD：按 FA 期间列出的已传送的 CIP/RWIP 金额报表 (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG BI Publisher &c_sob_id &c_where &lp_pa_curr_asset_cost &lp_pa_proj_asset_line :c_sob_id :c_where :cp_1 :cp_coa_id :cp_company_name :cp_max_close_date :cp_min_open_date :cp_no_data_found :cp_proj_org_name :lp_pa_curr_asset_cost :lp_pa_proj_asset_line :operating_unit :p_ca_org_id :p_ca_set_of_books_id :p_cap_event_id :p_class_category :p_class_code :p_coa_id :p_conc_request_id :p_debug_mode :p_from_account :p_from_period :p_group_by_cat :p_mrcsobtype :p_project_id :p_project_number :p_project_org :p_project_type :p_to_account :p_to_period 1 -30 :p_ca_set_of_books_id LOV Oracle PA_SRS_SET_OF_BOOKS Y select set_of_books_id id, currency value, set_of_books_name description from pa_gl_set_of_books_v order by set_of_books_type SELECT currency FROM pa_gl_set_of_books_v WHERE set_of_books_type_code = 'P' Y AR عملة دفاتر الحسابات عملة دفاتر الحسابات D Währung Buchungsstruktur Währung Buchungsstruktur E Divisa de Juego de Libros Divisa de juego de libros F Devise de l'entité comptable Devise de l'entité comptable I Divisa set of books Divisa del set of books JA 会計帳簿通貨 会計帳簿通貨 KO 회계장부 통화 회계장부 통화 PTB Moeda do Conjunto de Livros Moeda do Conjunto de Livros RU Валюта набора книг Валюта набора книг S Räkenskapsvaluta Räkenskapsvaluta TR Defter Para Birimi Defter Para Birimi US Set of Books Currency Set of Books Currency ZHS 帐套币种 帐套币种 2 -20 :p_coa_id LOV Oracle PA_SRS_COA_ID_BYSOB Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from pa_implementations_all imp,gl_sets_of_books gl where imp.set_of_books_id=gl.set_of_books_id and imp.org_id=mo_global.get_current_org_id order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books g ,pa_implementations p WHERE g.set_of_books_id=p.set_of_books_id Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Identificador de plan de cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB ID do plano de contas ID do plano de contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of accounts ID Chart of accounts ID ZHS 科目表标识 科目表标识 3 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 4 10 :p_from_period LOV Oracle PA_SRS_FA_PER_NAME Y select fdp.period_name id, fdp.period_name value, null description from fa_deprn_periods fdp where fdp.book_type_code in (select fdp1.book_type_code from fa_deprn_periods fdp1 where fdp1.period_name=fdp.period_name and rownum=1) order by fdp.period_name Y AR من فترة الأصول الثابتة D Von AN-Periode E De Período de FA F Période FA - De I Periodo FA - Da JA FA期間:自 KO FA 기간: 부터 PTB Período FA - De RU Период ОС с S Från FA-period TR İlk FA Dönemi US From FA Period ZHS 自 FA 期间 5 20 :p_to_period LOV Oracle PA_SRS_FA_PER_NAME Y select fdp.period_name id, fdp.period_name value, null description from fa_deprn_periods fdp where fdp.book_type_code in (select fdp1.book_type_code from fa_deprn_periods fdp1 where fdp1.period_name=fdp.period_name and rownum=1) order by fdp.period_name Y AR إلى فترة الأصول الثابتة D Bis AN-Periode E A Período de FA F Période FA - A I Periodo FA - A JA FA期間:至 KO FA 기간: 까지 PTB Período FA - Até RU Период ОС по S Till FA-period TR Son FA Dönemi US To FA Period ZHS 至 FA 期间 6 30 :p_from_account Char AR من حساب الأستاذ العام D Von RW-Konto E De Cuenta Contable F Compte GL - De I Conto GL - Da JA GL勘定科目:自 KO GL 계정: 부터 PTB Conta GL - De RU Счет ГК с S Från huvudbokskonto TR İlk GL Hesabı US From GL Account ZHS 自 GL 帐户 7 40 :p_to_account Char AR إلى حساب الأستاذ العام D Bis RW-Konto E A Cuenta Contable F Compte GL - A I Conto GL - A JA GL勘定科目:至 KO GL 계정: 까지 PTB Conta GL - Até RU Счет ГК с 2 S Till huvudbokskonto TR Son GL Hesabı US To GL Account ZHS 至 GL 帐户 8 50 :p_project_type LOV Oracle PA_SRS_PROJECT_TYPE_CAPITAL Y select project_type id, project_type value, description description from pa_project_types where project_type_class_code='CAPITAL' order by project_type AR نوع المشروع D Projektart E Tipo de Proyecto F Type de projet I Tipo di progetto JA プロジェクト・タイプ KO 프로젝트 유형 PTB Tipo de Projeto RU Тип проекта S Projekttyp TR Proje Tipi US Project Type ZHS 项目类型 9 60 :p_project_id LOV Oracle PA_SRS_PROJECT_ID_CAPITAL 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='CAPITAL' and 'Y' in (select pa_utils.initialize from sys.dual) order by project_number_sort_order AR رقم المشروع D Projektnummer E Número de Proyecto F Numéro de projet I Numero progetto JA プロジェクト番号 KO 프로젝트 번호 PTB Nr. do Projeto RU № проекта S Projektnummer TR Proje Numarası US Project Number ZHS 项目编号 10 70 :p_project_org 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 E Organización del Proyecto F Organisation du projet I Organizzazione progetto JA プロジェクト組織 KO 프로젝트 조직 PTB Organização do Projeto RU Проектная организация S Projektorganisation TR Proje Organizasyonu US Project Organization ZHS 项目组织 11 80 :p_class_category LOV Oracle PA_SRS_CAP_CLASS_CATEGORY Y select class_category id, class_category value, description description from pa_class_categories where class_category in (select cc.class_category from pa_class_categories cc ,pa_valid_categories vc ,pa_project_types_all ppta where cc.class_category=vc.class_category and vc.object_type_id=ppta.project_type_id union select cc1.class_category from pa_class_categories cc1 where cc1.object_type='PA_PROJECTS' and cc1.all_types_valid_flag='Y' and not exists (select 'Y' from pa_valid_categories vc1 ,pa_project_types_all ppta1 where vc1.class_category=cc1.class_category and vc1.object_type_id=ppta1.project_type_id)) order by 1 AR فئة الطبقة D Klassenkategorie E Categoría de Clase F Catégorie de classe I Categoria classe JA 区分カテゴリ KO 분류 범주 PTB Categoria da Classe RU Категория класса S Klasskategori TR Sınıf Kategorisi US Class Category ZHS 分类类别 12 90 :p_class_code LOV Oracle PA_SRS_CAP_CLASS_CODE Y select class_code id, class_code value, description description from pa_class_codes where class_category=:$flex$.pa_srs_cap_class_category and (trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)) order by class_code AR رمز الطبقة D Klassenschlüssel E Código de Clase F Code classe I Codice classe JA 区分コード KO 분류 코드 PTB Código da Classe RU Код класса S Klasskod TR Sınıf Kodu US Class Code ZHS 分类代码 13 100 :p_group_by_cat 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' Y AR فرز أساسي حسب فئة الأصل؟ D Primäre Sortierung nach Anlagenkategorie? E ¿Clasificación Primaria por Categoría de Activo? F Tri principal par catégorie d'immobilisation ? I Ordinamento principale per categoria cespite? JA 資産カテゴリで主ソートしますか? KO 자산 범주별 1차 정렬? PTB Classificação Principal por Categoria do Ativo? RU Основная сортировка по категории актива? S Primär sortering efter anläggningskategori? TR Varlık Kategorisine göre Birincil Sıralama? US Primary Sort by Asset Category? ZHS 是否按资产类别进行主要排序？