IGI CIS Resubmit: Monthly Returns View

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Financials International
Source: IGI CIS Resubmit: Monthly Returns View Report
Short Name: IGIPMTHRVR
DB package:
Run IGI CIS Resubmit: Monthly Returns View and other Oracle EBS reports with Blitz Report™ on our demo environment
select pay.version_num ver, (select ai.invoice_num from ap_invoices_all ai where org_id = FND_PROFILE.VALUE('ORG_ID') and ai.invoice_id = pay.invoice_id) inv_id,
sum((nvl(pay.amount,0)  + nvl(pay.total_deductions,0))) totpayp,
sum(nvl(pay.material_cost,0)) mat,
sum(nvl(pay.labour_cost,0)) txamtp,
sum(nvl(pay.total_deductions,0)) TOT1
from IGI_CIS_MTH_RET_PAY_H_ALL pay
 where pay.header_id=:hdr and pay.vendor_id=:ven_id
group by pay.version_num, pay.invoice_id
Parameter Name SQL text Validation
Period Name 
 
 LOV Oracle
Download
Related Blitz Reports
IGI CIS2007 Subcontractor Statement of Payment and Deductions IGI CIS Resubmit: Monthly Returns History IGI CIS2007 Registered Supplier Listing IGI CIS2007 Subcontractor Verification Status AP Payment Schedule Report- Not Supported: Reserved For Future Use AP Supplier Closing Balance GL Account Analysis 11g GL Account Analysis GL Account Analysis (Distributions) 11g
Blitz Report™

Blitz Report™ provides multiple benefits: