ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4723451A9E05362FB09050512 select x.receipt_number, x.receipt_creation_date, x.receipt_last_modified, x.supplier, x.supplier_site, x.receipt_line_num, x.received_qty, x.adjustment_qty, x.adjustment_date, x.po_number, x.invoice_number, x.invoice_status, x.invoice_line_number, x.billed_qty, x.invoice_line_creation_date, x.operating_unit, x.adjutment_transaction_id &il_reg_columns &il_columns from ( select rsh.receipt_num receipt_number, trunc(rsh.creation_date) receipt_creation_date, trunc(rsh.last_update_date) receipt_last_modified, pv.vendor_name supplier, pvs.vendor_site_code supplier_site, rsl.line_num receipt_line_num, rsl.quantity_received received_qty, rct1.primary_quantity adjustment_qty, trunc(rct1.creation_date) adjustment_date, po.segment1 po_number, ai.invoice_num invoice_number, alc.displayed_field invoice_status, ail.line_number invoice_line_number, ail.quantity_invoiced billed_qty, trunc(ail.creation_date) invoice_line_creation_date, haouv.name operating_unit, rct1.transaction_id adjutment_transaction_id &il_columns_inner_amt &il_columns_inner_rate &il_columns_inner_tp from ap_invoices_all ai, ap_invoice_lines_all ail, po_vendors pv, po_vendor_sites_all pvs, po_headers_all po, rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions rct, rcv_transactions rct1, ap_lookup_codes alc, hr_all_organization_units_vl haouv &il_from where 1=1 and ai.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and ai.invoice_id=ail.invoice_id and rct.transaction_id = ail.rcv_transaction_id and pv.vendor_id = ai.vendor_id and pvs.vendor_site_id = ai.vendor_site_id and po.po_header_id = rsl.po_header_id and rsl.shipment_line_id = rct.shipment_line_id and rct.shipment_header_id = rsh.shipment_header_id and rct1.shipment_header_id = rct.shipment_header_id and rct1.shipment_line_id = rct.shipment_line_id and rct1.transaction_type in ('CORRECT','RETURN TO VENDOR','REJECT','RETURN TO RECEIVING','ACCEPT') and rct1.creation_date > ail.creation_date and alc.lookup_type(+) ='NLS TRANSLATION' and alc.lookup_code = nvl(:p_approval_status,ap_invoices_pkg.get_approval_status(ai.invoice_id,ai.invoice_amount,ai.payment_status_flag,ai.invoice_type_lookup_code)) and ai.org_id = haouv.organization_id and (:p_approval_status is null or (upper(:p_approval_status) = 'PAID' and ai.payment_status_flag in ('Y','P')) or (upper(:p_approval_status) != 'PAID' and ap_invoices_pkg.get_approval_status(ai.invoice_id,ai.invoice_amount,ai.payment_status_flag,ai.invoice_type_lookup_code) = :p_approval_status) ) &il_where ) x order by x.supplier, x.supplier_site, x.receipt_number, x.receipt_line_num, x.adjutment_transaction_id, x.invoice_number, x.invoice_line_number Operating unit security reads the Blitz Report organization access alone, which already holds the operating unit of an 11i responsibility. Y SQLAP AR AP تقرير الإيصالات المعدَّلة والمطابقة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير الإيصالات المعدلة والمطابقة Application: المدفوعات Source: تقرير الإيصالات المعدَّلة والمطابقة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG D AP Abgeglichene und geänderte Wareneingänge- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Abgeglichene und geänderte Wareneingänge Application: Kreditoren Source: Abgeglichene und geänderte Wareneingänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG E AP Informe Recepciones Confrontadas y Modificadas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de recepciones confrontadas y modificadas Application: Payables Source: Informe Recepciones Confrontadas y Modificadas (XML): No Admitido, Reservado para Uso Futuro Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG F AP Etat des réceptions rapprochées et modifiées- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des réceptions rapprochées et modifiées Application: Payables Source: Etat des réceptions rapprochées et modifiées (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG I AP Rapporto Incassi confrontati e modificati- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Incassi confrontati e modificati Application: Payables Source: Rapporto Incassi confrontati e modificati (XML) - non supportato: riservato per usi futuri Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG JA AP 照合済み受入と変更済み受入のレポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 照合および修正受入レポート Application: Payables Source: 照合済み受入と変更済み受入のレポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG KO AP 대응 및 수정된 수금 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 대응 및 수정된 수금 보고서 Application: Payables Source: 대응 및 수정된 수금 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG PTB AP Relatório de Recebimentos Vinculados e Modificados- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relat. de Receitas Modific. e Corresp. Application: Payables Source: Relatório de Recebimentos Vinculados e Modificados (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG RU AP Отчет о согласованных и измененных поступлениях- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о согласованных и измененных поступлениях Application: Кредиторы Source: Отчет о согласованных и измененных поступлениях (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG S AP Matchade och ändrade inbetalningar - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Matchade och ändrade inbetalningar - rapport Application: Payables Source: Matchade och ändrade inbetalningar - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG TR AP Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu Application: Borçlar Muhasebesi Source: Eşleşen ve Değiştirilmiş Alınan Ödemeler Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG US AP Matched and Modified Receipts Imported from BI Publisher Description: Matched and Modified Receipts Report Application: Payables Source: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CGST Rate, SGST Rate, IGST Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code. ZHS AP 匹配并修改的接收报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 匹配并修改的接收报表 Application: 应付帐款 Source: 匹配并修改的接收报表 (XML) - 不支持：已保留供将来使用 Short Name: APXMTMRR_XML DB package: AP_APXMTMRR_XMLP_PKG Enginatics R12 only &il_columns &il_columns_inner_amt &il_columns_inner_rate &il_columns_inner_tp &il_from &il_reg_columns &il_where 1=1 :p_approval_status 1 -20 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_columns x.cgst_amount "CGST Amount", x.sgst_amount "SGST Amount", x.igst_amount "IGST Amount", x.cgst_tax_rate "CGST Rate", x.sgst_tax_rate "SGST Rate", x.igst_tax_rate "IGST Rate", x.custom_amount, x.unclassified_amount "Unclassified Tax Amount", x.taxable_value, x.hsn_sac_code "HSN SAC Code" Y US India Localization 3 &il_columns_inner_amt ,il_tax.cgst_amount, il_tax.sgst_amount, il_tax.igst_amount, il_tax.custom_amount, il_tax.unclassified_amount, il_tax.taxable_value, il_tax.hsn_sac_code Y US India Localization 4 &il_columns_inner_rate ,il_tax.cgst_tax_rate, il_tax.sgst_tax_rate, il_tax.igst_tax_rate Y US India Localization 5 &il_columns_inner_tp ,nvl(il_reg_site.gstin,il_reg_hdr.gstin_hdr) gst_registration_no, nvl(il_reg_site.pan_site,nvl(il_reg_site.sec_pan_site,nvl(il_reg_hdr.pan_hdr,il_reg_hdr.sec_pan_hdr))) gst_pan_no, nvl(il_reg_site.tan_site,nvl(il_reg_site.sec_tan_site,nvl(il_reg_hdr.tan_hdr,il_reg_hdr.sec_tan_hdr))) gst_tan_no Y US India Localization 6 &il_from ,(select jpr.party_id, jpr.party_site_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) 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 jpr.supplier_flag='Y' 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) il_reg_site ,(select jpr.party_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin_hdr, 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 jpr.supplier_flag='Y' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id) il_reg_hdr ,(select jtlv.trx_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, sum(decode(jrav.reporting_code,'CUSTOM',jtlv.rounded_tax_amt_trx_curr)) custom_amount, sum(decode(jrav.reporting_code,null,jtlv.rounded_tax_amt_trx_curr)) unclassified_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_taxable_amt_trx_curr,'IGST',jtlv.rounded_taxable_amt_trx_curr)) taxable_value, max(jrc.reporting_code) hsn_sac_code from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav, jai_tax_det_factors jtdf, jai_reporting_codes jrc where jrav.entity_id(+)=jtlv.tax_type_id and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.det_factor_id=jtdf.det_factor_id(+) and jtdf.application_id(+)=200 and nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id(+) and jtlv.application_id=200 group by jtlv.trx_id ) il_tax Y US India Localization 7 &il_reg_columns ,x.gst_registration_no "GST Registration No", x.gst_pan_no "GST PAN No", x.gst_tan_no "GST TAN No", Y US India Localization 8 &il_where and ai.vendor_site_id=il_reg_site.party_site_id(+) and ai.vendor_id=il_reg_hdr.party_id(+) and ai.invoice_id=il_tax.trx_id(+) Y US India Localization 9 10 1=1 haouv.name=:p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU' and xroa.id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),xroa.id) and rownum=1),fnd_global.org_id) US Operating Unit Operating Unit. Leave null to report across all accessible Operating Units 10 20 1=1 pv.vendor_id=:p_vendor_id LOV Oracle AP_SRS_VENDOR_NAME select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد اسم المورد D Lieferantenname Lieferantenname E Nombre de Proveedor Nombre de Proveedor F Nom du fournisseur Nom du fournisseur I Nome fornitore Nome del fornitore JA 仕入先名 仕入先名 KO 공급자명 공급자명 PTB Nome do Fornecedor Nome do Fornecedor RU Имя поставщика Имя поставщика S Leverantör Leverantör TR Tedarikçi Adı Tedarikçi Adı US Supplier Name Vendor Name ZHS 供应商名称 供应商名称 11 30 1=1 pvs.vendor_site_code=:p_vendor_site LOV Oracle AP_SRS_APXINHIS_VENDOR_SITE select pvs.vendor_site_code id, pvs.vendor_site_code value, null description from po_vendor_sites pvs,po_vendors pv where pvs.vendor_id=pv.vendor_id and pv.vendor_id=:$flex$.ap_srs_vendor_name order by vendor_site_code AR موقع المورد موقع المورد D Lieferantenadresse Lieferantenadresse E Dirección del Proveedor Dirección del Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Site do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Vendor Site ZHS 供应商地点 供应商地点 12 40 1=1 rct1.creation_date>=:p_modify_from_date Date AR تاريخ تعديل الإيصال من تاريخ تعديل الإيصال من D Von Änderungsdatum Wareneingang Von Änderungsdatum Wareneingang E De Fecha de Modificación de Recepción De Fecha de Modificación de Recepción F Date de modification de réception - Du Date de modification de réception - Du I Data modifica ricezione - Da Data modifica ricezione - Da JA 受入修正日:自 受入修正日:自 KO 수금 수정 일자: 부터 수금 수정 일자: 부터 PTB Data Modific. Receita - De Data Modific. Receita - De RU Дата изменения поступления с Дата изменения поступления с S Ändra inbetalningsdatum från Ändra inbetalningsdatum från TR Alınan Ödeme Değişiklik Tarihi, İlk Alınan Ödeme Değişiklik Tarihi, İlk US Receipt Modify Date From Receipt Modify Date From ZHS 接收修改日期自 接收修改日期自 13 50 1=1 rct1.creation_date<:p_modify_to_date+1 Date last_day(:$flex$.receipt_modify_date_from) AR تاريخ تعديل الإيصال إلى تاريخ تعديل الإيصال إلى D Bis Änderungsdatum Wareneingang Bis Änderungsdatum Wareneingang E A Fecha de Modificación de Recepción A Fecha de Modificación de Recepción F Date de modification de réception - Au Date de modification de réception - Au I Data modifica incasso - A Data modifica incasso - A JA 受入修正日:至 受入修正日:至 KO 수금 수정 일자: 까지 수금 수정 일자: 까지 PTB Data Modific. Receita - Até Data Modific. Receita - Até RU Дата изменения поступления по Дата изменения поступления по S Ändra inbetalningsdatum till Ändra inbetalningsdatum till TR Alınan Ödeme Değişiklik Tarihi, Son Alınan Ödeme Değişiklik Tarihi, Son US Receipt Modify Date To Receipt Modify Date To ZHS 接收修改终止日期 接收修改终止日期 14 60 :p_approval_status LOV Oracle AP_SRS_APPROVAL_CODES select lookup_code id, displayed_field value, null description from ap_lookup_codes where(lookup_type like 'NLS TRANSLATION' and lookup_code in ('APPROVED','NEVER APPROVED','PAID','NEEDS REAPPROVAL')) or (lookup_type='INVOICE STATUS' and lookup_code='PAID') order by value,description AR موقف الفاتورة موقف الفاتورة D Rechnungsstatus Rechnungsstatus E Estado de Factura Estado de Factura F Statut de la facture Statut de la facture I Stato fattura Stato fattura JA 請求書ステータス 請求書ステータス KO 송장 상태 송장 상태 PTB Status da NFF Status da NFF RU Статус СФ Статус СФ S Fakturastatus Fakturastatus TR Fatura Statüsü Fatura Statüsü US Invoice Status Invoice Status ZHS 发票状态 发票状态