ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4683869E053B46B63588994Y SELECT APC.bank_account_name bank_account_name ,APC.check_number ||'/'||&GC_ATTRIBUTE_COL check_number ,APC.check_date check_date ,APC.future_pay_due_date due_date ,APC.amount amount ,APC.vendor_name vendor_name ,APLC.displayed_field status ,APC.cleared_date cleared_date ,APC.cleared_amount cleared_amount ,SUM(APC.amount) over () general_total ,SYSDATE+ROUND((SUM((APC.future_pay_due_date-SYSDATE) *APC.amount) over ())/(SUM(APC.amount) over ()) ) avg_mat_date FROM ap_checks APC ,ap_lookup_codes APLC ,ap_suppliers APS WHERE &GC_WHERE AND APC.future_pay_due_date IS NOT NULL AND APC.payment_method_code = 'CHECK' AND APLC.lookup_type='CHECK STATE' AND APC.status_lookup_code = APLC.lookup_code AND APC.vendor_id= APS.vendor_id(+) ORDER BY APC.future_pay_due_date SQLAP APCHECKPAYSUPRPT AR AP حساب المدفوعات - مدفوعات الشيك إلى الموردين Application: المدفوعات Source: حساب المدفوعات - مدفوعات الشيك إلى الموردين Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG D AP KR Scheckzahlungen an Lieferanten Application: Kreditoren Source: KR Scheckzahlungen an Lieferanten Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG F AP Règlements par chèque AP aux fournisseurs Application: Payables Source: Règlements par chèque AP aux fournisseurs Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG US AP Check Payments to Suppliers Application: Payables Source: AP Check Payments to Suppliers Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG ZHS AP 用支票向供应商付款 Application: 应付帐款 Source: AP 用支票向供应商付款 Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG BI Publisher &gc_attribute_col &gc_where :gc_attribute :gc_attribute_col :gc_where :operating_unit :p_check_date_from :p_check_date_to :p_check_due_date_from :p_check_due_date_to :p_check_stat :p_currency :p_vndr_number_from :p_vndr_number_to 1 10 :p_vndr_number_from LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 AR رقم المورد من D Von Lieferantennummer F Numéro fournisseur - De US Vendor Number From ZHS 供应商编号自 2 20 :p_vndr_number_to LOV Oracle AP_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, null description from po_vendors order by segment1 AR رقم المورد إلى D Bis Lieferantennummer F Numéro fournisseur - A US Vendor Number To ZHS 供应商编号至 3 30 :p_check_date_from Date select sysdate from dual AR من تاريخ الشيك D Von Scheckdatum F Date du chèque - Du US From Check Date ZHS 自支票日期 4 40 :p_check_date_to Date select sysdate from dual AR إلى تاريخ الشيك D Bis Scheckdatum F Date du chèque - Au US To Check Date ZHS 至支票日期 5 50 :p_check_due_date_from Date select sysdate from dual AR من تاريخ استحقاق الشيك D Von Scheckfälligkeit F Date d'échéance du chèque - Du US From Check Due Date ZHS 自支票到期日 6 60 :p_check_due_date_to Date select sysdate from dual AR إلى تاريخ استحقاق الشيك D Bis Scheckfälligkeit F Date d'échéance du chèque - Au US To Check Due Date 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 SELECT currency_code FROM hr_organization_information O1, hr_organization_information O2, gl_ledgers_public_v GL WHERE O1.organization_id = O2.organization_id AND O1.organization_id = MO_GLOBAL.get_current_org_id AND O1.org_information_context = 'CLASS' AND O2.org_information_context = 'Operating Unit Information' AND O1.org_information1 = 'OPERATING_UNIT' AND O1.org_information2 = 'Y' AND O2.org_information3 = GL.ledger_id AND GL.ledger_category_code='PRIMARY' AR عملة الشيك D Scheckwährung F Devise du chèque US Check Currency ZHS 支票币种 8 80 :p_check_stat LOV Oracle AP_SRS_PAYMENT_STATUS Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='CHECK STATE' order by value,description AR موقف الشيك D Scheckstatus F Statut du chèque US Check Status ZHS 支票状态