ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B20C1D394FC36EDDE0530100007F5621 AP Invoice Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type(+)='INVOICE TYPE' and flvv.view_application_id(+)=200 and flvv.security_group_id(+)=0 order by flvv.meaning US 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）限制的操作单元。 D4AA6E8D0487F53BE0530100007FD9ACY select haouv.name operating_unit, aia.invoice_num invoice_number, aia.invoice_date, aia.invoice_currency_code currency_code, aia.invoice_amount, aia.description, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, nvl(aps.vendor_name,hp.party_name) vendor_name, nvl(aps.segment1,hp.party_number) vendor_number, nvl(to_char(aia.doc_sequence_value),aia.voucher_num) voucher_number from hr_all_organization_units_vl haouv, ap_invoices_all aia, ap_suppliers aps, hz_parties hp where 1=1 and haouv.organization_id=aia.org_id and aia.vendor_id=aps.vendor_id(+) and aia.party_id=hp.party_id order by aia.invoice_date, aia.invoice_currency_code, aia.invoice_amount, upper(aps.vendor_name), upper(aia.invoice_num) AR AP Invoice Audit Listing Imported from Concurrent Program Application: المدفوعات Source: قائمة تدقيق الفواتير Short Name: APXINLST DB package: D AP Invoice Audit Listing Imported from Concurrent Program Application: Kreditoren Source: Rechnungsliste Short Name: APXINLST DB package: E AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: Listado de Auditoría de Facturas Short Name: APXINLST DB package: F AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: Liste détaillée des factures Short Name: APXINLST DB package: I AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: Elenco audit fatture Short Name: APXINLST DB package: JA AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: 請求書監査一覧 Short Name: APXINLST DB package: KO AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: 송장 감사 목록 Short Name: APXINLST DB package: PTB AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: Lista de Auditoria de NFFs Short Name: APXINLST DB package: RU AP Invoice Audit Listing Imported from Concurrent Program Application: Кредиторы Source: Список аудита счетов-фактур Short Name: APXINLST DB package: S AP Invoice Audit Listing Imported from Concurrent Program Application: Payables Source: Fakturor - kontrollista Short Name: APXINLST DB package: TR AP Invoice Audit Listing Imported from Concurrent Program Application: Borçlar Muhasebesi Source: Fatura Denetim Listesi Short Name: APXINLST DB package: US AP Invoice Audit Listing Imported Oracle standard 'Invoice Audit Listing' report Application: Payables Source: Invoice Audit Listing Short Name: APXINLST ZHS AP Invoice Audit Listing Imported from Concurrent Program Application: 应付帐款 Source: 发票审核列表 Short Name: APXINLST DB package: Enginatics R12 only 1=1 1 10 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 aia.invoice_amount>=:min_invoice_amount Number AR الحد الأدنى لقيمة الفاتورة الحد الأدنى لقيمة الفاتورة D Mindest-Rechnungsbetrag Mindest-Rechnungsbetrag E Importe Mínimo de Factura importe mínimo de factura F Montant minimum de la facture Montant minimum de facture I Importo minimo fattura Importo minimo fattura JA 最小請求書金額 最小請求書金額 KO 최소 송장 금액 최소 송장 금액 PTB Quantia Mínima da NFF quantia mínima da NFF RU Минимальная сумма по счету-фактуре Минимальная сумма по счету-фактуре S Lägsta fakturabelopp lägsta fakturabelopp TR Minimum Fatura Tutarı minimum fatura tutarı US Minimum Invoice Amount minimum invoice amount ZHS 最小发票额 最小发票额 3 30 1=1 aia.invoice_date>=:begin_invoice_date Date AR تاريخ بداية الفاتورة تاريخ بداية الفاتورة D Von Rechnungsdatum Von Rechnungsdatum E De Fecha de Factura de fecha de factura F Date de début de la facture Date début facture I Data fattura iniziale Data della fattura iniziale JA 開始請求書日付 開始請求書日付 KO 송장 시작 일자 송장 시작 일자 PTB Data da NFF Inicial data da NFF inicial RU Начальная дата счета-фактуры Начальная дата счета-фактуры S Från fakturadatum från fakturadatum TR İlk Fatura Tarihi fatura başlangıç tarihi US Begin Invoice Date begin invoice date ZHS 发票起始日期 起始发票日期 4 40 1=1 aia.invoice_type_lookup_code=xxen_util.lookup_code(:invoice_type,'INVOICE TYPE',200) LOV AP Invoice Type B20C1D394FC36EDDE0530100007F5621 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type(+)='INVOICE TYPE' and flvv.view_application_id(+)=200 and flvv.security_group_id(+)=0 order by flvv.meaning F Type de facture US Invoice Type