AP Invoice Approval Status

Description

Categories
Enginatics, R12 only
Application
Payables
Source
Invoice Approval Status
Short Name
APXAPRST
Repository
GitHub
Imported from Concurrent Program

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, 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.

The Rejected By column shows the user who recorded a rejection: the user who rejected the invoice, or, for an invoice rejected automatically because the approval request timed out, the user that submits the Workflow Background Process (typically SYSADMIN).

SQL 354 lines

Parameters 9

ParameterTypeList of values SQL
Reporting LevelLOV Oracle
Reporting ContextLOV
decode(:p_reporting_level,1000,gl.name,3000,mo_global.get_ou_name(aia.org_id),null)=:p_reporting_entity
Sort ByLOV
Trading PartnerLOV Oracle
aia.party_id=:p_party_id
Supplier SiteLOV Oracle
aia.vendor_site_id=:p_vendor_site_id
ApproverLOV
exists 
(select 
 aiaha.invoice_id 
 from 
 ap_inv_aprvl_hist_all aiaha 
 where 
 aiaha.invoice_id = aia.invoice_id and 
 (aiaha.approver_id = :p_approver or 
  (aiaha.approver_id is null and
   aiaha.approver_name in (select hecv.full_name from hr_employees_current_v hecv where hecv.employee_id = :p_approver) 
  )
 )
)
Invoice Date FromDate
aia.invoice_date>=:p_invoice_date_from
Invoice Date ToDate
aia.invoice_date<:p_invoice_date_to+1
Approval StatusLOV