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）限制的操作单元。 C6E085D4724A51A9E05362FB09050512 SELECT inv.invoice_num C_INVOICE_NUM, inv.invoice_date C_INVOICE_DATE, po_lines.item_description C_DESCRIPTION, pov.vendor_name C_VENDOR_NAME, upper(pov.vendor_name) C_UPP_VENDOR_NAME, hed.segment1 C_P_O, sum(decode(aid.price_adjustment_flag, 'Y',0,'N',aid.quantity_invoiced)) C_QUANTITY_INV, initcap(prefix) C_PREFIX, first_name C_NAME, middle_name C_MIDDLE, last_name C_LAST, upper(last_name) C_UPP_LAST_NAME, location_code C_LINE1, address_line_2 C_LINE2, address_line_3 C_LINE3, town_or_city C_CITY, nvl(region_3,region_2) C_STATE, postal_code C_ZIP, nvl(pod.deliver_to_person_id,hed.agent_id) C_REQUESTOR_ID FROM ap_invoices inv, ap_invoice_distributions aid, po_vendors pov, po_headers hed, po_line_locations pol, po_distributions_ap_v pod, po_lines, ap_holds h, hr_locations locs, hr_employees_current_v emps WHERE inv.payment_status_flag in ('N', 'P') AND inv.invoice_id = aid.invoice_id AND aid.po_distribution_id = pod.po_distribution_id AND inv.vendor_id = pov.vendor_id AND h.line_location_id = pol.line_location_id AND pol.po_header_id = hed.po_header_id AND pol.po_line_id = po_lines.po_line_id AND pod.line_location_id = h.line_location_id AND locs.location_id (+) = emps.location_id AND emps.employee_id = nvl(pod.deliver_to_person_id,hed.agent_id) AND inv.invoice_id = h.invoice_id AND h.hold_lookup_code= 'QTY REC' AND h.release_lookup_code is null GROUP BY inv.invoice_id,pol.line_location_id, first_name, last_name, inv.invoice_num, inv.invoice_date, po_lines.item_description, pol.quantity_received, pol.quantity_billed, vendor_name, hed.segment1, prefix, middle_name, location_code, address_line_2, address_line_3, town_or_city, nvl(region_3,region_2), postal_code, nvl(pod.deliver_to_person_id,hed.agent_id) ORDER BY location_code, upper(last_name), first_name, middle_name, upper(vendor_name), inv.invoice_num, hed.segment1 SQLAP APXVDRAL_XML AR AP إشعار طالب إيقاف الاستلام (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: إشعار طالب إيقاف الاستلام Application: المدفوعات Source: إشعار طالب إيقاف الاستلام (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG D AP Benachrichtigung Annahmesperren- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Benachrichtigung Annahmesperren Application: Kreditoren Source: Benachrichtigung Annahmesperren (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG E AP Carta al Solicitante de Retención por Falta de Acuse de Recibo: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Carta al Solicitante de Retención por falta de Acuse de Recibo Application: Payables Source: Carta al Solicitante de Retención por Falta de Acuse de Recibo (XML): No Admitido, Reservado para Uso Futuro Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG F AP Note au demandeur sur blocage réception- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Note au demandeur sur blocage réception Application: Payables Source: Note au demandeur sur blocage réception (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG I AP Avviso richiedente blocco ricezione- non supportato: riservato per usi futuri Imported from BI Publisher Description: Avviso richiedente blocco della ricezione Application: Payables Source: Avviso richiedente blocco ricezione (XML) - non supportato: riservato per usi futuri Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG JA AP 受入保留依頼者通知- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 受入保留依頼者通知 Application: Payables Source: 受入保留依頼者通知(XML) - 未サポート: 将来の使用のために予約 Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG KO AP 입고 보류 요청자 통보- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 입고보류 요청자 통보 Application: Payables Source: 입고 보류 요청자 통보(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG PTB AP Aviso do Solicitante sobre Retenção do Recebimento- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Aviso do Solicitante em Retenção do Recebimento Application: Payables Source: Aviso do Solicitante sobre Retenção do Recebimento (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG RU AP Извещение источника блокировки получения- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Извещение источника блокировки получения Application: Кредиторы Source: Извещение источника блокировки получения (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG S AP Meddelande till beställare om inleveransspärr- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Meddelande till beställare om inleveransspärr Application: Payables Source: Meddelande till beställare om inleveransspärr (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG TR AP Teslim Alma Durdurma Talep Sahibi Bildirimi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Teslim Alma Durdurma Talep Sahibi Bildirimi Application: Borçlar Muhasebesi Source: Teslim Alma Durdurma Talep Sahibi Bildirimi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG US AP Receiving Hold Requestor Notice- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Receiving Hold Requestor Notice Application: Payables Source: Receiving Hold Requestor Notice (XML) - Not Supported: Reserved For Future Use Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG ZHS AP 接收暂挂申请人通知单- 不支持：已保留供将来使用 Imported from BI Publisher Description: 接收挂起申请人通知书 Application: 应付帐款 Source: 接收暂挂申请人通知单 (XML) - 不支持：已保留供将来使用 Short Name: APXVDRAL_XML DB package: AP_APXVDRAL_XMLP_PKG BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_curdate :c_from_add_line_1 :c_from_add_line_2 :c_from_add_line_3 :c_from_city :c_from_state :c_from_zip :c_nls_all :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_report_run_time :c_report_start_date :operating_unit :p_conc_request_id :p_debug_switch :p_flexdata :p_location_code :p_min_precision :p_organization_name :p_sender_name :p_sender_phone :p_sender_title :p_set_of_books_id 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger ZHS 分类帐 分类帐 2 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 3 10 :p_organization_name Char Y AR اسم التنظيم اسم التنظيم D Organisation Organisation E Nombre de la Organización nombre de la organización F Nom de l'organisation Nom de l'organisation I Nome organizzazione Nome dell'organizzazione JA 組織名称 組織名称 KO 조직명 조직명 PTB Nome da organização nome da organização RU Название организации Название организации S Organisation Organisation TR Organizasyonun adı organizasyon adı US Name of organization name of organization ZHS 组织名称 组织名称 4 20 :p_location_code LOV Oracle AP_SRS_LOCATION Y select location_code id, location_code value, description description from hr_locations order by value,description Y AR موقع التنظيم موقع التنظيم D Adresse Organisation Adresse der Organisation E Ubicación de la Organización ubicación de la organización F Lieu de l'organisation Lieu de l'organisation I Ubicazione organizzazione Ubicazione dell'organizzazione JA 組織事業所 組織事業所 KO 조직 위치 조직 위치 PTB Local da organização local da organização RU Расположение организации Расположение организации S Organisationsort organisationsort TR Organizasyon Yeri organizasyon yeri US Location of organization location of organization ZHS 组织地点 组织地点 5 30 :p_sender_name Char Y AR اسم المرسل اسم المرسل D Absender Absender E Nombre del Remitente nombre del remitente F Nom de l'expéditeur Nom de l'expéditeur I Nome mittente Nome del mittente JA 発送者名 発送者名 KO 발송자명 발송자명 PTB Nome do remetente nome do remetente RU Имя отправителя Имя отправителя S Avsändare avsändare TR Gönderenin Adı gönderenin adı US Name of sender name of sender ZHS 发送者姓名 发送者姓名 6 40 :p_sender_title Char AR لقب المرسل لقب المرسل D Titel Absender Titel des Absenders E Cargo del Emisor cargo del remitente F Fonction de l'expéditeur Fonction de l'expéditeur I Titolo mittente Titolo del mittente JA 発信人職位名 発信人職位名 KO 발송자 직책 발송자 직책 PTB Título do remetente título do remetente RU Должность отправителя Должность отправителя S Avsändarens titel avsändarens titel TR Gönderenin Ünvanı gönderenin ünvanı US Title of sender title of sender ZHS 发送者称呼 发送者称呼 7 50 :p_sender_phone Char AR هاتف المرسل هاتف المرسل D Telefon Absender Telefonnummer des Absenders E Teléfono del Remitente teléfono del remitente F Téléphone de l'expéditeur Téléphone de l'expéditeur I Telefono mittente Telefono del mittente JA 発信人電話番号 発信人電話番号 KO 발송자 전화 발송자 전화 PTB Telefone do remetente telefone do remetente RU Телефон отправителя Телефон отправителя S Telefonnr till avsändare telefonnr till avsändare TR Gönderenin Telefon No gönderenin telefon no US Phone of sender phone of sender ZHS 发送者电话 发送者电话 :$flex$.ledger Ledger Operating Unit