ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4724551A9E05362FB09050512Y SELECT /*+ NO_MERGE (ai) */ UPPER(decode(asp.SORT_BY_ALTERNATE_FIELD , 'Y', nvl(ap.vendor_name_alt,nvl(ap.vendor_name, hp.party_name)) , nvl(ap.vendor_name, hp.party_name) ) ) upp_vend_name_inv, ap.segment1 vendor_num_inv, ai.invoice_num invoice_num, nvl(to_char(ai.doc_sequence_value),ai.voucher_num) voucher_num, ai.invoice_id invoice_id, to_char(ai.invoice_date,'DD-Mon-RRRR') invoice_date, ai.invoice_currency_code invoice_curr_code, ph.segment1 po_number, nvl(ai.invoice_amount,0) invoice_amt, decode(ahc.postable_flag,'N',ah.hold_lookup_code, '') hold_code, alc.displayed_field exception_inv, nvl(ap.vendor_name , hp.party_name) vendor_name_inv, fc.precision precision FROM ( select distinct invoice_id ,invoice_num ,invoice_date ,invoice_currency_code ,invoice_amount ,doc_sequence_value ,voucher_num ,org_id ,party_id ,vendor_id from ap_period_close_excps_gt apexp where apexp.source_type in ( 'LINES_WITHOUT_DISTS' , 'UNACCT_DISTS', 'UNACCT_PREPAY_HIST' ) and (NVL(:G_SWEEP_NOW,'N') = 'N' OR (:G_SWEEP_NOW = 'Y' AND apexp.process_status_flag = 'Y')) ) ai ,ap_holds_all ah, ap_hold_codes ahc, ap_lookup_codes alc, po_line_locations_all pll, po_headers_all ph, ap_suppliers ap, hz_parties hp , ap_system_parameters_all asp, fnd_currencies fc WHERE ai.vendor_id = ap.vendor_id(+) AND ai.party_id = hp.party_id AND ai.invoice_id = ah.invoice_id AND pll.po_header_id = ph.po_header_id(+) AND ah.line_location_id = pll.line_location_id(+) AND ah.hold_lookup_code = ahc.hold_lookup_code AND (ah.release_lookup_code is null and ahc.postable_flag = 'N' and ah.hold_lookup_code is not null and alc.lookup_type = 'HOLD CODE' and alc.lookup_code = ah.hold_lookup_code) AND ai.org_id = asp.org_id AND asp.base_currency_code = fc.currency_code UNION SELECT /*+ NO_MERGE (ai) */ upper(decode(asp.SORT_BY_ALTERNATE_FIELD, 'Y', nvl(ap.vendor_name_alt, nvl(ap.vendor_name, hp.party_name)), nvl(ap.vendor_name, hp.party_name))) upp_vend_name_inv, ap.segment1 vendor_num_inv, ai.invoice_num invoice_num, nvl(to_char(ai.doc_sequence_value),ai.voucher_num) voucher_num, ai.invoice_id invoice_id, to_char(ai.invoice_date,'DD-Mon-RRRR') invoice_date, ai.invoice_currency_code invoice_curr_code, null po_number, nvl(ai.invoice_amount,0) invoice_amt, null hold_code, alc.displayed_field exception_inv, nvl(ap.vendor_name , hp.party_name) vendor_name_inv, fc.precision precision FROM (select distinct invoice_id ,invoice_num ,invoice_date ,invoice_currency_code ,invoice_amount ,org_id ,party_id ,vendor_id ,voucher_num ,doc_sequence_value from ap_period_close_excps_gt apexp where apexp.source_type in ('LINES_WITHOUT_DISTS' ,'UNACCT_DISTS', 'UNACCT_PREPAY_HIST' ) and (NVL(:G_SWEEP_NOW,'N') = 'N' OR (:G_SWEEP_NOW = 'Y' AND process_status_flag = 'Y')) ) ai , ap_suppliers ap ,hz_parties hp , ap_system_parameters_all asp , fnd_currencies fc , ap_lookup_codes alc WHERE ai.vendor_id = ap.vendor_id(+) AND ai.party_id = hp.party_id AND (not exists (select 1 from ap_holds_all ah1, ap_hold_codes ahc1 where ah1.release_lookup_code is null and ahc1.postable_flag = 'N' and ahc1.hold_lookup_code = ah1.hold_lookup_code and ah1.invoice_id = AI.invoice_id)) AND ai.org_id = asp.org_id AND asp.base_currency_code = fc.currency_code AND alc.lookup_type = 'NLS TRANSLATION' and alc.lookup_code = ap_utilities_pkg.get_invoice_status(ai.invoice_id, 'APXUATR') ORDER BY exception_inv, upp_vend_name_inv, invoice_date, invoice_num SQLAP APXUATR_XMLP AR AP تقرير الحركات غير المحتسبة (بتنسيق XML) Imported from BI Publisher Description: تقرير الحركات المحتسبة Application: المدفوعات Source: تقرير الحركات غير المحتسبة (بتنسيق XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg D AP Nicht gebuchte Transaktionen Imported from BI Publisher Description: Nicht gebuchte Transaktionen Application: Kreditoren Source: Nicht gebuchte Transaktionen (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg E AP Informe de Transacciones No Contabilizadas Imported from BI Publisher Description: Informe de transacciones no contabilizadas Application: Payables Source: Informe de Transacciones No Contabilizadas (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg F AP Etat des mouvements non comptabilisés Imported from BI Publisher Description: Etat des mouvements non comptabilisés Application: Payables Source: Etat des mouvements non comptabilisés (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg I AP Rapporto Transazioni non contabilizzate Imported from BI Publisher Description: Rapporto Transazioni non contabilizzate Application: Payables Source: Rapporto Transazioni non contabilizzate (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg JA AP 未計上取引レポート Imported from BI Publisher Description: 未計上取引レポート Application: Payables Source: 未計上取引レポート (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg KO AP 미계상 거래 보고서 Imported from BI Publisher Description: 미계상 거래 보고서 Application: Payables Source: 미계상 거래 보고서(XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg PTB AP Relatório de Transações Não Contabilizadas Imported from BI Publisher Description: Relatório de Transações Não Contabilizadas Application: Payables Source: Relatório de Transações Não Contabilizadas (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg RU AP Отчет о неучтенных транзакциях Imported from BI Publisher Description: Отчет о неучтенных транзакциях Application: Кредиторы Source: Отчет о неучтенных транзакциях (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg S AP Ej bokförda transaktioner - rapport Imported from BI Publisher Description: Ej bokförda transaktioner - rapport Application: Payables Source: Ej bokförda transaktioner - rapport (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg TR AP Hesaplanmamış İşlemler Raporu Imported from BI Publisher Description: Hesaplanmamış İşlemler Raporu Application: Borçlar Muhasebesi Source: Hesaplanmamış İşlemler Raporu (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg US AP Unaccounted Transactions Imported from BI Publisher Description: Unaccounted Transactions Report Application: Payables Source: Unaccounted Transactions Report (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg ZHS AP 未入帐事务处理报表 Imported from BI Publisher Description: 未入帐事务处理报表 Application: 应付帐款 Source: 未入帐事务处理报表 (XML) Short Name: APXUATR_XMLP DB package: ap_period_close_pkg BI Publisher :g_cash_basis_flag :g_fetch_limit :g_ledger_id :g_ledger_name :g_org_id :g_orphan_message_text :g_period_end_date :g_period_name :g_period_start_date :g_reporting_level :g_sweep_now :g_sweep_to_date :g_sweep_to_period 1 -40 :g_ledger_id Number SELECT ledger_id FROM FND_MO_REPORTING_ENTITIES_V WHERE entity_id = :$flex$.reporting_context AND reporting_level = :$flex$.reporting_level AND rownum = 1 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 -30 :g_sweep_now 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' AR يمحو الآن D Jetzt übertragen? E Transferir Ahora F Transférer I Trasferisci ora JA ここでスイープ処理実行 KO 지금 이월 PTB Efetuar varredura agora RU Выполнить перенос S Överför nu TR Şimdi Temizle US Sweep Now ZHS 现在转移 3 -10 :g_trace 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 Trace-Schalter E Conmutador de Rastreo F Activer analyse I Parametro di individuazione JA トレース切替 KO 추적 전환 PTB Chave de Rastreamento RU Ключ трассировки S Spårningsväxel TR İzlemeyi Değiştir US Trace Switch ZHS 跟踪开关 4 10 :g_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 lookup_code IN (1000, 3000) 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 申报级别 5 20 :g_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 申报环境 6 30 :g_start_date Date AR من تاريخ المحاسبة D Von Buchungsdatum E De Fecha de Creación de Asiento F Date comptable - Du I Data registrazione - Da JA 会計日:自 KO 회계 일자:부터 PTB Data Contábil - De RU Начальная дата учета S Från bokföringsdatum TR Muhasebeleşme Başlangıç Tarihi US From Accounting Date ZHS 自会计结算日期 7 40 :g_end_date Date AR إلى تاريخ المحاسبة D Bis Buchungsdatum E A Fecha de Creación de Asiento F Date comptable - Au I Data registrazione - A JA 会計日:至 KO 회계 일자-까지 PTB Data Contábil - Até RU Конечная дата учета S Till bokföringsdatum TR Muhasebeleşme Bitiş Tarihi US To Accounting Date ZHS 至会计结算日期 8 50 :g_period_name LOV Oracle AP_APXTRSWP_TO_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and adjustment_period_flag<>'Y' and ((set_of_books_id=:$flex$.fnd_mo_reporting_entity and :$flex$.fnd_mo_reporting_level=1000) or (set_of_books_id=(select max(set_of_books_id) from ap_system_parameters_all where org_id=:$flex$.fnd_mo_reporting_entity) and :$flex$.fnd_mo_reporting_level=3000)) and (closing_status='O' or closing_status='F') order by period_year desc,period_num desc AR اسم الفترة D Periodenbezeichnung E Nombre del Período F Nom de la période I Nome periodo JA 期間名 KO 기간명 PTB Nome do Período RU Имя периода S Periodnamn TR Dönem Adı US Period Name ZHS 期间名称