ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D842E7E9CF9DE06362FB0905A273 SELECT rownum unq_ident /*Bug 16613775*/ ,ai.invoice_id prepay_id ,decode ( :format ,'EXCEL' ,'="' || TO_CHAR (ai.invoice_num) || '"' ,ai.invoice_num ) invoice_number ,TO_CHAR(ai.gl_date, FND_PROFILE.value ('ICX_DATE_FORMAT_MASK')) gl_date ,ai.invoice_date invoice_date ,ai.doc_sequence_value doc_sequence_value ,ai.invoice_type_lookup_code invoice_type ,pov.vendor_name supplier_name ,pov.segment1 supplier_code ,ai.payment_status_flag paid_unpaid ,TO_CHAR(ai.earliest_settlement_date, FND_PROFILE.value ('ICX_DATE_FORMAT_MASK')) date_settled ,ai.invoice_currency_code curr_code ,aid.accounting_date accounting_date ,hou.organization_id operating_unit_id ,hou.name organization_name ,NVL(xdl.unrounded_entered_dr,0) - NVL(xdl.unrounded_entered_cr,0) adv_amt_fr_curr ,NVL(xdl.unrounded_accounted_dr,0) - NVL(xdl.unrounded_accounted_cr,0) adv_amt_fn_curr ,AP_BAL_PKG.prepay_amt_applied(ai.invoice_id,:gd_from_date) pre_amt_from_fr ,AP_BAL_PKG.prepay_amt_applied(ai.invoice_id,:gd_from_date) * NVL(ai.exchange_rate,1) pre_amt_from_fn ,AP_BAL_PKG.prepay_amt_applied(ai.invoice_id,:gd_to_date) pre_amt_to_fr ,AP_BAL_PKG.prepay_amt_applied(ai.invoice_id,:gd_to_date) * NVL(ai.exchange_rate,1) pre_amt_to_fn /*Bug11655402 : Added decode below */ ,DECODE(ai.payment_status_flag, 'Y', NVL(aid.prepay_amount_remaining,aid.amount), NVL(aid.prepay_amount_remaining,0)) bal_amt_fr_curr ,DECODE(ai.payment_status_flag, 'Y', NVL(aid.prepay_amount_remaining,aid.amount), NVL(aid.prepay_amount_remaining,0)) * NVL(ai.exchange_rate,1) bal_amt_fn_curr /*,TO_CHAR(ac.check_date, FND_PROFILE.value ('ICX_DATE_FORMAT_MASK')) payment_date*/ /*Bug11791895*/ ,AP_BAL_PKG.get_no_of_holds(ai.invoice_id) holdbacks ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_ff_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') acct_ff ,fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') balancing_segment ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') cost_center_segment ,fnd_flex_xml_publisher_apis.process_kff_combination_1('natural_acct_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') natural_acct_segment ,fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_select_desc', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') balancing_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select_desc', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'FULL_DESCRIPTION') cost_center_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('natural_acct_select', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') natural_acct_desc ,ai.attribute3 issuing_dept_code /*,NVL(avprpv.prepay_amount_applied,0) pre_amt_appl_fr_curr ,NVL(avprpv.prepay_amount_applied,0) * NVL(ai.exchange_rate,1) pre_amt_appl_fn_curr ,decode ( :format ,'EXCEL' ,'="' || TO_CHAR (decode(aip.invoice_payment_type, 'PREPAY', ai.invoice_num, ac.check_number)) || '"' ,decode(aip.invoice_payment_type, 'PREPAY', ai.invoice_num, ac.check_number) ) int_num ,ac.check_id check_id*/ /*Bug11791895*/ ,AP_BAL_PKG.get_settlement_date(AI.invoice_id,AIL.line_number) settlement_date ,AP_BAL_PKG.description(gcc.segment4,'SEGMENT4') desc_segment4 ,AP_BAL_PKG.description(ai.attribute3,'ATTRIBUTE3') desc_attribute3 ,gcc.segment1 segment1 ,gcc.segment2 segment2 ,gcc.segment3 segment3 ,gcc.segment4 segment4 ,gcc.segment5 segment5 ,gcc.segment6 segment6 ,gcc.segment7 segment7 ,gcc.segment8 segment8 ,gcc.segment9 segment9 ,gcc.segment10 segment10 ,gcc.segment11 segment11 ,gcc.segment12 segment12 ,gcc.segment13 segment13 ,gcc.segment14 segment14 ,gcc.segment15 segment15 ,gcc.segment16 segment16 ,gcc.segment17 segment17 ,gcc.segment18 segment18 ,gcc.segment19 segment19 ,gcc.segment20 segment20 ,gcc.segment21 segment21 ,gcc.segment22 segment22 ,gcc.segment23 segment23 ,gcc.segment24 segment24 ,gcc.segment25 segment25 ,gcc.segment26 segment26 ,gcc.segment27 segment27 ,gcc.segment28 segment28 ,gcc.segment29 segment29 ,gcc.segment30 segment30 ,xah.gl_transfer_status_code gl_transfer_status_code ,gjh.status posting_status FROM ap_invoices ai ,ap_invoice_lines_all ail ,ap_invoice_distributions_all aid ,xla_ae_headers xah ,xla_ae_lines xal ,gl_code_combinations gcc ,po_vendors pov ,xla_distribution_links xdl ,hr_operating_units hou /*,ap_invoice_payments_all aip*/ /*Commenetd as code cleanup for Bug 16613775*/ /*,ap_checks_all ac */ /*Commenetd as code cleanup for Bug 16613775*/ ,gl_import_references gir ,gl_je_headers gjh /*Bug13389653 - Removed table avprpv */ /*,(SELECT avprpv.org_id org_id ,avprpv.prepay_id prepay_id ,avprpv.prepay_line_number prepay_line_number ,avprpv.prepay_amount_applied prepay_amount_applied FROM ap_view_prepays_fr_prepay_v avprpv WHERE NVL(avprpv.accounting_date, :gd_from_date) <= :gd_to_date) avprpv */ WHERE ai.invoice_id = ail.invoice_id AND ail.invoice_id = aid.invoice_id AND ail.line_number = aid.invoice_line_number AND NVL(aid.reversal_flag,'N') <> 'Y' /*Bug31014344*/ AND xal.code_combination_id = gcc.code_combination_id AND ai.vendor_id = pov.vendor_id AND ai.invoice_type_lookup_code = 'PREPAYMENT' AND ai.set_of_books_id = xah.ledger_id --Bug8260360 AND aid.accounting_event_id = xah.event_id AND xdl.source_distribution_id_num_1 = aid.invoice_distribution_id AND xal.ae_header_id = xah.ae_header_id AND xdl.ae_header_id = xal.ae_header_id AND xdl.ae_line_num = xal.ae_line_num AND hou.organization_id = ai.org_id AND xah.application_id = 200 AND xal.application_id = 200 AND xdl.application_id = 200 /* AND xdl.rounding_class_code <> 'LIABILITY'*/ /*Commented for bug 16733413*/ AND xal.accounting_class_code <> 'LIABILITY' /*Added for bug 16733413*/ AND xdl.source_distribution_type <> 'AP_PMT_DIST' --Used to confirm the Invoice is Accounted (Final) AND xah.accounting_entry_status_code <> 'D' --Used to confirm the Invoice is Accounted AND aid.accrual_posted_flag = 'Y' --Used to Obtain the records with the Balance Type 'Actual' AND xah.balance_type_code = 'A' AND NVL (aid.accounting_date, ai.gl_date) <= :gd_to_date AND ai.cancelled_date IS NULL /*AND ai.invoice_id = aip.invoice_id(+) */ /*Commented as code cleanup for Bug 16613775 Start*/ /*AND aip.check_id = ac.check_id(+) AND ac.void_date IS NULL Bug 16613775 End */ /* Bug13389653 */ /* AND ail.invoice_id = avprpv.prepay_id(+) AND ail.line_number = avprpv.prepay_line_number(+) AND ail.org_id = avprpv.org_id(+) */ /* End of Bug13389653 */ AND xal.gl_sl_link_id = gir.gl_sl_link_id(+) AND xal.gl_sl_link_table = gir.gl_sl_link_table(+) AND gir.je_header_id = gjh.je_header_id(+) AND xal.ledger_id = NVL(gjh.ledger_id,xal.ledger_id) AND &flex_where_gl_account &gc_currency &gc_status &gc_org_where &gc_supplier &gc_where_clause &gc_additional_where ORDER BY gl_date Y SQLAP APPPBR AR AP حساب المدفوعات - تقرير رصيد الدفعة المقدمة (2) Imported from BI Publisher Application: المدفوعات Source: حساب المدفوعات - تقرير رصيد الدفعة المقدمة Short Name: APPPBR DB package: AP_BAL_PKG D AP KR Vorauszahlungssalden (2) Imported from BI Publisher Description: Auswertung "KR Vorauszahlungssalden" Application: Kreditoren Source: KR Vorauszahlungssalden Short Name: APPPBR DB package: AP_BAL_PKG E AP Saldo de Adelanto (2) Imported from BI Publisher Application: Payables Source: AP: Saldo de Adelanto Short Name: APPPBR DB package: AP_BAL_PKG F AP - Etat des soldes d'acompte (2) Imported from BI Publisher Application: Payables Source: AP - Etat des soldes d'acompte Short Name: APPPBR DB package: AP_BAL_PKG I AP Rapporto Saldo anticipo AP (2) Imported from BI Publisher Application: Payables Source: Rapporto Saldo anticipo AP Short Name: APPPBR DB package: AP_BAL_PKG JA AP AP前払金残高レポート (2) Imported from BI Publisher Application: Payables Source: AP前払金残高レポート Short Name: APPPBR DB package: AP_BAL_PKG KO AP 선급금 잔액 보고서 (2) Imported from BI Publisher Application: Payables Source: AP 선급금 잔액 보고서 Short Name: APPPBR DB package: AP_BAL_PKG PTB AP - Relatório de Saldo do Pagamento Antecipado (2) Imported from BI Publisher Application: Payables Source: AP - Relatório de Saldo do Pagamento Antecipado Short Name: APPPBR DB package: AP_BAL_PKG RU AP Отчет об остатке предоплаты КР (2) Imported from BI Publisher Application: Кредиторы Source: Отчет об остатке предоплаты КР Short Name: APPPBR DB package: AP_BAL_PKG S AP Rapport om saldo för förskottsbelopp (2) Imported from BI Publisher Application: Payables Source: AP: Rapport om saldo för förskottsbelopp Short Name: APPPBR DB package: AP_BAL_PKG TR AP Ön Ödeme Bakiyesi Raporu (2) Imported from BI Publisher Application: Borçlar Muhasebesi Source: AP Ön Ödeme Bakiyesi Raporu Short Name: APPPBR DB package: AP_BAL_PKG US AP Prepayment Balance (2) Imported from BI Publisher Application: Payables Source: AP Prepayment Balance Report Short Name: APPPBR DB package: AP_BAL_PKG ZHS AP 预付款余额报表 (2) Imported from BI Publisher Application: 应付帐款 Source: AP 预付款余额报表 Short Name: APPPBR DB package: AP_BAL_PKG BI Publisher 1=1 :account_from_param :account_to_param :coa_id_param :curr_code_param :dummy_param :from_date_param :gc_additional_where :gc_currency :gc_from_clause :gc_ledger_name :gc_org_where :gc_pre_amt_appl :gc_status :gc_supplier :gc_where_clause :gd_from_date :gd_to_date :org_id_param :paid_only_param :period_from_param :period_to_param :posted_only_param :supplier_from_param :supplier_to_param :to_date_param 1 -30 :coa_id_param LOV Oracle AX_SRS_COA Y select chart_of_accounts_id id, chart_of_accounts_id value, name description from gl_sets_of_books where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kennung Kontenplan Kennung Kontenplan E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB ID do Plano de Contas ID do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesaplar Grafiği No Hesaplar Grafiği No US Chart Of Accounts ID Chart Of Accounts ID ZHS 科目表标识 科目表标识 2 -20 :paid_only_param LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Yes AR المدفوع فقط المدفوع فقط (نعم/لا) D Nur bezahlte Nur bezahlte (J/N) E Sólo Pagado Sólo Pagado (S/N) F Réglé seulement Réglé seulement (O/N) I Solo pagato Solo pagato (S/N) JA 支払済のみ 支払済のみ(Y/N) KO 지급완료만 지급완료만(Y/N) PTB Somente Pago Somente Pago (S/N) RU Только оплаченные Только оплаченные (да/нет) S Endast betald Endast betald (J/N) TR Sadece Ödenen Sadece Ödenen (E/H) US Paid Only Paid Only (Y/N) ZHS 仅限于已付 仅限于已付 (Y/N) 3 -10 :dummy_param Number 3 AR الافتراضي الافتراضي = خالي - بدون قيود، = 2 - بدون سجلات الضرائب، = 3 - نوع الرصيد الفعلي فقط D Dummy Dummy = NULL - Keine Einschränkung, = 2 - Keine Steuerdatensätze, = 3 - Nur Saldenart IST E Ficticio Ficticio = NULL - Sin restricción, = 2 - Sin registro fiscal, = 3 - Sólo tipo de saldo REAL F Fictif Fictif = NULL - Sans restriction, = 2 - Aucun enregistrement de taxe, = 3 - Type de solde REEL seulement I Fittizio Fittizio = NULLO - Nessuna limitazione, = 2 - Nessun record imposta, = 3 - Solo tipo di saldo EFFETTIVO JA ダミー ダミー = NULL - 制限なし、 = 2 - 税金レコードなし、 = 3 - 実績残高タイプのみ KO Dummy Dummy = NULL - 제한 없음, = 2 - 비세금 레코드, = 3 - 실제 잔액 유형만 PTB Fictício Fictício = NULO - Sem restrição, = 2 - Nenhum Registro de Imposto, = 3 - Somente Tipo de Saldo REAL RU Фиктивный Фиктивный = NULL - без ограничений, = 2 - без налоговых записей, = 3 - только тип остатка "Фактический" S Dummy Dummy = NULL - ingen begränsning, = 2 - inga skatteposter, = 3 - endast typ av FAKTISKT saldo TR Sözde Sözde = BOŞ - Kısıtlama Yok, = 2 - Vergi Kayıtları Yok, = 3 - Sadece FİİLİ Bakiye Tipi US Dummy Dummy = NULL - No restriction, = 2 - No Tax Records, = 3 - Only ACTUAL Balance Type ZHS 虚拟 虚拟 = NULL - 无限制，= 2 - 无纳税记录，= 3 - 仅限于“实际”余额类型 4 10 :org_id_param LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description AR وحدة التشغيل وحدة التشغيل D Betriebseinheit Betriebseinheit E Unidad Operativa Unidad Operativa F Unité opérationnelle Unité opérationnelle I Unità operativa Unità operativa JA 営業単位 営業単位 KO 운영 단위 운영 단위 PTB Unidade Operacional Unidade Operacional RU Операционная единица Операционная единица S Operativ enhet Operativ enhet TR Faaliyet Birimi Faaliyet Birimi US Operating Unit Operating Unit ZHS 业务实体 业务实体 5 20 :period_from_param LOV Oracle AP_SRS_ACCOUNTING_PERIOD_MAND Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') and closing_status<>'N' and adjustment_period_flag<>'Y' order by period_year desc,period_num desc Y AR الفترة من الفترة من D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 시작 기간 시작 기간 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem Başlangıcı Dönem Başlangıcı US Period From Period From ZHS 期间自 期间自 6 30 :period_to_param LOV Oracle AP_SRS_ACCOUNTING_PERIOD_GREATER_OR_EQUAL Y select period_name id, period_name value, null description from gl_period_statuses where application_id=200 and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') and start_date>=(select max(start_date) from gl_period_statuses where period_name=:$flex$.ap_srs_accounting_period_mand and set_of_books_id=fnd_profile.value('gl_set_of_bks_id') and application_id=200) and closing_status='O' order by period_year desc,period_num desc Y AR الفترة إلى الفترة إلى D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 종료 기간 종료 기간 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Bitiş Dönemi Bitiş Dönemi US Period To Period To ZHS 期间至 期间至 7 40 :supplier_from_param LOV Oracle AP_SRS_VENDOR_NAME_CHAR Y select po.vendor_name id, po.vendor_name value, null description from po_vendors po where po.vendor_id= (select max(po2.vendor_id) from po_vendors po2 where po2.vendor_name=po.vendor_name) order by po.vendor_name AR مورد من مورد من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseur - De Fournisseur - De I Fornitore - Da Fornitore - Da JA 仕入先:自 仕入先:自 KO 공급자: 부터 공급자: 부터 PTB Fornecedor - De Fornecedor - De RU Поставщик с Поставщик с S Från leverantör Från leverantör TR İlk Tedarikçi İlk Tedarikçi US Supplier From Supplier From ZHS 起始供应商 起始供应商 :$flex$.ap_srs_accounting_period_mand Period From Period To