ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0363869E053B46B63588994 select header_id hdr1,vendor_name ven,vendor_id ven_id, version_num vnum, unique_tax_reference_num utrn, sum(NVL(total_payments,0)) pay, sum(NVL(material_cost,0)) mat, sum(NVL(cis_tax,0)) ded, sum(NVL(labour_cost,0)) TX from IGI_CIS_MTH_RET_LINES_H where header_id in (select header_id from igi_cis_mth_ret_hdr_h where status='FINAL' and period_name=:P_PERIOD_NAME and to_char(version_num) like NVL(to_char(:P_VER_NUM),'%')) group by header_id,vendor_name,vendor_id,version_num,unique_tax_reference_num Y IGI IGIPMTHRAR AR IGI إعادة التقديم لمخطط صناعة الإنشاءات في IGI: تقرير تاريخ الإقرارات الشهرية Application: الماليات الدولية للقطاع العام Source: إعادة التقديم لمخطط صناعة الإنشاءات في IGI: تقرير تاريخ الإقرارات الشهرية Short Name: IGIPMTHRAR DB package: D IGI CIS Erneut weiterleiten: Monatliche Steuererklärungen - Historie Application: Public Sector Financials International Source: IGI CIS Erneut weiterleiten: Monatliche Steuererklärungen - Historie Short Name: IGIPMTHRAR DB package: F IGI Resoumission CIS - Etat d'historique des déclarations mensuelles Application: Public Sector Financials International Source: IGI : Resoumission CIS - Etat d'historique des déclarations mensuelles Short Name: IGIPMTHRAR DB package: US IGI CIS Resubmit: Monthly Returns History Application: Public Sector Financials International Source: IGI CIS Resubmit: Monthly Returns History Report Short Name: IGIPMTHRAR DB package: ZHS IGI CIS 重新提交：月报税单历史记录报表 Application: Public Sector Financials International Source: IGI CIS 重新提交：月报税单历史记录报表 Short Name: IGIPMTHRAR DB package: BI Publisher :p_period_name :p_ver_num 1 10 :p_period_name LOV Oracle IGI_CIS_RESUBMIT_PERIOD Y select period_name id, period_name value, null description from (select period_name,period_year,period_num from ap_other_periods aop where aop.period_type=fnd_profile.value('IGI_CIS2007_CALENDAR') and exists (select 1 from igi_cis_mth_ret_hdr_h_all ich where ich.period_name=aop.period_name)) order by period_year,period_num desc Y AR اسم الفترة D Periodenbezeichnung F Nom de période US Period Name ZHS 期间名称 2 20 :p_ver_num LOV Oracle IGI_CIS_RE_VER_NUM Y select ver_num id, ver_num value, null description from (select distinct nvl(version_num,1) ver_num,period_name from igi_cis_mth_ret_hdr_h_all) where period_name=:$flex$.igi_cis_resubmit_period order by value,description AR رقم النسخة D Versionsnummer F Numéro de version US Version Number ZHS 版本号 :$flex$.igi_cis_resubmit_period Period Name Version Number