AP Invoice Audit Listing
Description
- Categories
- Enginatics, R12 only
- Application
- Payables
- Source
- Invoice Audit Listing
- Short Name
- APXINLST
- Repository
- GitHub
Imported Oracle standard 'Invoice Audit Listing' report
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.
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.
SQL 34 lines
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) |
Parameters 4
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Operating Unit | LOV |
| |
| Minimum Invoice Amount | Number |
| |
| Begin Invoice Date | Date |
| |
| Invoice Type | LOV |
|