ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 &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 India GST columns, displayed only when India Localization is installed. 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 Imported Oracle standard 'Invoice Audit Listing' report Application: Payables Source: Invoice Audit Listing Short Name: APXINLST 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, CESS Amount, Custom Amount, Unclassified Tax Amount, Non-Recoverable GST, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State. ZHS AP 发票审核列表 Imported from Concurrent Program Application: 应付帐款 Source: 发票审核列表 Short Name: APXINLST DB package: Enginatics 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_columns_amt il_tax.cgst_amount "CGST Amount", il_tax.sgst_amount "SGST Amount", il_tax.igst_amount "IGST Amount", il_tax.cess_amount "CESS Amount", il_tax.custom_amount "Custom Amount", il_tax.unclassified_amount "Unclassified Tax Amount", il_tax.non_recoverable_gst "Non-Recoverable GST", il_tax.taxable_value "Taxable Value", il_tax.hsn_sac_code "HSN SAC Code", Y US India Localization 3 &il_columns_rate il_tax.cgst_tax_rate "CGST Rate", il_tax.sgst_tax_rate "SGST Rate", il_tax.igst_tax_rate "IGST Rate", il_tax.cess_tax_rate "CESS Rate", Y US India Localization 4 &il_columns_rec il_tax.cgst_rec_amount "CGST Recoverable", il_tax.cgst_nrec_amount "CGST Non-Recoverable", il_tax.sgst_rec_amount "SGST Recoverable", il_tax.sgst_nrec_amount "SGST Non-Recoverable", il_tax.igst_rec_amount "IGST Recoverable", il_tax.igst_nrec_amount "IGST Non-Recoverable", Y US India Localization 5 &il_columns_tp xxen_util.meaning(il_tax.reverse_charge_flag,'YES_NO',0) "Reverse Charge Flag", (select max(jtdf.ship_to_state) from jai_tax_det_factors jtdf where jtdf.trx_id=aia.invoice_id and jtdf.application_id=200) "Place of Supply", (select max(jtdf.ship_from_state) from jai_tax_det_factors jtdf where jtdf.trx_id=aia.invoice_id and jtdf.application_id=200) "Ship From State" 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, 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, 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, sum(case when jr.regime_type='T' then jtlv.nrec_tax_amt_trx_curr end) non_recoverable_gst, max(jtlv.self_assessed_flag) reverse_charge_flag, 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, jai_tax_types jtt, jai_regimes jr where jtlv.tax_type_id=jrav.entity_id(+) and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.tax_type_id=jtt.tax_type_id(+) and jtt.regime_id=jr.regime_id(+) 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 ,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 8 &il_where and aia.vendor_site_id=il_reg_site.party_site_id(+) and aia.vendor_id=il_reg_hdr.party_id(+) and aia.invoice_id=il_tax.trx_id(+) Y US India Localization 9 10 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 10 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 最小发票额 最小发票额 11 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 发票起始日期 起始发票日期 12 40 1=1 aia.invoice_type_lookup_code=xxen_util.lookup_code(:invoice_type,'INVOICE TYPE',200) LOV AP Invoice Type B20C1D394FC36EDDE0530100007F5621 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