IGI CIS Resubmit: Monthly Returns View
Description
- Categories
- BI Publisher
- Application
- Public Sector Financials International
- Source
- IGI CIS Resubmit: Monthly Returns View Report
- Short Name
- IGIPMTHRVR
DB package:
SQL 9 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Period Name | LOV Oracle |