ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D8695A8CF9CFB1E06362FB09051993 SELECT NVL(payables4.pay_inv_amt_due4,0) tax_amt ,CASE WHEN payables4.pay_inv_amt_due4 <> 0 AND :transaction_type ='PREPAYMENT' AND (payables5.prepay_entered_dr1 - :invoice_amt_entered)!=0 THEN AP_OPEN_BAL_REV_RPT_PKG.vat_calc_amt(payables3.pay_inv_amt_due3 ,payables4.pay_inv_amt_due4 ,:invoice_amt_entered) ELSE :invoice_amt_entered-(payables1.pay_inv_amt_due1+ payables2.pay_inv_amt_due2+ payables3.pay_inv_amt_due3+ payables5.prepay_entered_dr1+ payables6.inv_cm_amt_due+ payables7.cm_inv_amt_due) END inv_amt_due ,CASE WHEN payables4.pay_inv_amt_due_er4 <> 0 AND :transaction_type ='PREPAYMENT' AND (payables5.prepay_entered_dr1 - :invoice_amt_entered)!=0 THEN AP_OPEN_BAL_REV_RPT_PKG.vat_calc_amt(payables3.pay_inv_amt_due_er3 ,payables4.pay_inv_amt_due_er4 ,:invoice_amt_accounted) ELSE :invoice_amt_accounted-(payables1.pay_inv_amt_due_er1+ payables2.pay_inv_amt_due_er2+ payables3.pay_inv_amt_due_er3+ payables5.prepay_accounted_dr1+ payables6.inv_cm_amt_due_er+ payables7.cm_inv_amt_due_er) END inv_amt_due_er ,CASE WHEN payables4.pay_inv_amt_due_er4 <> 0 AND :transaction_type ='PREPAYMENT' AND (payables5.prepay_entered_dr1 - :invoice_amt_entered)!=0 THEN AP_OPEN_BAL_REV_RPT_PKG.amtduereval(AP_OPEN_BAL_REV_RPT_PKG.vat_calc_amt(payables3.pay_inv_amt_due3 ,payables4.pay_inv_amt_due4 ,:invoice_amt_entered) ,:exchange_rate ,:transaction_currency) ELSE AP_OPEN_BAL_REV_RPT_PKG.amtduereval((:invoice_amt_entered - (payables1.pay_inv_amt_due1+ payables2.pay_inv_amt_due2+ payables3.pay_inv_amt_due3+ payables5.prepay_entered_dr1+ payables6.inv_cm_amt_due+ payables7.cm_inv_amt_due)) ,:exchange_rate ,:transaction_currency) END inv_amt_due_reval FROM (SELECT NVL(sum(nvl(XAL.entered_dr,0))-sum(nvl(XAL.entered_cr,0)),0) pay_inv_amt_due1 ,NVL(sum(nvl(XAL.accounted_dr,0))-sum(nvl(XAL.accounted_cr,0)),0) pay_inv_amt_due_er1 FROM ap_invoices AIA ,xla_events xe ,xla_distribution_links XDL ,xla_ae_lines XAL ,gl_import_references GIR ,gl_je_headers GJH WHERE aia.invoice_id=:invoice_id_tag AND aia.invoice_type_lookup_code NOT IN ('PREPAYMENT') AND aia.payment_status_flag <>'Y' --bug7581755 AND xe.application_id=200 AND xe.event_id=xdl.event_id --AND xe.event_type_code IN ('PAYMENT CANCELLED','PAYMENT UNCLEARED','PAYMENT CLEARED') AND XDL.application_id=200 AND XDL.applied_to_source_id_num_1 =:invoice_id_tag AND xdl.applied_to_entity_code='AP_INVOICES' AND xdl.source_distribution_type='AP_PMT_DIST' AND XAL.ae_header_id =XDL.ae_header_id AND XAL.ae_line_num =XDL.ae_line_num AND XAL.application_id =200 AND XAL.accounting_class_code ='LIABILITY' AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id = &gc_ledger_id AND XAL.ACCOUNTING_DATE<= :P_AS_OF_DATE ) payables1 ,(SELECT NVL(SUM(NVL(xdl.unrounded_entered_dr,0)-NVL(xal.unrounded_entered_cr,0)),0) pay_inv_amt_due2 ,NVL(SUM(NVL(xdl.unrounded_accounted_dr,0)-NVL(xdl.unrounded_accounted_cr,0)),0) pay_inv_amt_due_er2 FROM ap_invoices ai ,ap_invoices aipre ,ap_invoice_distributions aid ,ap_invoice_distributions aidpre ,xla_distribution_links xdl ,xla_events xe ,xla_ae_lines xal ,gl_import_references GIR ,gl_je_headers GJH ,gl_code_combinations gcc WHERE ai.invoice_id=:invoice_id_tag AND aidpre.line_type_lookup_code='ITEM' AND aid.invoice_id=ai.invoice_id AND ai.payment_status_flag<>'Y' --bug7581755 AND aidpre.invoice_distribution_id=aid.prepay_distribution_id AND aipre.invoice_id=aidpre.invoice_id AND xdl.application_id=200 AND xdl.event_id=aid.accounting_event_id AND xal.ae_header_id=xdl.ae_header_id AND xal.ae_line_num=xdl.ae_line_num AND xal.application_id=200 AND xal.accounting_class_code='LIABILITY' AND xe.event_id=xdl.event_id AND xe.application_id=200 AND xe.event_type_code IN ('PREPAYMENT UNAPPLIED','PREPAYMENT APPLIED') AND GCC.code_combination_id =XAL.code_combination_id AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id = &gc_ledger_id AND XAL.accounting_date <= :P_AS_OF_DATE ) payables2 ,(SELECT NVL(sum(NVL(xdl.unrounded_ENTERED_cR,0)-NVL(xdl.unrounded_entered_dr,0)),0) pay_inv_amt_due3 ,NVL(sum(NVL(xdl.unrounded_accounted_cr,0)-NVL(xdl.unrounded_accounted_dr,0)),0) pay_inv_amt_due_er3 FROM ap_invoices ai ,ap_invoice_distributions aid ,ap_invoice_distributions aidinv ,ap_invoices aiinv ,xla_events xe ,xla_ae_lines xal ,xla_distribution_links xdl ,gl_import_references GIR ,gl_je_headers GJH WHERE ai.invoice_id=:invoice_id_tag AND aid.invoice_id=ai.invoice_id AND ai.payment_status_flag <>'Y' --bug7581755 AND aid.line_type_lookup_code='ITEM' AND aidinv.prepay_distribution_id=aid.invoice_distribution_id AND aiinv.invoice_id=aidinv.invoice_id AND xe.event_type_code IN ('PREPAYMENT APPLIED','PREPAYMENT UNAPPLIED') AND xe.application_id=200 AND xe.event_id=xdl.event_id AND xdl.event_id=aidinv.accounting_event_id AND xdl.application_id=200 AND xal.ae_header_id=xdl.ae_header_id AND xal.ae_line_num=xdl.ae_line_num AND xal.accounting_class_code='PREPAID_EXPENSE' AND xal.application_id=200 AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id = &gc_ledger_id AND XAL.accounting_date <= :P_AS_OF_DATE ) payables3 ,(SELECT NVL(SUM(NVL(XDL.UNROUNDED_entered_dr,0))-SUM(NVL(XAL.UNROUNDED_entered_cr,0)),0) pay_inv_amt_due4 ,NVL(SUM(NVL(XDL.UNROUNDED_accounted_dr,0))-SUM(NVL(XAL.UNROUNDED_accounted_cr,0)),0) pay_inv_amt_due_er4 FROM ap_invoices_all AI ,ap_invoice_distributions_all AID ,xla_distribution_links XDL ,xla_ae_lines XAL ,gl_import_references GIR ,gl_je_headers GJH ,gl_code_combinations GCC WHERE AI.invoice_id = :invoice_id_tag AND AI.invoice_type_lookup_code = 'PREPAYMENT' AND AID.invoice_id =AI.invoice_id AND AI.payment_status_flag <>'Y' --bug7581755 AND XDL.event_id =AID.accounting_event_id AND XDL.source_distribution_id_num_1 = AID.invoice_distribution_id AND XDL.application_id =200 AND xdl.rounding_class_code in ('RTAX','NRTAX') AND XAL.ae_header_id =XDL.ae_header_id AND XAL.ae_line_num =XDL.ae_line_num AND XAL.ledger_id =AI.set_of_books_id AND XAL.application_id =200 AND GCC.code_combination_id =XAL.code_combination_id AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id = &gc_ledger_id AND XAL.ACCOUNTING_DATE <= :P_AS_OF_DATE )payables4 ,(SELECT CASE WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND :invoice_amt_entered = NVL(SUM(NVL(xdl.unrounded_entered_dr,0)-NVL(xdl.unrounded_entered_cr,0)),0)) THEN TO_NUMBER(0) WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND NVL(SUM(NVL(xdl.unrounded_entered_dr,0)-NVL(xdl.unrounded_entered_cr,0)),0) = 0) THEN TO_NUMBER(:invoice_amt_entered) WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND SUM(NVL(xdl.unrounded_entered_dr,0)-NVL(xdl.unrounded_entered_cr,0)) is null) THEN TO_NUMBER(:invoice_amt_entered) ELSE TO_NUMBER(0) END prepay_entered_dr1 ,CASE WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND :invoice_amt_accounted = NVL(SUM(NVL(xdl.unrounded_accounted_dr,0)-NVL(xdl.unrounded_accounted_cr,0)),0)) THEN TO_NUMBER(0) WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND NVL(SUM(NVL(xdl.unrounded_accounted_dr,0)-NVL(xdl.unrounded_accounted_cr,0)),0) = 0) THEN TO_NUMBER(:invoice_amt_accounted) WHEN (:TRANSACTION_TYPE = 'PREPAYMENT' AND SUM(NVL(xdl.unrounded_accounted_dr,0)-NVL(xdl.unrounded_accounted_cr,0)) is null) THEN TO_NUMBER(:invoice_amt_accounted) ELSE TO_NUMBER(0) END prepay_accounted_dr1 FROM ap_invoices aia ,ap_lookup_codes alc ,ap_invoice_payments aip ,ap_checks ac ,xla_events xe ,xla_distribution_links xdl ,xla_ae_lines xal ,gl_import_references GIR ,gl_je_headers GJH ,gl_code_combinations GCC WHERE aia.invoice_id=:invoice_id_tag AND aia.invoice_type_lookup_code IN ('PREPAYMENT') AND aia.invoice_id=aip.invoice_id AND aia.payment_status_flag<>'Y' --bug7581755 AND ac.check_id=aip.check_id AND alc.lookup_type='PAYMENT TYPE' AND alc.lookup_code=ac.payment_type_flag AND xdl.applied_to_entity_code='AP_INVOICES' AND xdl.source_distribution_type='AP_PMT_DIST' AND xdl.applied_to_source_id_num_1=:invoice_id_tag AND xdl.application_id=200 AND xe.event_id = xdl.event_id AND xe.application_id=200 AND aip.accounting_event_id=xe.event_id AND xal.ae_header_id=xdl.ae_header_id AND xal.ae_line_num=xdl.ae_line_num AND xal.accounting_class_code='LIABILITY' AND xal.application_id=200 --and rounding_class_code='LIABILITY' AND xdl.ae_header_id=xal.ae_header_id AND xdl.ae_line_num=xal.ae_line_num AND GCC.code_combination_id =XAL.code_combination_id AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id = &gc_ledger_id AND GJH.ledger_id = &gc_ledger_id AND XAL.ACCOUNTING_DATE <= :P_AS_OF_DATE)payables5 ,(SELECT NVL(SUM(xdl.unrounded_entered_dr),0)-NVL(SUM(xdl.unrounded_entered_cr),0) inv_cm_amt_due ,NVL(SUM(xdl.unrounded_accounted_dr),0)-NVL(SUM(xdl.unrounded_accounted_cr),0) inv_cm_amt_due_er FROM ap_invoices aia --bug7581755 ,ap_invoice_distributions AID ,xla_events xe ,xla_distribution_links xdl ,xla_ae_lines xal ,gl_import_references GIR ,gl_je_headers GJH WHERE AID.parent_invoice_id=:invoice_id_tag AND aia.invoice_id = aid.invoice_id --bug7581755 AND aia.payment_status_flag<>'Y' --bug7581755 AND XDL.source_distribution_id_num_1=aid.invoice_distribution_id AND XDL.application_id=200 AND xe.event_type_code in ('CREDIT MEMO VALIDATED','DEBIT MEMO VALIDATED') AND xe.application_id=200 AND xe.event_id=xdl.event_id AND XAL.ae_header_id=xdl.ae_header_id AND XAL.ae_line_num=xdl.ae_line_num AND XAL.application_id=200 AND XAL.accounting_class_code='LIABILITY' AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id =&gc_ledger_id AND XAL.ACCOUNTING_DATE<= :P_AS_OF_DATE) payables6 ,(SELECT NVL(SUM(NVL(xdl.unrounded_entered_cr,0)-NVL(xdl.unrounded_entered_dr,0)),0) cm_inv_amt_due ,NVL(SUM(NVL(xdl.unrounded_accounted_cr,0)-NVL(xdl.unrounded_accounted_dr,0)),0) cm_inv_amt_due_er FROM ap_invoices ai ,ap_invoices aicm ,ap_invoice_distributions aid ,ap_invoice_distributions aidcm ,xla_distribution_links xdl ,xla_events xe ,xla_ae_lines xal ,gl_import_references GIR ,gl_je_headers GJH ,gl_code_combinations gcc WHERE ai.invoice_id=:invoice_id_tag AND aid.invoice_id=ai.invoice_id AND ai.payment_status_flag<>'Y' --bug7581755 AND aidcm.invoice_distribution_id=aid.corrected_invoice_dist_id AND aicm.invoice_id=aidcm.invoice_id AND aid.dist_match_type='DIST_CORRECTION' AND XDL.source_distribution_id_num_1=aid.invoice_distribution_id AND xdl.application_id=200 AND xdl.event_id=aid.accounting_event_id AND xal.ae_header_id=xdl.ae_header_id AND xal.ae_line_num=xdl.ae_line_num AND xal.application_id=200 AND xal.accounting_class_code='LIABILITY' AND xe.event_id=xdl.event_id AND xe.application_id=200 AND xe.event_type_code IN ('CREDIT MEMO VALIDATED','DEBIT MEMO VALIDATED') AND GCC.code_combination_id =XAL.code_combination_id AND GIR.gl_sl_link_id =XAL.gl_sl_link_id AND GIR.gl_sl_link_table =XAL.gl_sl_link_table AND GJH.je_header_id =GIR.je_header_id AND GJH.status ='P' AND GJH.ledger_id =&gc_ledger_id AND XAL.accounting_date <= :P_AS_OF_DATE) payables7 Y SQLAP APOBRR AR AP حساب المدفوعات - تقرير إعادة تقييم الأرصدة المفتوحة (3) Imported from BI Publisher Application: المدفوعات Source: حساب المدفوعات - تقرير إعادة تقييم الأرصدة المفتوحة Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG D AP KR Neubewertung Offene Salden (3) Imported from BI Publisher Description: Auswertung "KR Neubewertung Offene Salden" Application: Kreditoren Source: KR Neubewertung Offene Salden Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG E AP Revalorización de Saldos Vivos (3) Imported from BI Publisher Application: Payables Source: AP: Revalorización de Saldos Vivos Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG F AP Etat de réévaluation des soldes AP (3) Imported from BI Publisher Application: Payables Source: Etat de réévaluation des soldes AP Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG I AP Rapporto Rivalutazione saldi aperti AP (3) Imported from BI Publisher Application: Payables Source: Rapporto Rivalutazione saldi aperti AP Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG JA AP AP未回収残高再評価レポート (3) Imported from BI Publisher Application: Payables Source: AP未回収残高再評価レポート Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG KO AP 미결 잔액 재평가 보고서 (3) Imported from BI Publisher Application: Payables Source: AP 미결 잔액 재평가 보고서 Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG PTB AP - Relatório de Validação de Saldos em Aberto (3) Imported from BI Publisher Application: Payables Source: AP - Relatório de Validação de Saldos em Aberto Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG RU AP Отчет о переоценке входящего сальдо КР (3) Imported from BI Publisher Application: Кредиторы Source: Отчет о переоценке входящего сальдо КР Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG S AP Rapport om omvärdering av öppna saldon (3) Imported from BI Publisher Application: Payables Source: AP: Rapport om omvärdering av öppna saldon Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG TR AP Açık Bakiyeler Yeniden Değerleme Raporu (3) Imported from BI Publisher Application: Borçlar Muhasebesi Source: AP Açık Bakiyeler Yeniden Değerleme Raporu Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG US AP Open Balances Revaluation (4) Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG ZHS AP 未结余额重估报表 (3) Imported from BI Publisher Application: 应付帐款 Source: AP 未结余额重估报表 Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG BI Publisher 1=1 :p_as_of_date :p_org_id 1 -10 :p_dummy Char SELECT 'Y' FROM SYS.DUAL WHERE :$flex$.exchange_rate_type='User' AR الافتراضي الافتراضي D Dummy Dummy E Ficticio Ficticio F Fictif Fictif I Fittizio Fittizio JA ダミー ダミー KO Dummy Dummy PTB Fictício Fictício RU Фиктивный Фиктивный S Dummy Dummy TR Sözde Sözde US Dummy Dummy ZHS 虚拟 虚拟 2 10 :p_org_id 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 业务实体 业务实体 3 20 :p_as_of_date Date Y AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom E A la Fecha A la Fecha F En date du En date du I In data In data JA 現在 現在 KO 기준 일자 기준 일자 PTB Data de Referência Data de Referência RU На дату На дату S Per datum Per datum TR Başlangıç Tarihi Başlangıç Tarihi US As of Date As of Date ZHS 截止日期 截止日期 4 30 :p_exchange_rate_type LOV Oracle XLA_EXCHANGE_RATE_TYPES Y select conversion_type id, user_conversion_type value, null description from gl_daily_conversion_types order by value,description Y AR نوع سعر الصرف نوع سعر الصرف D Wechselkursart Wechselkursart E Clase de Tipo de Cambio Clase de Tipo de Cambio F Type de taux de change Type de taux de change I Tipo di tasso di cambio Tipo di tasso di cambio JA 換算レート・タイプ 換算レート・タイプ KO 환율 유형 환율 유형 PTB Tipo de Taxa de Câmbio Tipo de Taxa de Câmbio RU Тип обменного курса Тип обменного курса S Växelkurstyp Växelkurstyp TR Döviz Kuru Tipi Döviz Kuru Tipi US Exchange Rate Type Exchange Rate Type ZHS 汇率类型 汇率类型 5 40 :p_currency 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 Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 6 50 :p_exchange_rate Char Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率 7 60 :p_include_domestic_inv 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 Y AR تضمين فاتورة محلية تضمين فاتورة محلية D Mit Inlandsrechnung Mit Inlandsrechnung E Incluir Factura Nacional Incluir factura nacional F Inclure les factures nationales Inclure les factures nationales I Includi fattura nazionale Include la fattura nazionale JA 国内請求書を含む 国内請求書を含む KO 국내 송장 포함 국내 송장 포함 PTB Incluir NFF Nacional Incluir NFF Nacional RU Включить счет-фактуру во внутренней валюте Включить счет-фактуру во внутренней валюте S Inkludera inhemsk faktura Inkludera inhemsk faktura TR Yurtiçi Faturayı Dahil Et Yurtiçi Faturayı Dahil Et US Include Domestic Invoice Include Domestic Invoice ZHS 包括国内发票 包括国内发票 8 70 :p_supplier LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR المُورَّد المُورَّد D Lieferant Lieferant E Proveedor Proveedor F Fournisseur Fournisseur I Fornitore Fornitore JA 仕入先 仕入先 KO 공급자 공급자 PTB Fornecedor Fornecedor RU Поставщик Поставщик S Leverantör Leverantör TR Tedarikçi Tedarikçi US Supplier Supplier ZHS 供应商 供应商 :$flex$.exchange_rate_type Exchange Rate Type Dummy