ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4721251A9E05362FB09050512 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 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 APADVSELCUR AR AP الدفعات المقدمة بالعملة المحددة Imported from BI Publisher Application: المدفوعات Source: الدفعات المقدمة بالعملة المحددة Short Name: APADVSELCUR DB package: AP_BAL_PKG D AP Vorschusszahlungen in gewählter Währung Imported from BI Publisher Application: Kreditoren Source: Vorschusszahlungen in gewählter Währung Short Name: APADVSELCUR DB package: AP_BAL_PKG E AP Anticipos en la Divisa Seleccionada Imported from BI Publisher Application: Payables Source: Anticipos en la Divisa Seleccionada Short Name: APADVSELCUR DB package: AP_BAL_PKG F AP Avances dans la devise sélectionnée Imported from BI Publisher Application: Payables Source: Avances dans la devise sélectionnée Short Name: APADVSELCUR DB package: AP_BAL_PKG I AP Anticipi nella divisa selezionata Imported from BI Publisher Application: Payables Source: Anticipi nella divisa selezionata Short Name: APADVSELCUR DB package: AP_BAL_PKG JA AP 選択した通貨での仮払金 Imported from BI Publisher Application: Payables Source: 選択した通貨での仮払金 Short Name: APADVSELCUR DB package: AP_BAL_PKG KO AP 선택된 통화의 선급금 Imported from BI Publisher Application: Payables Source: 선택된 통화의 선급금 Short Name: APADVSELCUR DB package: AP_BAL_PKG PTB AP Adiantamentos na Moeda Selecionada Imported from BI Publisher Application: Payables Source: Adiantamentos na Moeda Selecionada Short Name: APADVSELCUR DB package: AP_BAL_PKG RU AP Авансы в выбранной валюте Imported from BI Publisher Application: Кредиторы Source: Авансы в выбранной валюте Short Name: APADVSELCUR DB package: AP_BAL_PKG S AP Förskott i vald valuta Imported from BI Publisher Application: Payables Source: Förskott i vald valuta Short Name: APADVSELCUR DB package: AP_BAL_PKG TR AP Seçili Para Birimi Cinsinden Avanslar Imported from BI Publisher Application: Borçlar Muhasebesi Source: Seçili Para Birimi Cinsinden Avanslar Short Name: APADVSELCUR DB package: AP_BAL_PKG US AP Advances in Selected Currency Imported from BI Publisher Application: Payables Source: Advances in Selected Currency Short Name: APADVSELCUR DB package: AP_BAL_PKG ZHS AP 以选定币种表示的预付款 Imported from BI Publisher Application: 应付帐款 Source: 以选定币种表示的预付款 Short Name: APADVSELCUR DB package: AP_BAL_PKG BI Publisher &flex_where_gl_account &gc_additional_where &gc_currency &gc_org_where &gc_status &gc_supplier &gc_where_clause :account_from_param :account_to_param :coa_id_param :curr_code_param :dummy_param :format :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 -20 :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 -10 :dummy_param Number 2 AR الافتراضي الافتراضي = خالي - بدون قيود، = 2 - بدون سجلات الضرائب، = 3 - نوع الرصيد الفعلي فقط D Dummy Dummy = NULL - Keine Einschränkung, = 2 - Keine Steuerdatensätze, = 3 - Nur Saldenart IST E Ficticio Ficticio = NULO - 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 - 仅限于“实际”余额类型 3 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 业务实体 业务实体 4 20 :from_date_param Date SELECT sysdate FROM DUAL Y AR اعتبارًا من تاريخ من تاريخ D Vom Von Datum E A Fecha De Fecha F En date du Date de début I In data Data - Da JA 現在 日付:自 KO 기준 일자 일자: 부터 PTB Data de Referência Data - De RU На дату Начальная дата S Per datum Från datum TR Başlama Tarihi Başlangıç Tarihi US As Of Date From Date ZHS 截止日期 自日期 5 30 :curr_code_param LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR رمز العملة رمز العملة D Währung Währung E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 6 40 :account_from_param Char AR حساب من حساب من D Von Konto Von Konto E De Cuenta De cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目: 自 勘定科目: 自 KO 시작 계정 시작 계정 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR İlk Hesap İlk Hesap US Account From Account From ZHS 帐户自 帐户自 7 50 :account_to_param Char AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目: 至 勘定科目: 至 KO 종료 계정 종료 계정 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Son Hesap Son Hesap US Account To Account To ZHS 帐户至 帐户至 8 60 :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 起始供应商 起始供应商 9 70 :supplier_to_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 Bis Lieferant Bis Lieferant E A Proveedor A Proveedor F Fournisseur - A Fournisseur - A I Fornitore - A Fornitore - A JA 仕入先:至 仕入先:至 KO 공급자: 까지 공급자: 까지 PTB Fornecedor - Até Fornecedor - Até RU Поставщик по Поставщик по S Till leverantör Till leverantör TR Son Tedarikçi Son Tedarikçi US Supplier To Supplier To ZHS 供应商至 供应商至 10 80 :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 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) 11 90 :posted_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 AR المرحل فقط المرحل فقط (نعم/لا) D Nur verbuchte Nur verbuchte (J/N) E Sólo Contabilizado Sólo Contabilizado (S/N) F Imputé seulement Imputé seulement (O/N) I Solo contabilizzato Solo contabilizzato (S/N) JA 転記済のみ 転記済のみ(Y/N) KO 전기됨만 전기됨만(Y/N) PTB Somente Contabilizado Somente Contabilizado (S/N) RU Только проведенные Только проведенные (да/нет) S Endast postad Endast postad (J/N) TR Sadece Muhasebeleşen Sadece Muhasebeleşen (E/H) US Posted Only Posted Only (Y/N) ZHS 仅限于已过帐 仅限于已过帐 (Y/N)