ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F48E3869E053B46B63588994Y SELECT i.vendor_id C_vendor_id, i.invoice_currency_code||i.payment_currency_code c_inv_pmt_curr, i.invoice_currency_code C_invoice_currency_code, i.payment_currency_code C_payment_currency_code, i.invoice_type_lookup_code C_invoice_type_lookup_code, DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', 1, 2) C_sort_type, l1.displayed_field C_invoice_type_dsp, i.invoice_id C_invoice_id, i.invoice_num C_invoice_num, NVL(to_char(i.doc_sequence_value), i.voucher_num) C_inv_voucher_num, --11864080: Added call to FND_DATE API fnd_date.date_to_chardate(dateval=>i.invoice_date,calendar_aware=> :C_CALENDAR_AWARE_ALT) C_invoice_date, DECODE( i.invoice_type_lookup_code, 'PREPAYMENT', DECODE(i.earliest_settlement_date, '','PERMANENT', fnd_date.date_to_chardate(dateval=> i.earliest_settlement_date, calendar_aware => :C_CALENDAR_AWARE_ALT )),/*Bug11774150*/ '') C_earliest_settlement_date, i.invoice_amount C_invoice_amount, i.description C_description, i.payment_status_flag C_payment_status_flag, nvl( AP_INVOICES_UTILITY_PKG.get_amount_withheld( i.invoice_id ), 0) C_withheld_amount, DECODE( i.invoice_type_lookup_code, 'PREPAYMENT', AP_PREPAY_UTILS_PKG.get_prepay_amount_remaining( i.invoice_id ), sum( nvl(aps.amount_remaining,0) ) ) C_amount_remaining, i.payment_cross_rate C_payment_cross_rate, AP_APXINPSR_XMLP_PKG.c_amount_for_sumformula(i.invoice_type_lookup_code, DECODE ( i.invoice_type_lookup_code , 'PREPAYMENT' , AP_PREPAY_UTILS_PKG.get_prepay_amount_remaining ( i.invoice_id ) , sum ( nvl ( aps.amount_remaining , 0 ) ) ), i.payment_status_flag, DECODE ( i.invoice_type_lookup_code , 'PREPAYMENT' , DECODE ( i.earliest_settlement_date , '' , 'PERMANENT' , fnd_date.date_to_chardate (dateval => i.earliest_settlement_date, calendar_aware => :C_CALENDAR_AWARE_ALT ) ) , '' ), i.payment_cross_rate, i.invoice_currency_code) C_amount_for_sum,/*Bug11774150*/ AP_APXINPSR_XMLP_PKG.c_amount_remaining_convertform(i.payment_cross_rate, DECODE ( i.invoice_type_lookup_code , 'PREPAYMENT' , AP_PREPAY_UTILS_PKG.get_prepay_amount_remaining ( i.invoice_id ) , sum ( nvl ( aps.amount_remaining , 0 ) ) ), i.invoice_currency_code, i.invoice_type_lookup_code) C_amount_remaining_convert, AP_APXINPSR_XMLP_PKG.c_amount_remaining_dspformula(i.invoice_type_lookup_code, i.payment_status_flag, :C_amount_remaining_trans) C_amount_remaining_dsp FROM ap_lookup_codes l1, ap_invoices i, ap_payment_schedules_all aps WHERE i.cancelled_date IS NULL AND aps.invoice_id = i.invoice_id AND l1.lookup_type = 'INVOICE TYPE' AND l1.lookup_code = i.invoice_type_lookup_code &C_invoice_dynamic_SQL and i.vendor_id=:C_vendor_id1 GROUP BY i.vendor_id, i.invoice_currency_code||i.payment_currency_code, i.invoice_currency_code, i.payment_currency_code, i.invoice_type_lookup_code, DECODE(i.invoice_type_lookup_code, 'PREPAYMENT', 1, 2), l1.displayed_field, i.invoice_id, i.invoice_num, nvl(to_char(i.doc_sequence_value),i.voucher_num), i.invoice_date, DECODE( i.invoice_type_lookup_code, 'PREPAYMENT', DECODE(i.earliest_settlement_date, '','PERMANENT', fnd_date.date_to_chardate(dateval => i.earliest_settlement_date,calendar_aware => :C_CALENDAR_AWARE_ALT )),''),/*Bug11774150*/ i.invoice_amount, i.description, i.payment_status_flag, nvl( AP_INVOICES_UTILITY_PKG.get_amount_withheld( i.invoice_id ), 0), i.payment_cross_rate --ORDER BY 5,i.invoice_date, i.invoice_num ORDER BY 3 ASC, 4 ASC, 2 ASC, 1 ASC, 6 ASC, 5, i.invoice_date, i.invoice_num SQLAP APXINPSR_XML AR AP تقرير موقف الدفعات المقدمة (بتنسيق XML) Application: المدفوعات Source: تقرير موقف الدفعات المقدمة (بتنسيق XML) Short Name: APXINPSR_XML DB package: AP_APXINPSR_XMLP_PKG D AP Vorauszahlungen - Status Application: Kreditoren Source: Vorauszahlungen - Status (XML) Short Name: APXINPSR_XML DB package: AP_APXINPSR_XMLP_PKG F AP Etat des acomptes rapprochés Application: Payables Source: Etat des acomptes rapprochés (XML) Short Name: APXINPSR_XML DB package: AP_APXINPSR_XMLP_PKG US AP Prepayments Status Application: Payables Source: Prepayments Status Report (XML) Short Name: APXINPSR_XML DB package: AP_APXINPSR_XMLP_PKG ZHS AP 预付款状态报表 Application: 应付帐款 Source: 预付款状态报表 (XML) Short Name: APXINPSR_XML DB package: AP_APXINPSR_XMLP_PKG BI Publisher &c_invoice_dynamic_sql :applications_template_report :c_amount_remaining_trans :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_calendar_aware_alt :c_chart_of_accounts_id :c_company_name_header :c_header_include_credit :c_header_include_invoice :c_header_prepayment_type :c_header_show_prepay_dist :c_header_vendor_name :c_header_vendor_type :c_invoice_dynamic_sql :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_unpaid :c_nls_void :c_nls_yes :c_report_start_date :c_vendor_dynamic_sql :c_vendor_id1 :operating_unit :p_chart_of_accounts_id :p_conc_request_id :p_debug_switch :p_flexdata :p_from_date :p_include_credit :p_include_invoice :p_min_precision :p_prepayment_line_flag :p_prepayment_type :p_set_of_books_id :p_to_date :p_trace_switch :p_vendor_id :p_vendor_type_lookup_code :sort_by_alternate 1 10 :p_include_invoice LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تضمين الفواتير D Mit Rechnungen F Inclure les factures US Include Invoices ZHS 包括发票 2 20 :p_include_credit LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تضمين إشعارات دائنة/مدينة D Mit Gutschriften/Belastungen F Inclure notes débit/avoirs US Include Credit/Debit Memos ZHS 包括贷项/借项通知单 3 30 :p_vendor_type_lookup_code 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 Supplier Type ZHS 供应商类型 4 40 :p_vendor_id LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR اسم المورد D Lieferantenname F Nom du fournisseur US Supplier Name ZHS 供应商名称 5 50 :p_from_date Date AR من تاريخ D Von Datum F Date de début US From Date ZHS 自日期 6 60 :p_to_date Date AR إلى تاريخ D Bis Datum F Date de fin US To Date ZHS 至日期 7 70 :p_prepayment_type LOV Oracle AP_SRS_PREPAY_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='PREPAY TYPES' order by value,description select Displayed_field from ap_lookup_codes where lookup_type = 'PREPAY TYPES' and lookup_code = 'TEMPORARY' Y AR نوع الدفعة المقدمة D Vorauszahlungsart F Type d'acompte US Prepayment Type ZHS 预付款类型 8 80 :p_prepayment_line_flag LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code = 'N' Y AR إظهار سطور الدفعات المقدمة D Vorauszahlungspositionen anzeigen F Afficher les lignes d'acompte US Show Prepayment Lines ZHS 显示预付款行