ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0373869E053B46B63588994 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 Y IGI IGIPMTHRVR AR IGI إعادة التقديم لمخطط صناعة الإنشاءات في IGI: تقرير عرض الإقرارات الشهرية Application: الماليات الدولية للقطاع العام Source: إعادة التقديم لمخطط صناعة الإنشاءات في IGI: تقرير عرض الإقرارات الشهرية Short Name: IGIPMTHRVR DB package: D IGI CIS Erneut weiterleiten: Monatliche Steuererklärungen - Ansicht Application: Public Sector Financials International Source: IGI CIS Erneut weiterleiten: Monatliche Steuererklärungen - Ansicht Short Name: IGIPMTHRVR DB package: F IGI Resoumission CIS - Etat de consultation des déclarations mensuelles Application: Public Sector Financials International Source: IGI : Resoumission CIS - Etat de consultation des déclarations mensuelles Short Name: IGIPMTHRVR DB package: US IGI CIS Resubmit: Monthly Returns View Application: Public Sector Financials International Source: IGI CIS Resubmit: Monthly Returns View Report Short Name: IGIPMTHRVR DB package: ZHS IGI CIS 重新提交：月报税单查看报表 Application: Public Sector Financials International Source: IGI CIS 重新提交：月报税单查看报表 Short Name: IGIPMTHRVR DB package: BI Publisher :hdr :ven_id 1 10 :p_period_name LOV Oracle IGI_CIS_RE_WORK_PERIOD Y select period_name id, period_name value, null description from (select distinct period_name from igi_cis_mth_ret_hdr_h_all where status='WORKING') order by value,description Y AR اسم الفترة D Periodenbezeichnung F Nom de période US Period Name ZHS 期间名称