ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714551A9E05362FB09050512Y SELECT -- prr.assignment_action_id prr.assignment_action_id assignment_action_id1, pettl.element_name element_name, pivtl.name input_name, prr.ENTRY_TYPE, prr.status, prv.result_value FROM pay_element_types_f_tl pettl, pay_element_types_f pet, pay_element_classifications pec, pay_input_values_f_tl pivtl, pay_input_values_f piv, pay_run_result_values prv, pay_run_results prr WHERE pet.element_type_id = pettl.element_type_id and pettl.language = userenv('LANG') and piv.input_value_id = pivtl.input_value_id and pivtl.language = userenv('LANG') and prr.element_type_id = pet.element_type_id and pet.classification_id = pec.classification_id and piv.element_type_id = pet.element_type_id and prv.input_value_id = piv.input_value_id and prv.run_result_id = prr.run_result_id and :p_session_date between piv.effective_start_date and piv.effective_end_date and :p_session_date between pet.effective_start_date and pet.effective_end_date and prr.element_type_id = pet.element_type_id and pet.classification_id = pec.classification_id and piv.element_type_id = pet.element_type_id and prv.input_value_id = piv.input_value_id and prv.run_result_id = prr.run_result_id and :p_session_date between piv.effective_start_date and piv.effective_end_date and :p_session_date between pet.effective_start_date and pet.effective_end_date and prv.result_value is not null and pettl.element_name like :p_element_name and prr.assignment_action_id=:assignment_action_id --order by 1,2,3 ORDER BY 2 ASC , 1 , 2 , 3 PAY PAYRPACT_XML AR PAY سرد إجراءات ونتائج كشوف الرواتب حسب الشخص (بتنسيق XML) Imported from BI Publisher Description: سرد إجراءات ونتائج كشوف الرواتب للشخص Application: كشوف الرواتب Source: سرد إجراءات ونتائج كشوف الرواتب حسب الشخص (بتنسيق XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG D PAY Lohn- und Gehaltsabrechnung Vorgänge und Ergebnisse nach Person auflisten Imported from BI Publisher Description: Lohn- und Gehaltsabrechnung Vorgänge und Ergebnisse für eine Person auflisten Application: Lohn und Gehalt Source: Lohn- und Gehaltsabrechnung Vorgänge und Ergebnisse nach Person auflisten (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG E PAY Listar Acciones de Nómina y Resultados por Persona Imported from BI Publisher Description: Listar Acciones de Nómina y Resultados para una Persona Application: Payroll Source: Listar Acciones de Nómina y Resultados por Persona (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG F PAY Lister les actions et les résultats de paye par personne Imported from BI Publisher Description: Lister les actions et les résultats de paye pour une personne Application: Payroll Source: Lister les actions et les résultats de paye par personne (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG I PAY Elenca risultati e azioni ciclo paghe per persona Imported from BI Publisher Description: Elenca i risultati e le azioni del ciclo paghe per una persona Application: Payroll Source: Elenca risultati e azioni ciclo paghe per persona (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG JA PAY 個人別給与計算と結果のリスト Imported from BI Publisher Description: 個人の給与計算と結果のリスト Application: Payroll Source: 個人別給与計算と結果のリスト(XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG KO PAY 개인별 급여 조치 및 결과 목록 Imported from BI Publisher Description: 개인 급여 조치 및 결과 목록 Application: Payroll Source: 개인별 급여 조치 및 결과 목록(XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG PTB PAY Listar Ações da Folha de Pagamento e Resultados por Pessoa Imported from BI Publisher Description: Listar Ações de Folha de Pagamento e Resultados para uma Pessoa Application: Folha de Pagto. Source: Listar Ações da Folha de Pagamento e Resultados por Pessoa (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG RU PAY Список действий ведомости и результатов для лица Imported from BI Publisher Description: Список действий ведомости и результатов для лица Application: Заработная плата Source: Список действий ведомости и результатов для лица (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG S PAY Lista lönegruppsåtgärder och resultat per person Imported from BI Publisher Description: Listar lönegruppsåtgärder och resultat för en person Application: Payroll Source: Lista lönegruppsåtgärder och resultat per person (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG TR PAY Bordro Eylemlerini ve Sonuçlarını Kişiye Göre Listele Imported from BI Publisher Description: Bir Kişi için Bordro Eylemleri ve Sonuçlarını listeler Application: Bordro Source: Bordro Eylemlerini ve Sonuçlarını Kişiye Göre Listele (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG US PAY List Payroll Actions and Results By Person Imported from BI Publisher Description: List Payroll Actions and Results for a Person Application: Payroll Source: List Payroll Actions and Results By Person (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG ZHS PAY 按人员列出工资单活动和结果 Imported from BI Publisher Description: 列出人员的工资单活动和结果 Application: 工资单 Source: 按人员列出工资单活动和结果 (XML) Short Name: PAYRPACT_XML DB package: PAY_PAYRPACT_XMLP_PKG BI Publisher :assignment_action_id :c_business_group_name :c_person_name :c_report_subtitle :p_business_group_id :p_conc_request_id :p_element_name :p_person_id :p_session_date :p_start_date :person_id :session_date 1 -30 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال معرف مجموعة الأعمال D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Id Grupo de Trabajo F ID entité professionnelle ID entité professionnelle I Id business group Id del business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB Id do Grupo Funcional Id do Grupo Funcional RU Идент. бизнес-группы Идент. бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu No İş Grubu No US Business Group Id Business Group Id ZHS 业务组标识 业务组标识 2 -20 :p_session_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('sessionid') Y AR PER_DATES_STANDARD تاريخ الجلسة D PER_DATES_STANDARD Sitzungsdatum E PER_DATES_STANDARD Fecha de Sesión F PER_DATES_STANDARD Date de la session I PER_DATES_STANDARD Data sessione JA PER_DATES_STANDARD セッション日付 KO PER_DATES_STANDARD 세션 일자 PTB PER_DATES_STANDARD Data da Sessão RU PER_DATES_STANDARD Дата сеанса S PER_DATES_STANDARD Sessionsdatum TR PER_DATES_STANDARD Kurs Tarihi US PER_DATES_STANDARD Session Date ZHS PER_DATES_STANDARD 会话日期 3 10 :p_person_id LOV Oracle PER_ALL_PEOPLE Y select person_id id, full_name value, null description from per_people_f p where (p.business_group_id= fnd_global.per_business_group_id and ((to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') between p.effective_start_date and p.effective_end_date) or (to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') >p.effective_end_date and p.effective_end_date= (select max(p1.effective_end_date) from per_all_people_f p1 where p1.person_id=p.person_id)) or (to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') <p.effective_start_date and p.effective_start_date=p.start_date))) order by p.full_name AR الشخص الشخص E Persona Persona F Personne Personne I Persona Persona JA 個人 個人 KO 개인 개인 PTB Pessoa Pessoa RU Лицо Лицо TR Kişi Kişi US Person Person ZHS 人员 人员 4 20 :p_element_name Char % AR اسم العنصر (مع حرف مثال) أدخل الاسم أو اسم العنصر الجزئي D Elementbezeichnung (mit Platzhalter) Elementbezeichnung ganz oder teilweise eingeben E Nombre de Elemento (con comodín) Introducir Nombre o nombre del elemento parcial F Nom élément (avec caractère joker) Saisir le nom ou une partie du nom de l'élément I Nome elemento (con carattere jolly) Inserisce il nome o il nome parziale dell'elemento JA エレメント名 (ワイルドカード付き) 名称またはエレメント名の一部を入力 KO 항목명(와일드 카드 문자 포함) 이름 또는 일부 항목명 입력 PTB Nome do Elemento (com curinga) Entrar com Nome ou nome de elemento parcial RU Имя элемента (с подстановочным знаком) Ввод полного или части имени элемента S Löneart (med jokertecken) Ange namn eller delnamn för löneart TR Kalem Adları (Joker Karakterlerle) Adı veya kısmi kalem adını girin US Element Name(with wildcard) Enter Name or partial element name ZHS 要素名称（具有通配符） 输入名称或部分要素名称 5 30 :p_start_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('sessionid') Y AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio Fecha de Inicio F Date de début Date de début I Data inizio Data di inizio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial Data Inicial RU Начальная дата Начальная дата S Startdatum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US Start Date Start Date ZHS 起始日期 起始日期