ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF1479D2E0530100007F1FF2 AP Supplier Number Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id 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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 5CC0ACB607C12F6DE0536209825E34CA select apsa.due_date, hp.party_name trading_partner, aia.invoice_num, aia.invoice_date, ap_apxcrrcr_xmlp_pkg.c_amountformula(assa.always_take_disc_flag, apsa.discount_amount_available, apsa.discount_date, apsa.second_discount_date, apsa.second_disc_amt_available, apsa.third_discount_date, apsa.third_disc_amt_available, apsa.gross_amount, apsa.amount_remaining) amount, aia.payment_currency_code payment_currency, aia.pay_group_lookup_code pay_group, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, xxen_util.meaning(case when aia.wfapproval_status in('MANUALLY APPROVED','NOT REQUIRED','WFAPPROVED') then 'Y' else 'N' end,'YES_NO',0) approved, xxen_util.meaning(ap_invoices_utility_pkg.get_payment_status(aia.invoice_id),'INVOICE PAYMENT STATUS',200) payment_status, aia.description, decode(aia.holds_count,0,null,aia.holds_count) holds_count, trunc(apsa.due_date-sysdate) days_to_due, apsa.future_pay_due_date, apsa.gross_amount, apsa.hold_flag, xxen_util.meaning(apsa.payment_method_lookup_code,'PAYMENT METHOD',200) payment_method, apsa.payment_priority, apsa.discount_date, apsa.second_discount_date, apsa.third_discount_date, apsa.discount_amount_available, apsa.second_disc_amt_available, apsa.third_disc_amt_available, apsa.discount_amount_remaining, apsa.inv_curr_gross_amount, aia.exchange_rate, aia.payment_cross_rate, ap_apxcrrcr_xmlp_pkg.c_base_currency_amountformula( assa.always_take_disc_flag, apsa.discount_amount_available, apsa.discount_date, apsa.second_discount_date, apsa.second_disc_amt_available, apsa.third_discount_date, apsa.third_disc_amt_available, apsa.gross_amount, apsa.amount_remaining, fc.minimum_accountable_unit, aia.exchange_rate, aia.payment_cross_rate, fc.precision) functional_currency_amount, aspa.base_currency_code functional_currency_code, fc.minimum_accountable_unit base_min_unit, fc.precision functional_precision, sum(case when aia.invoice_currency_code=aspa.base_currency_code or fc.derive_type in ('EURO','EMU') or aia.exchange_rate is not null then 0 else 1 end) over (partition by aia.invoice_currency_code) num_invoices_no_rate, aia.invoice_currency_code, gl.name ledger, hou.name operating_unit, aia.invoice_id from gl_ledgers gl, hr_operating_units hou, ap_system_parameters_all aspa, ap_payment_schedules_all apsa, ( select (select count(*) from ap_holds_all aha where aia.invoice_id=aha.invoice_id and aha.release_lookup_code is null) holds_count, aia.* from ap_invoices_all aia ) aia, fnd_currencies fc, hz_parties hp, ap_suppliers aps, ap_supplier_sites_all assa &apt_table where 1=1 and apsa.payment_status_flag in ('N','P') and aia.payment_status_flag in ('N','P') and aia.cancelled_date is null and nvl(apsa.hold_flag,'N')='N' and nvl(assa.hold_all_payments_flag,'N')='N' and gl.ledger_id=hou.set_of_books_id and hou.set_of_books_id=aspa.set_of_books_id and hou.organization_id=aspa.org_id and hou.organization_id=apsa.org_id and apsa.invoice_id=aia.invoice_id and aia.invoice_currency_code=fc.currency_code and aia.party_id=hp.party_id and aia.vendor_id=aps.vendor_id(+) and aia.vendor_id=assa.vendor_id(+) and aia.vendor_site_id=assa.vendor_site_id(+) order by hou.name, aia.invoice_currency_code, apsa.due_date, hp.party_name, aia.invoice_num Renamed base to functional amount column Y AR AP Cash Requirement Application: المدفوعات Source: تقرير المتطلبات النقدية Short Name: APXCRRCR D AP Cash Requirement Application: Kreditoren Source: Zahlungsmittelbedarf Short Name: APXCRRCR E AP Cash Requirement Informe detallado de las necesidades de tesorería que muestra todos los importes impagados o parcialmente pagados, cuando la factura no está retenida ni cancelada, incluyendo el importe de la moneda de la factura, el tipo de cambio y el código de la moneda F AP Cash Requirement Application: Payables Source: Etat des besoins prévisionnels de trésorerie Short Name: APXCRRCR I AP Cash Requirement Application: Payables Source: Rapporto Fabbisogno cassa Short Name: APXCRRCR JA AP Cash Requirement 請求書が保留でもキャンセルでもない場合、請求書の通貨金額、為替レート、通貨コードを含む、すべての未払い金額または一部支払い金額を表示する現金必要量の詳細レポート KO AP Cash Requirement 송장 통화 금액, 환율 및 통화 코드를 포함하여 송장이 보류 또는 취소되지 않은 모든 미지급 또는 부분 지급 금액을 보여주는 세부 현금 요구 사항 보고서 PTB AP Cash Requirement Relatório detalhado das necessidades de caixa mostrando todos os valores não pagos ou parcialmente pagos, onde a fatura não está em espera nem cancelada, incluindo o valor da moeda da fatura, taxa de câmbio e código da moeda RU AP Cash Requirement Подробный отчет о потребностях в наличных средствах с указанием всех невыплаченных или частично оплаченных сумм, когда счет-фактура не приостановлена и не аннулирована, включая сумму в валюте счета-фактуры, обменный курс и валютный код S AP Cash Requirement Detaljerad rapport om kontantbehov som visar alla obetalda eller delvis betalade belopp, där fakturan varken är spärrad eller annullerad, inklusive fakturavalutabelopp, växelkurs och valutakod TR AP Cash Requirement Fatura para birimi tutarı, döviz kuru ve para birimi kodu dahil olmak üzere, faturanın bekletilmediği veya iptal edilmediği tüm ödenmemiş veya kısmen ödenmiş tutarları gösteren ayrıntılı nakit gereksinimi raporu US AP Cash Requirement Detail cash requirement report showing all unpaid or partially paid amounts, where the invoice is neither on hold nor cancelled, including invoice currency amount, exchange rate, and currency code ZHS AP Cash Requirement Application: 应付帐款 Source: 现金需求报表 Short Name: APXCRRCR Enginatics R12 only &apt_table 1=1 1 10 1=1 hou.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.wfapproval_status in ('NOT REQUIRED', 'WFAPPROVED', 'MANUALLY APPROVED') LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description D Mit nicht validierten Rechnungen F Inclure les factures non validées I Includi fatture non convalidate US Include Unvalidated Invoices 3 30 1=1 nvl(ap_invoices_pkg.get_approval_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code),'n/a')not in('NEVER APPROVED', 'NEEDS REAPPROVAL', 'UNAPPROVED') LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description D Mit nicht genehmigten Rechnungen F Inclure les factures non approuvées I Include fatture non approvate US Include Unapproved Invoices 4 40 1=1 :pay_through_date=:pay_through_date Date F Date de fin de paiement US Pay Through Date 5 50 1=1 :payment_date=:payment_date Date D Zahlungsdatum F Date de paiement I Data pagamento US Payment Date 6 60 &apt_table ,( select :template_id template_id_, nvl(to_date(:payment_date),sysdate+nvl(decode(apt.payment_date_option,'EXTRADAYS',apt.addl_payment_days),0)) payment_date, nvl(:pay_through_date, sysdate+apt.addl_pay_thru_days) pay_through_date, sysdate-apt.addl_pay_from_days pay_from_date, decode(apt.pay_only_when_due_flag,'Y',to_date('01/01/80','MM/DD/RR'),nvl(:pay_through_date,sysdate+apt.addl_pay_thru_days)) disc_pay_thru_date, apt.* from ap_payment_templates apt where apt.template_id=:template_id ) apt LOV Oracle AP_PAY_PROCESS_TEMPLATES Y select template_id id, template_name value, null description from ap_payment_templates where decode(sign(trunc(sysdate+1)-nvl(inactive_date, trunc(sysdate+1))),1,'INACTIVE','ACTIVE')='ACTIVE' order by value,description D Schema F Modèle I Modello US Template 7 1=1 nvl(apsa.payment_priority,99) between apt.hi_payment_priority and apt.low_payment_priority and (apt.vendor_type_lookup_code is null or apt.vendor_type_lookup_code=aps.vendor_type_lookup_code) and (apt.vendor_id is null or apt.vendor_id=aia.vendor_id) and (apt.party_id is null or apt.party_id=aia.party_id) and (apt.payment_method_code is null or apt.payment_method_code=apsa.payment_method_code) and ( aia.exchange_rate_type='USER' and apt.inv_exchange_rate_type='IS_USER' or aia.exchange_rate_type<>'USER' and apt.inv_exchange_rate_type = 'IS_NOT_USER' or aia.exchange_rate_type is null or apt.inv_exchange_rate_type is null ) and (apt.zero_inv_allowed_flag='Y' or apsa.amount_remaining<>0) and (apt.pay_group_option='ALL' or aia.pay_group_lookup_code in (select apg.vendor_pay_group from ap_pay_group apg where apt.template_id=apg.template_id)) and (apt.currency_group_option='ALL' or aia.payment_currency_code in (select acg.currency_code from ap_currency_group acg where apt.template_id=acg.template_id)) and (apt.le_group_option='ALL' or aia.legal_entity_id in (select alg.legal_entity_id from ap_le_group alg where apt.template_id=alg.template_id)) and (apt.ou_group_option='ALL' or aia.org_id in (select aog.org_id from ap_ou_group aog where apt.template_id=aog.template_id)) and ( trunc(apsa.due_date)<=apt.pay_through_date and trunc(apsa.due_date)>=nvl(apt.pay_from_date,trunc(due_date)) or decode(nvl(assa.pay_date_basis_lookup_code,'DISCOUNT'),'DISCOUNT', decode(assa.always_take_disc_flag,'Y',apsa.discount_date, case when apt.payment_date<nvl(apsa.discount_date,apt.payment_date+1)-1 then apsa.discount_date when apt.payment_date<nvl(apsa.second_discount_date,apt.payment_date+1)-1 then apsa.second_discount_date when apt.payment_date<nvl(apsa.third_discount_date,apt.payment_date+1)-1 then apsa.third_discount_date else trunc(apsa.due_date) end ), trunc(apsa.due_date) ) between decode(assa.always_take_disc_flag,'Y',nvl(apt.pay_from_date,to_date('1901','YYYY')),apt.payment_date) and apt.disc_pay_thru_date ) F Modèle US Template 8 70 1=1 apsa.checkrun_id is null LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y D Mit ausgewählten Rechnungen F Exclure les factures sélectionnées I Include fatture selezionate US Exclude Selected Invoices 9 80 1=1 aps.vendor_name=:vendor_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 10 90 1=1 aps.segment1=:supplier_number LOV AP Supplier Number 8E2FF36EDF1479D2E0530100007F1FF2 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id F Numéro de fournisseur US Supplier Number 11 100 1=1 aps.vendor_type_lookup_code=xxen_util.lookup_code('Employee','VENDOR TYPE',201) LOV custom Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='VENDOR TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning F Type de fournisseur US Supplier Type 12 110 1=1 apsa.due_date>=:due_date_from Date D Fälligkeiten bis F Date d'échéance De I Pagamento fino al US Due Date From 13 120 1=1 apsa.due_date<:due_date_to+1 Date last_day(:$flex$.Due_Date_From) F Date d'échéance à US Due Date To 14 130 1=1 nvl(apsa.payment_priority,99)<=:payment_priority_from Number F Priorité de paiement De US Payment Priority From 15 140 1=1 nvl(apsa.payment_priority,99)>=:payment_priority_to Number F Priorité de paiement à US Payment Priority To 16 150 1=1 apsa.payment_method_lookup_code=:pyment_method_code LOV Oracle AP_SRS_PAYMENT_METHOD Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='PAYMENT METHOD' order by value,description US Payment Method 17 160 1=1 fv_econ_benf_disc.ebd_check(null, aia.invoice_id, :payment_date, apsa.due_date, apsa.discount_amount_available, apsa.discount_date)='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Bénéfique sur le plan économique US Economically Beneficial :$flex$.Due_Date_From Due Date From Y Due Date To :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Supplier Number