ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4724651A9E05362FB09050512 SELECT AC.bank_account_name C_BANK_ACCOUNT_NAME, ALC.displayed_field C_PMT_METHOD, AC.currency_code C_PMT_CURRENCY, AC.state C_STATE, AC.check_date C_PMT_DATE, AC.check_number C_CHECK_NUMBER, AC.amount C_PMT_AMOUNT, ALC1.displayed_field C_VNDR_TYPE, AC.vendor_name C_VNDR_NAME, AP_VENDOR_SITES_PKG.FORMAT_ADDRESS(AC.country,AC.address_line1, AC.address_line2, AC.address_line3, AC.address_line4, AC.city, AC.county, AC.state, AC.province, AC.zip, NULL) C_PMT_ADDRESS, asp1.base_currency_code BASE_CURRENCY, FC.PRECISION PRECISION, &C_SELECT_LE C_Legal_Entity, &C_SELECT_OU C_Operating_Unit FROM ap_checks_all AC, po_vendors POV, ap_lookup_codes ALC, po_lookup_codes ALC1, ap_system_parameters_all ASP1, fnd_currencies FC, &C_ORG_FROM_TABLES WHERE AC.vendor_id = POV.vendor_id AND nvl(AC.org_id,-99) = nvl(asp1.org_id,-99) AND ALC.lookup_code = AC.payment_method_lookup_code AND ALC.lookup_type = 'PAYMENT METHOD' AND ALC1.lookup_code = POV.vendor_type_lookup_code AND ALC1.lookup_type = 'VENDOR TYPE' AND (((:P_BANK_ACCOUNT_ID is not NULL) AND (AC.bank_account_id = :P_BANK_ACCOUNT_ID)) OR (:P_BANK_ACCOUNT_ID is NULL)) AND (((:P_PMT_METHOD is not NULL) AND (AC.payment_method_lookup_code = :P_PMT_METHOD)) OR (:P_PMT_METHOD is NULL)) AND (((:P_VNDR_TYPE is not NULL) AND (POV.vendor_type_lookup_code = :P_VNDR_TYPE)) OR (:P_VNDR_TYPE is NULL)) AND (((:P_STATE is not NULL) AND (AC.state = :P_STATE)) OR (:P_STATE is NULL)) AND (((:p_from_check_date is not null) AND (:p_to_check_date is not null) AND (AC.check_date BETWEEN :p_From_Check_Date AND :p_To_Check_Date)) OR ((:p_from_check_date is null) and (:p_to_check_date is not null) and (AC.check_date <= :p_to_check_date))) AND AC.status_lookup_code IN ('ISSUED', 'NEGOTIABLE', 'STOP INITIATED') AND FC.currency_code = asp1.base_currency_code &C_MULTI_ORG_WHERE &P_ORG_WHERE_AC &P_ORG_WHERE_ASP ORDER BY C_OPERATING_UNIT, C_BANK_ACCOUNT_NAME, C_PMT_METHOD, C_PMT_CURRENCY, C_STATE, C_VNDR_NAME, C_PMT_DATE Y SQLAP APXUCPRP_XML AR AP تقرير خاصية عدم المطالبة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير خاصية عدم المطالبة Application: المدفوعات Source: تقرير خاصية عدم المطالبة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG D AP Herrenloses Eigentum- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Herrenloses Eigentum Application: Kreditoren Source: Herrenloses Eigentum (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG E AP Informe Propiedad No Reclamada: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de propiedad no reclamada Application: Payables Source: Informe Propiedad No Reclamada (XML): No Admitido, Reservado para Uso Futuro Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG F AP Etat de propriété non réclamée- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat de propriété non réclamée Application: Payables Source: Etat de propriété non réclamée (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG I AP Rapporto Proprietà non richiesta- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Proprietà non richiesta Application: Payables Source: Rapporto Proprietà non richiesta (XML) - non supportato: riservato per usi futuri Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG JA AP 未請求資産レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 未請求資産レポート Application: Payables Source: 未請求資産レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG KO AP 미청구 재산 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 청구되지 않은 재산 보고서 Application: Payables Source: 미청구 재산 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG PTB AP Relatório de Propriedade Não Reclamada- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Propriedade Não-reivindicada Application: Payables Source: Relatório de Propriedade Não Reclamada (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG RU AP Отчет о невостребованной собственности- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о невостребованной собственности Application: Кредиторы Source: Отчет о невостребованной собственности (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG S AP Förverkad egendom - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Förverkad egendom - rapport Application: Payables Source: Förverkad egendom - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG TR AP Talep Edilmemiş Mülkiyet Report- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Talep Edilmemiş Mülkiyet Raporu Application: Borçlar Muhasebesi Source: Talep Edilmemiş Mülkiyet Report (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG US AP Unclaimed Property Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Unclaimed Property Report Application: Payables Source: Unclaimed Property Report (XML) - Not Supported: Reserved For Future Use Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG ZHS AP 未申请的财产报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 未申请的财产报表 Application: 应付帐款 Source: 未申请的财产报表 (XML) - 不支持：已保留供将来使用 Short Name: APXUCPRP_XML DB package: AP_APXUCPRP_XMLP_PKG BI Publisher &c_multi_org_where &c_org_from_tables &c_select_le &c_select_ou &p_org_where_ac &p_org_where_asp :applications_template_report :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_ledger_partial_ou :c_multi_org_where :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_org_from_tables :c_report_start_date :c_select_le :c_select_ou :cp_bank_account_name :cp_payment_method :f_ledger_partial_ou :p_bank_account_id :p_conc_request_id :p_debug_switch :p_entity_name :p_from_check_date :p_from_check_date_v :p_level_name :p_min_precision :p_org_where_ac :p_org_where_asp :p_pmt_method :p_reporting_entity_id :p_reporting_level :p_set_of_books_id :p_state :p_to_check_date :p_to_check_date_v :p_trace_switch :p_vndr_type 1 -30 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y AR معرف دفتر الأستاذ D Buchkennung E Id Libro Mayor F ID livre I Id libro contabile JA 元帳ID KO 원장 ID PTB Id do Razão RU Идентификатор книги S Huvudboks-id TR Defter No US Ledger Id ZHS 分类帐标识 2 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'FND_MO_REPORTING_LEVEL' AND rownum=1 Y AR مستوى إعداد التقرير D Auswertungsebene E Nivel de Informe F Niveau de reporting I Livello dichiarazione JA レポート・レベル KO 보고 레벨 PTB Nível do Relatório RU Уровень отчетности S Rapporteringsnivå TR Raporlama Düzeyi US Reporting Level ZHS 报告层 3 20 :p_reporting_entity_id LOV Oracle FND_MO_REPORTING_ENTITY Y select entity_id id, entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level order by value,description SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.reporting_level and rownum=1 Y AR سياق إعداد التقرير D Auswertungskontext E Contexto del Informe F Contexte de reporting I Contesto dichiarazione JA レポート・コンテキスト KO 보고 컨텍스트 PTB Contexto do Relatório RU Контекст отчетности S Rapporteringssammanhang TR Raporlama İçeriği US Reporting Context ZHS 报告上下文 4 30 :p_bank_account_id LOV Oracle AP_SRS_BANK_ACCT_NAME_NUM_UCPRP Y select bank_account_id id, bank_account_name||' - '||bank_account_num value, null description from ce_internal_bank_accounts_v where inactive_date is null or inactive_date>sysdate order by bank_account_name AR حساب البنك D Bankkonto E Cuenta Bancaria F Compte bancaire I Conto bancario JA 銀行口座 KO 은행 계좌 PTB Conta Bancária RU Банковский счет S Bankkonto TR Banka Hesabı US Bank Account ZHS 银行帐户 5 40 :p_pmt_method LOV Oracle AP_SRS_PAYMENT_METHOD Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='PAYMENT METHOD' order by value,description select displayed_field from ap_lookup_codes where lookup_type='PAYMENT METHOD' and lookup_code='CHECK' AR طريقة السداد D Zahlungsart E Método de Pago F Mode de règlement I Metodo di pagamento JA 支払方法 KO 결제 방법 PTB Método de Pagamento RU Метод платежа S Betalningssätt TR Ödeme Yöntemi US Payment Method ZHS 付款方法 6 50 :p_vndr_type LOV Oracle AP_SRS_VENDOR_TYPE_UCPRP Y select lookup_code id, displayed_field value, description description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='VENDOR TYPE' order by value,description AR نوع المورد D Lieferantenart E Tipo de Proveedor F Type de fournisseur I Tipo di fornitore JA 仕入先タイプ KO 공급자 유형 PTB Tipo de Fornecedor RU Тип поставщика S Leverantörstyp TR Tedarikçi Tipi US Supplier Type ZHS 供应商类型 7 60 :p_state LOV Oracle AP_SRS_STATE_UCPRP Y select region_short_name id, region_short_name value, region_long_name description from ap_income_tax_regions where sysdate<nvl(inactive_date,sysdate+1) order by upper(region_short_name) AR الولاية D Bundesland E Provincia F Département I Stato JA 都道府県 KO 도 PTB Estado RU Республика S Status TR Eyalet US State ZHS 省（州） 8 70 :p_from_check_date Date AR من تاريخ السداد D Von Zahlungsdatum E De Fecha de Pago F Date de règlement - Du I Data pagamento - Da JA 支払日:自 KO 지급 일자: 부터 PTB Data do Pagamento - De RU Дата платежа с S Från betalningsdatum TR İlk Ödeme Tarihi US From Payment Date ZHS 自付款日期 9 80 :p_to_check_date Date Y AR إلى تاريخ السداد D Bis Zahlungsdatum E A Fecha de Pago F Date de règlement - Au I Data pagamento - A JA 支払日:至 KO 지급 일자: 까지 PTB Data do Pagamento - Até RU Дата платежа по S Till betalningsdatum TR Son Ödeme Tarihi US To Payment Date ZHS 至付款日期