ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4A93869E053B46B63588994 select DECODE(TOLERANCE_TYPE , 'GOODS' , (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'GOODS' AND lookup_type = 'TOLERANCE TYPE'), (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'SERVICES' AND lookup_type = 'TOLERANCE TYPE') ) C_TOLERANCE_TYPE, TOLERANCE_ID, TOLERANCE_NAME, DESCRIPTION, PRICE_TOLERANCE, QUANTITY_TOLERANCE, LAST_UPDATE_DATE, LAST_UPDATED_BY, QTY_RECEIVED_TOLERANCE, TAX_TOLERANCE, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, MAX_QTY_ORD_TOLERANCE, MAX_QTY_REC_TOLERANCE, SHIP_AMT_TOLERANCE, RATE_AMT_TOLERANCE, TOTAL_AMT_TOLERANCE, TAX_TOL_AMT_RANGE, DECODE(TOLERANCE_TYPE , 'GOODS' , (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'QTY ORD' AND lookup_type = 'HOLD CODE'), (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'AMT ORD' AND lookup_type = 'HOLD CODE')) C_HOLD_QTY_ORD, DECODE(TOLERANCE_TYPE , 'GOODS' , (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX QTY ORD' AND lookup_type = 'HOLD CODE'), (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX AMT ORD' AND lookup_type = 'HOLD CODE')) C_HOLD_MAX_QTY_ORD, DECODE(TOLERANCE_TYPE , 'GOODS' , (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'QTY REC' AND lookup_type = 'HOLD CODE'), (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'AMT REC' AND lookup_type = 'HOLD CODE')) C_HOLD_QTY_REC, DECODE(TOLERANCE_TYPE , 'GOODS' , (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX QTY REC' AND lookup_type = 'HOLD CODE'), (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX AMT REC' AND lookup_type = 'HOLD CODE')) C_HOLD_MAX_QTY_REC, (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'PRICE' AND lookup_type = 'HOLD CODE') C_HOLD_PRICE, (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX RATE AMOUNT' AND lookup_type = 'HOLD CODE') C_HOLD_MAX_RATE_AMOUNT, (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX SHIP AMOUNT' AND lookup_type = 'HOLD CODE') C_HOLD_MAX_SHIP_AMOUNT, (SELECT displayed_field FROM ap_lookup_codes WHERE lookup_code = 'MAX TOTAL AMOUNT' AND lookup_type = 'HOLD CODE') C_HOLD_MAX_TOTAL_AMOUNT from AP_TOLERANCE_TEMPLATES order by TOLERANCE_TYPE Asc, TOLERANCE_NAME Asc Y SQLAP APXTOLRP_XML AR AP قائمة تجاوزات المدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: قائمة تجاوزات المدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXTOLRP_XML DB package: AP_APXTOLRP_XMLP_PKG D AP KR Toleranzen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: KR Toleranzen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXTOLRP_XML DB package: AP_APXTOLRP_XMLP_PKG F AP Etat Liste des tolérances de Payables- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Etat Liste des tolérances de Payables (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXTOLRP_XML DB package: AP_APXTOLRP_XMLP_PKG US AP Payables Tolerance Listing - draft Application: Payables Source: Payables Tolerance Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXTOLRP_XML DB package: AP_APXTOLRP_XMLP_PKG ZHS AP 应付款允差列表- 不支持：已保留供将来使用 Application: 应付帐款 Source: 应付款允差列表 (XML) - 不支持：已保留供将来使用 Short Name: APXTOLRP_XML DB package: AP_APXTOLRP_XMLP_PKG BI Publisher :applications_template_report :c_company_name_header :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :p_conc_request_id :p_debug_switch :p_trace_switch