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）限制的操作单元。 41D6D8E71562CFA3E06362FB090507E0 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, &il_reg_columns &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp from hr_all_organization_units_vl haouv, ap_invoices_all aia, ap_suppliers aps, hz_parties hp &il_from where 1=1 and haouv.organization_id=aia.org_id and aia.vendor_id=aps.vendor_id(+) and aia.party_id=hp.party_id &il_where order by aia.invoice_date, aia.invoice_currency_code, aia.invoice_amount, upper(aps.vendor_name), upper(aia.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 AR AP قائمة تدقيق الفواتير Imported from Concurrent Program Application: المدفوعات Source: قائمة تدقيق الفواتير Short Name: APXINLST DB package: D AP Rechnungsliste Imported from Concurrent Program Application: Kreditoren Source: Rechnungsliste Short Name: APXINLST DB package: E AP Listado de Auditoría de Facturas Imported from Concurrent Program Application: Payables Source: Listado de Auditoría de Facturas Short Name: APXINLST DB package: F AP Liste détaillée des factures Imported from Concurrent Program Application: Payables Source: Liste détaillée des factures Short Name: APXINLST DB package: I AP Elenco audit fatture Imported from Concurrent Program Application: Payables Source: Elenco audit fatture Short Name: APXINLST DB package: JA AP 請求書監査一覧 Imported from Concurrent Program Application: Payables Source: 請求書監査一覧 Short Name: APXINLST DB package: KO AP 송장 감사 목록 Imported from Concurrent Program Application: Payables Source: 송장 감사 목록 Short Name: APXINLST DB package: PTB AP Lista de Auditoria de NFFs Imported from Concurrent Program Application: Payables Source: Lista de Auditoria de NFFs Short Name: APXINLST DB package: RU AP Список аудита счетов-фактур Imported from Concurrent Program Application: Кредиторы Source: Список аудита счетов-фактур Short Name: APXINLST DB package: S AP Fakturor - kontrollista Imported from Concurrent Program Application: Payables Source: Fakturor - kontrollista Short Name: APXINLST DB package: TR AP Fatura Denetim Listesi Imported from Concurrent Program Application: Borçlar Muhasebesi Source: Fatura Denetim Listesi Short Name: APXINLST DB package: US AP Invoice Audit Listing(GST) Imported Oracle standard 'Invoice Audit Listing' report Application: Payables Source: Invoice Audit Listing Short Name: APXINLST ZHS AP 发票审核列表 Imported from Concurrent Program Application: 应付帐款 Source: 发票审核列表 Short Name: APXINLST DB package: Enginatics GST Reports R12 only &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp &il_from &il_reg_columns &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_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 5 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 6 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 最小发票额 最小发票额 7 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 发票起始日期 起始发票日期 8 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