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 20DD13FB13D6C27DC32DC39BB9ADA3F1 select x.*, &il_reg_columns &il_tax_columns from ( 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, &il_tax_columns_inner_amt &il_tax_columns_inner_rate &il_tax_columns_inner_tp 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 &il_from 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(+) &il_where ) x order by x.operating_unit, x.invoice_currency_code, x.due_date, x.trading_partner, x.invoice_num added JAI GST columns as dynamic lexical parameters to support instances with India localization Restructured GST lexical parameters: renamed gst to il anchors, added India Localization hidden parameter to gate JAI columns via matching_value mechanism Y 5CC0ACB607C12F6DE0536209825E34CA AR AP Cash Requirement (GST) Application: المدفوعات Source: تقرير المتطلبات النقدية Short Name: APXCRRCR D AP Cash Requirement (GST) Application: Kreditoren Source: Zahlungsmittelbedarf Short Name: APXCRRCR F AP Cash Requirement (GST) Application: Payables Source: Etat des besoins prévisionnels de trésorerie Short Name: APXCRRCR I AP Cash Requirement (GST) Application: Payables Source: Rapporto Fabbisogno cassa Short Name: APXCRRCR US AP Cash Requirement (GST) 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, with JAI GST tax columns ZHS AP Cash Requirement (GST) Application: 应付帐款 Source: 现金需求报表 Short Name: APXCRRCR GST Reports R12 only &apt_table &il_from &il_reg_columns &il_tax_columns &il_tax_columns_inner_amt &il_tax_columns_inner_rate &il_tax_columns_inner_tp &il_where 1=1 1 -20 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_from ,(select s.party_id vendor_id, s.party_site_id vendor_site_id, s.gstin gstin_or_secondary, nvl(s.pan_site,nvl(s.sec_pan_site,nvl(h.pan_hdr,h.sec_pan_hdr))) pan_number, nvl(s.tan_site,nvl(s.sec_tan_site,nvl(h.tan_hdr,h.sec_tan_hdr))) tan_number from (select jpr.party_id, jpr.party_site_id, max(decode(jprl.registration_type_code,'GSTIN',nvl(jprl.registration_number,jprl.secondary_registration_number))) gstin, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_site, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_site, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_site, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_site from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY_SITE' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id, jpr.party_site_id) s, (select jpr.party_id, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_hdr, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_hdr, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_hdr, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_hdr from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id) h where s.party_id=h.party_id(+) ) il_reg ,(select jtlv.trx_id, jtlv.trx_line_id, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_tax_amt_trx_curr)) cgst_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rounded_tax_amt_trx_curr)) sgst_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rounded_tax_amt_trx_curr)) igst_amount, sum(decode(jrav.reporting_code,'CESS',jtlv.rounded_tax_amt_trx_curr)) cess_amount, max(decode(jrav.reporting_code,'CGST',jtlv.tax_rate_code)) cgst_tax_rate, max(decode(jrav.reporting_code,'SGST',jtlv.tax_rate_code)) sgst_tax_rate, max(decode(jrav.reporting_code,'IGST',jtlv.tax_rate_code)) igst_tax_rate, max(decode(jrav.reporting_code,'CESS',jtlv.tax_rate_code)) cess_tax_rate, sum(decode(jrav.reporting_code,'CGST',jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rec_tax_amt_trx_curr)) igst_rec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount, max(jtlv.self_assessed_flag) reverse_charge_flag from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav where jrav.entity_id(+)=jtlv.tax_type_id and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.application_id=200 group by jtlv.trx_id, jtlv.trx_line_id ) il_tax Y US India Localization 3 &il_reg_columns il_reg.gstin_or_secondary gst_registration_no, il_reg.pan_number gst_pan_no, il_reg.tan_number gst_tan_no, Y US India Localization 4 &il_tax_columns x.cgst_amount, x.sgst_amount, x.igst_amount, x.cgst_tax_rate, x.sgst_tax_rate, x.igst_tax_rate, x.unit_registration_number, x.gst_supplier_registration_no Y US India Localization 5 &il_where and aia.vendor_id=il_reg.vendor_id(+) and aia.vendor_site_id=il_reg.vendor_site_id(+) and aia.invoice_id=il_tax.trx_id(+) Y US India Localization 6 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 7 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 8 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 9 40 1=1 :pay_through_date=:pay_through_date Date F Date de fin de paiement US Pay Through Date 10 50 1=1 :payment_date=:payment_date Date D Zahlungsdatum F Date de paiement I Data pagamento US Payment Date 11 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 12 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 13 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 14 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 15 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 16 100 1=1 aps.vendor_type_lookup_code=xxen_util.lookup_code('Employee','VENDOR TYPE',201) LOV custom Y select flv.meaning value, null description from fnd_lookup_values flv where flv.lookup_type='VENDOR TYPE' and flv.language=userenv('lang') and flv.view_application_id=201 and flv.security_group_id=0 and flv.enabled_flag='Y' order by flv.meaning F Type de fournisseur US Supplier Type 17 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 18 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 19 130 1=1 nvl(apsa.payment_priority,99)<=:payment_priority_from Number F Priorité de paiement De US Payment Priority From 20 140 1=1 nvl(apsa.payment_priority,99)>=:payment_priority_to Number F Priorité de paiement à US Payment Priority To 21 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 22 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