IGI CIS Resubmit: Monthly Returns View

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: IGI CIS Resubmit: Monthly Returns View Report
Short Name: IGIPMTHRVR
DB package:
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