ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F46C3869E053B46B63588994Y SELECT HOU.name ou_name ,POV.vendor_name supplier ,AI.invoice_num pre_inv_num ,AID.invoice_line_number||'/'||AID.distribution_line_number line_num ,AI.payment_status_flag paid_status ,sum(AID.amount) amount ,DECODE ( SUM ( AID.prepay_amount_remaining ), NULL, SUM ( AID.amount ) , SUM ( AID.prepay_amount_remaining )) rem_amt ,sum(AID2.amount)*-1 closed_amt ,AI2.invoice_num std_inv_num ,AP_PREPAY_TRAK_REP_TURK_PKG.date_close(AI.invoice_id,AID.invoice_line_number ,sum(AID.prepay_amount_remaining)) date_closed FROM ap_invoices AI ,ap_invoices AI2 ,ap_invoice_lines AIL ,ap_invoice_distributions AID ,ap_invoice_distributions AID2 ,ap_lookup_codes ALC ,po_vendors POV ,hr_operating_units HOU WHERE AI.invoice_id = AIL.invoice_id AND AIL.invoice_id = AID.invoice_id AND HOU.organization_id = AI.org_id &c_lex_prepay_status AND ALC.lookup_type='PREPAY STATUS' AND ALC.LOOKUP_CODE = ap_invoices_pkg.get_approval_status ( ai.invoice_id , ai.invoice_amount , ai.payment_status_flag , ai.invoice_type_lookup_code ) AND AIL.line_number = AID.invoice_line_number AND AI.vendor_id = POV.vendor_id AND AID.invoice_distribution_id = AID2.prepay_distribution_id AND AID2.invoice_id = AI2.invoice_id AND AI.invoice_type_lookup_code = 'PREPAYMENT' AND AID.line_type_lookup_code='ITEM' AND NVL(AID2.REVERSAL_FLAG,'N')= 'N' -- bug 12763714 &c_lex_invoice_date &c_lex_supplier &c_lex_currency &c_lex_vendor_type &gc_org_where GROUP BY HOU.name ,POV.vendor_name ,AI.invoice_num ,AID.invoice_line_number||'/'||AID.distribution_line_number ,AI2.invoice_num ,AI.payment_status_flag ,AID.invoice_line_number ,AI.invoice_id UNION ALL SELECT HOU.name ou_name ,POV.vendor_name supplier ,AI.invoice_num pre_inv_num ,AID.invoice_line_number||'/'||aid.distribution_line_number line_num ,AI.payment_status_flag paid_status ,sum(AID.amount) amount ,DECODE ( SUM ( AID.prepay_amount_remaining ) , NULL, SUM ( AID.amount ) , SUM ( AID.prepay_amount_remaining ) ) rem_amt ,NULL closed_amt ,NULL std_inv_num ,AP_PREPAY_TRAK_REP_TURK_PKG.Date_close(AI.invoice_id,AID.invoice_line_number ,sum(AID.prepay_amount_remaining)) date_closed FROM ap_invoices AI ,ap_invoice_lines AIL ,ap_invoice_distributions AID ,po_vendors POV ,ap_lookup_codes ALC ,hr_operating_units HOU WHERE AI.invoice_id = AIL.invoice_id AND AIL.invoice_id = AID.invoice_id AND HOU.organization_id = AI.org_id AND AIL.line_number = AID.invoice_line_number &c_lex_prepay_status AND ALC.lookup_type='PREPAY STATUS' AND ALC.LOOKUP_CODE = ap_invoices_pkg.get_approval_status ( ai.invoice_id , ai.invoice_amount , ai.payment_status_flag , ai.invoice_type_lookup_code ) AND AI.vendor_id = POV.vendor_id AND AID.line_type_lookup_code='ITEM' &c_lex_invoice_date &c_lex_supplier &c_lex_currency &c_lex_vendor_type &gc_org_where AND AID.invoice_distribution_id NOT IN (SELECT AID.prepay_distribution_id FROM ap_invoice_distributions AID WHERE AID.prepay_distribution_id IS NOT NULL AND NVL(AID.REVERSAL_FLAG,'N')='N' -- bug 12763714 ) AND AI.invoice_type_lookup_code = 'PREPAYMENT' GROUP BY HOU.name ,POV.vendor_name ,AI.invoice_num ,AID.invoice_line_number||'/'||AID.distribution_line_number ,AI.payment_status_flag ,AID.invoice_line_number ,AI.invoice_id ORDER BY 1,2,3,9 SQLAP APPPTR AR AP حساب المدفوعات - تقرير تتبع الدفعات المقدمة - تركيا Application: المدفوعات Source: حساب المدفوعات - تقرير تتبع الدفعات المقدمة - تركيا Short Name: APPPTR DB package: AP_PREPAY_TRAK_REP_TURK_PKG D AP KR Erfasste Vorauszahlungen - Türkei Application: Kreditoren Source: KR Erfasste Vorauszahlungen - Türkei Short Name: APPPTR DB package: AP_PREPAY_TRAK_REP_TURK_PKG F AP - Etat de suivi des acomptes - Turquie Application: Payables Source: AP - Etat de suivi des acomptes - Turquie Short Name: APPPTR DB package: AP_PREPAY_TRAK_REP_TURK_PKG US AP Prepayment Tracking Report - Turkey Application: Payables Source: AP Prepayment Tracking Report - Turkey Short Name: APPPTR DB package: AP_PREPAY_TRAK_REP_TURK_PKG ZHS AP 预付款跟踪报表 - 土耳其 Application: 应付帐款 Source: AP 预付款跟踪报表 - 土耳其 Short Name: APPPTR DB package: AP_PREPAY_TRAK_REP_TURK_PKG BI Publisher &c_lex_currency &c_lex_invoice_date &c_lex_prepay_status &c_lex_supplier &c_lex_vendor_type &gc_org_where :c_lex_currency :c_lex_invoice_date :c_lex_prepay_status :c_lex_supplier :c_lex_vendor_type :gc_org_where :gd_date_from :gd_date_to :p_currency :p_invoice_from :p_invoice_to :p_org_id :p_prepay_status :p_supplier_from :p_supplier_to :p_vendor_type 1 10 :p_org_id LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description Y AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 2 20 :p_prepay_status LOV Oracle AP_SRS_PREPAY_STATUS Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='PREPAY STATUS' order by value,description AR موقف الدفعات المقدمة D Vorauszahlungsstatus F Statut de l'acompte US Prepayment Status ZHS 预付款状态 3 30 :p_invoice_from Date select to_date(to_char(sysdate,'DD-MON-YYYY'),'DD-MON-YYYY') from dual Y AR من تاريخ الدفعة المقدمة D Von Vorauszahlungsdatum F Date de l'acompte - Du US Prepayment Date From ZHS 预付款日期自 4 40 :p_invoice_to Date select to_date(to_char(sysdate,'DD-MON-YYYY'),'DD-MON-YYYY') from dual Y AR إلى تاريخ الدفعة المقدمة D Bis Vorauszahlungsdatum F Date de l'acompte - Au US Prepayment Date To ZHS 预付款日期至 5 50 :p_supplier_from LOV Oracle AP_SRS_VENDOR_NAME_OU Y select party_name id, party_name value, null description from hz_parties where party_id in (select party_id from hz_party_sites where party_site_id in (select party_site_id from po_vendor_sites_all where org_id=:$flex$.fnd_mo_ou)) order by value,description AR مورد من D Von Lieferant F Fournisseur - De US Supplier From ZHS 供应商自 6 60 :p_supplier_to LOV Oracle AP_SRS_VENDOR_NAME_OU Y select party_name id, party_name value, null description from hz_parties where party_id in (select party_id from hz_party_sites where party_site_id in (select party_site_id from po_vendor_sites_all where org_id=:$flex$.fnd_mo_ou)) order by value,description AR مورد إلى D Bis Lieferant F Fournisseur - A US Supplier To ZHS 供应商至 7 70 :p_currency LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code Y AR العملة D Währung F Devise US Currency ZHS 币种 8 80 :p_vendor_type LOV Oracle AP_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='VENDOR TYPE' order by value,description AR نوع المورد D Lieferantenart F Type de fournisseur US Vendor Type ZHS 供应商类型