ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D840ACE3CF99E06362FB0905AA49 SELECT hou.name ou_name ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') accounting_flexfield ,rcta.invoice_currency_code currency_code ,hp.party_name customer_name ,rcta.trx_number invoice_number , '' lookup_code , rcta.trx_date invoice_date ,rcta.doc_sequence_value internal_invoice_no ,rctt.type transaction_type ,rcta.customer_trx_id cust_trx_id , DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(rcta.invoice_currency_code),0)) exchange_rate ,SUM(aps.amount_due_original) invoice_amt_entered ,SUM(aps.amount_due_original) test ,0 invoice_amt_accounted ,SUM(aps.amount_due_original) - NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.applied_customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.application_type != 'CASH' AND rctt.type = 'CM' AND ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount) FROM ar_adjustments ara WHERE ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) inv_amt_due , NVL(APS.exchange_rate,1) * (SUM(aps.amount_due_original) - NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.applied_customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.application_type != 'CASH' AND rctt.type = 'CM' AND ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount) FROM ar_adjustments ara WHERE ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) ) inv_amt_due_er ,(SUM(APS.amount_due_original) - NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.applied_customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.application_type != 'CASH' AND rctt.type = 'CM' AND ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ARA.amount) FROM ar_adjustments ARA WHERE ARA.customer_trx_id = RCtA.customer_trx_id AND ara.gl_date <= &gd_date_to ),0 ) ) * NVL(DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(rcta.invoice_currency_code),0)),0) inv_amt_due_reval FROM hr_operating_units hou ,ra_customer_trx rcta ,ar_payment_schedules aps ,ra_cust_trx_types rctt ,ra_cust_trx_line_gl_dist rctlgd ,gl_code_combinations gcc ,xla_distribution_links xdl ,xla_ae_lines xal ,gl_import_references gir ,gl_je_headers gjh ,hz_cust_accounts hca ,hz_parties hp ,ar_system_parameters sp WHERE HOU.set_of_books_id = sp.set_of_books_id AND RCtA.customer_trx_id = APS.customer_trx_id AND RCtA.org_id = HOU.organization_id AND APS.org_id = RCtA.org_id AND RCtA.cust_trx_type_id = RCTT.cust_trx_type_id AND RCtA.org_id = RCTT.org_id AND RCTLGD.org_id = RCTT.org_id AND APS.customer_trx_id = RCTLGD.customer_trx_id -- AND gcc.code_combination_id = RCTLGD.code_combination_id AND aps.gl_date <= &gd_date_to AND rctlgd.account_class ='REC' AND RCTLGD.latest_rec_flag ='Y' AND xdl.source_distribution_id_num_1 =rctlgd.cust_trx_line_gl_dist_id AND xdl.SOURCE_DISTRIBUTION_TYPE = 'RA_CUST_TRX_LINE_GL_DIST_ALL' AND xdl.application_id =222 AND xal.ae_header_id =xdl.ae_header_id AND xal.ae_line_num =xdl.ae_line_num AND xal.application_id =222 AND xal.accounting_class_code ='RECEIVABLE' 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 = sp.set_of_books_id AND sp.org_id = :P_ORG_ID AND rcta.bill_to_customer_id = hca.cust_account_id AND hp.party_id = hca.party_id --AND HCA.account_number = :P_CUSTOMER AND &gc_trx_date_where1 AND &gc_ou_where1 AND &gc_customer_where1 AND &gc_currency_where1 AND &gc_incl_domestic_inv_where1 GROUP BY hou.name ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ,rcta.invoice_currency_code ,hp.party_name ,rcta.trx_number , '' , rcta.trx_date ,rcta.doc_sequence_value ,rctt.type ,hca.cust_account_id , DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(rcta.invoice_currency_code),0)) ,rcta.customer_trx_id , NVL(APS.exchange_rate,1) -- added for bug 18327012 HAVING NVL((SUM(APS.amount_due_original) - NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.applied_customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ara.amount_applied) FROM ar_receivable_applications ara WHERE ara.status = 'APP' AND ara.application_type != 'CASH' AND rctt.type = 'CM' AND ara.customer_trx_id = rcta.customer_trx_id AND ara.gl_date <= &gd_date_to),0 ) + NVL( ( SELECT SUM(ARA.amount) FROM ar_adjustments ARA WHERE ARA.customer_trx_id = RCtA.customer_trx_id AND ara.gl_date <= &gd_date_to),0)),0 ) <> 0 UNION SELECT abc.op_name ou_name, abc.accounting_flexfield accounting_flexfield, abc.currency_code currency_code, hp.party_name customer_name, abc.invoice_number invoice_number, abc.lookup_code lookup_code, abc.receipt_date invoice_date, abc.int_invoice_number internal_invoice_no, abc.trans_type transaction_type, abc.custid cust_trx_id, abc.exchange_rate exchange_rate, abc.orig_amt invoice_amt_entered, NVL(ar_obalrev_pkg.test(abc.invoice_number,abc.orig_amt),0) test, 0 invoice_amt_accounted, 0-abc.original_amount inv_amt_due, 0-abc.historic_amount inv_amt_due_er, 0-abc.closing_amount inv_amt_due_reval FROM ( SELECT hou.name op_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') accounting_flexfield, hca.cust_account_id custid, decode(ara.status, 'ACC', '*' || al.meaning) trans_type, acr.receipt_number invoice_number, acr.doc_sequence_value int_invoice_number, acr.receipt_date, al.lookup_code, acr.amount orig_amt, nvl(acr.exchange_rate, 1) orig_invoice_rate, SUBSTR(acr.currency_code, 1, 3) currency_code, (SUM(nvl(ara.amount_applied,0))) original_amount, (SUM(nvl(acr.exchange_rate, 1) *nvl(ara.amount_applied, 0))) historic_amount, ((SUM(NVL(ara.amount_applied,0))) *(DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(acr.currency_code),0)))) closing_amount, DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(acr.currency_code),0)) exchange_rate FROM hr_operating_units hou, ar_receivable_applications ara, ar_lookups al, ar_cash_receipts acr, ar_cash_receipt_history acrh, hz_cust_accounts hca, gl_code_combinations gcc, ar_distributions ads, xla_distribution_links xdl, xla_ae_lines xal, gl_import_references gir, gl_je_headers gjh, ar_system_parameters sp WHERE hou.set_of_books_id = sp.set_of_books_id AND acr.org_id = hou.organization_id AND acr.org_id = ara.org_id AND hca.cust_account_id = acr.pay_from_customer AND acr.cash_receipt_id = ara.cash_receipt_id AND acrh.cash_receipt_id = ara.cash_receipt_id AND ara.cash_receipt_history_id = acrh.cash_receipt_history_id AND al.lookup_type = 'PAYMENT_TYPE' AND ara.status = al.lookup_code -- AND gcc.code_combination_id = ara.code_combination_id --AND trate.tran_curr_code(+) = acr.currency_code AND ara.status = 'ACC' AND not exists( select 'X' from ar_cash_receipt_history crhin where crhin.cash_receipt_id = acr.cash_receipt_id AND crhin.status = 'REVERSED' ) AND nvl(ara.confirmed_flag, 'Y') = 'Y' AND nvl(acr.confirmed_flag, 'Y') = 'Y' AND ads.source_id = acrh.CASH_RECEIPT_HISTORY_ID AND xdl.source_distribution_id_num_1 = ads.line_id AND xdl.application_id =222 AND xal.ae_header_id =xdl.ae_header_id AND xal.ae_line_num =xdl.ae_line_num AND xal.application_id =222 AND xal.accounting_class_code ='ACC' 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.ledger_id = sp.set_of_books_id AND sp.org_id = :P_ORG_ID AND gjh.status ='P' AND &gc_trx_date_where AND &gc_incl_domestic_inv_where AND &gc_customer_where AND &gc_currency_where AND &gc_ou_where GROUP BY hou.name, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), hca.cust_account_id, decode(ara.status, 'ACC', '*' || al.meaning), acr.receipt_number, acr.doc_sequence_value, acr.receipt_date,al.lookup_code, acr.amount, nvl(acr.exchange_rate, 1), SUBSTR(acr.currency_code, 1, 3), acr.currency_code HAVING SUM(ara.amount_applied) <> 0 UNION SELECT hou.name op_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') accounting_flexfield, hca.cust_account_id custid, decode(ara.status, 'UNAPP', '*' || al.meaning) trans_type, acr.receipt_number invoice_number, acr.doc_sequence_value int_invoice_number, acr.receipt_date, al.lookup_code , acr.amount orig_amt, nvl(acr.exchange_rate, 1) orig_invoice_rate, SUBSTR(acr.currency_code, 1, 3) currency_code, (SUM(ara.amount_applied)) original_amount, (SUM(nvl(acr.exchange_rate, 1) *nvl(ara.amount_applied, 0))) historic_amount, (SUM(ara.amount_applied)) *(DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(acr.currency_code),0))) closing_amount, DECODE(:p_exchange_rate_type,'User',REPLACE(:p_exchange_rate,',','.') ,NVL(ar_obalrev_pkg.get_rate(acr.currency_code),0)) exchange_rate FROM hr_operating_units hou, ar_receivable_applications ara, ar_lookups al, ar_cash_receipts acr, ar_cash_receipt_history acrh, hz_cust_accounts hca, gl_code_combinations gcc, ar_distributions ads, xla_distribution_links xdl, xla_ae_lines xal, gl_import_references gir, gl_je_headers gjh, ar_system_parameters sp WHERE hou.set_of_books_id = sp.set_of_books_id AND acr.org_id = hou.organization_id AND acr.org_id = ara.org_id AND hca.cust_account_id = acr.pay_from_customer AND acr.cash_receipt_id = ara.cash_receipt_id AND acrh.cash_receipt_id = ara.cash_receipt_id AND ara.cash_receipt_history_id = acrh.cash_receipt_history_id AND al.lookup_type = 'PAYMENT_TYPE' AND ara.status = al.lookup_code -- AND gcc.code_combination_id = ara.code_combination_id AND ara.status = 'UNAPP' AND nvl(ara.confirmed_flag, 'Y') = 'Y' AND nvl(acr.confirmed_flag, 'Y') = 'Y' AND ads.source_id = acrh.cash_receipt_history_id AND xdl.source_distribution_id_num_1 = ads.line_id AND xdl.application_id =222 AND xal.ae_header_id =xdl.ae_header_id AND xal.ae_line_num =xdl.ae_line_num AND xal.application_id =222 AND xal.accounting_class_code ='UNAPP' AND ads.source_type <> 'BANK_CHARGES' -- added to exclude Bank Charges 18327012 AND ads.source_table='CRH' -- added to exclude Bank Charges 18327012 AND xdl.SOURCE_DISTRIBUTION_TYPE='AR_DISTRIBUTIONS_ALL' --for bug 18327012 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.ledger_id = sp.set_of_books_id AND sp.org_id = :P_ORG_ID AND gjh.status ='P' AND not exists( select 'X' from ar_cash_receipt_history crhin where crhin.cash_receipt_id = acr.cash_receipt_id AND crhin.status = 'REVERSED' ) AND &gc_trx_date_where AND &gc_incl_domestic_inv_where AND &gc_customer_where AND &gc_currency_where AND &gc_ou_where GROUP BY hou.name, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_select_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), hca.cust_account_id, decode(ara.status, 'UNAPP', '*' || al.meaning), acr.receipt_number, acr.doc_sequence_value, acr.receipt_date,al.lookup_code, acr.amount, nvl(acr.exchange_rate, 1), SUBSTR(acr.currency_code, 1, 3), acr.currency_code HAVING SUM(ara.amount_applied) <> 0) abc, hz_cust_accounts hca, hz_parties hp WHERE hca.party_id = hp.party_id AND hca.cust_account_id = abc.custid AND &gc_customer_where1 ORDER BY invoice_number Y AR AROBRR AR AR تقرير إعادة تقييم الأرصدة المفتوحة في المقبوضات Imported from BI Publisher Application: المقبوضات Source: تقرير إعادة تقييم الأرصدة المفتوحة في المقبوضات Short Name: AROBRR DB package: ar_obalrev_pkg D AR KR Neubewertung Offene Salden Imported from BI Publisher Description: Auswertung "KR Neubewertung Offene Salden" Application: Debitoren Source: KR Neubewertung Offene Salden Short Name: AROBRR DB package: ar_obalrev_pkg E AR - Informe Revalorización de Saldos Vivos Imported from BI Publisher Description: AR - Informe de revalorización de saldos vivos Application: Receivables Source: AR - Informe Revalorización de Saldos Vivos Short Name: AROBRR DB package: ar_obalrev_pkg F AR Etat de réévaluation des soldes AP Imported from BI Publisher Application: Receivables Source: Etat de réévaluation des soldes AP Short Name: AROBRR DB package: ar_obalrev_pkg I AR Rapporto Rivalutazione saldi aperti AR Imported from BI Publisher Application: Receivables Source: Rapporto Rivalutazione saldi aperti AR Short Name: AROBRR DB package: ar_obalrev_pkg JA AR ARオープン残高再評価レポート Imported from BI Publisher Application: Receivables Source: ARオープン残高再評価レポート Short Name: AROBRR DB package: ar_obalrev_pkg KO AR 미결 잔액 재평가 보고서 Imported from BI Publisher Application: Receivables Source: AR 미결 잔액 재평가 보고서 Short Name: AROBRR DB package: ar_obalrev_pkg PTB AR - Relatório de Revaloração de Saldos em Aberto Imported from BI Publisher Application: Receivables Source: AR - Relatório de Revaloração de Saldos em Aberto Short Name: AROBRR DB package: ar_obalrev_pkg RU AR отчет о переоценке входящих сальдо Imported from BI Publisher Application: Дебиторы Source: ДБ: отчет о переоценке входящих сальдо Short Name: AROBRR DB package: ar_obalrev_pkg S AR Rapport om omvärdering av öppna saldon Imported from BI Publisher Application: Receivables Source: AR: Rapport om omvärdering av öppna saldon Short Name: AROBRR DB package: ar_obalrev_pkg TR AR Açık Bakiyeler Yeniden Değerleme Raporu Imported from BI Publisher Application: Alacaklar Muhasebesi Source: AR Açık Bakiyeler Yeniden Değerleme Raporu Short Name: AROBRR DB package: ar_obalrev_pkg US AR Open Balances Revaluation (1) Imported from BI Publisher Application: Receivables Source: AR Open Balances Revaluation Report Short Name: AROBRR DB package: ar_obalrev_pkg ZHS AR 未结余额重估报表 Imported from BI Publisher Application: 应收帐款 Source: AR 未结余额重估报表 Short Name: AROBRR DB package: ar_obalrev_pkg BI Publisher 1=1 :gc_currency_where :gc_currency_where1 :gc_customer_name :gc_customer_where :gc_customer_where1 :gc_exchange_rate_type :gc_func_currency :gc_incl_domestic_inv_where :gc_incl_domestic_inv_where1 :gc_ledger_id :gc_ou_name :gc_ou_where :gc_ou_where1 :gc_trx_date_where :gc_trx_date_where1 :gd_date_to :gd_date_to1 :p_as_of_date :p_currency :p_customer :p_dummy :p_exchange_rate :p_exchange_rate_type :p_incl_domestic_inv :p_org_id :var2 1 -10 :p_dummy Char SELECT 'Y' FROM SYS.DUAL WHERE :$flex$.exchange_rate_type='User' AR افتراضي افتراضي D Dummy Dummy E Ficticia Ficticia F Fictif Fictif I Fittizio Fittizio JA ダミー ダミー KO Dummy Dummy PTB Fictício Fictício RU Фиктивный Фиктивный S Dummy Dummy TR Sözde Değer Sözde Değer US Dummy Dummy ZHS 虚拟 虚拟 2 10 :p_org_id LOV Oracle AR_SRS_OPERATING_UNITS Y select organization_id id, name value, null description from hr_operating_units hr where mo_global.check_access(hr.organization_id)='Y' order by value,description Y 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 Fecha A 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 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_incl_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 Inlandsrechnungen Mit Inlandsrechnungen E Incluir Facturas Nacionales Incluir facturas nacionales F Inclure les factures nationales Inclure les factures nationales I Includi fatture nazionali Include le fatture nazionali JA 国内請求書を含む 国内請求書を含む KO 국내 송장 포함 국내 송장 포함 PTB Incluir NFFs Internas Incluir NFFs Internas RU Включить СФ во внутренней валюте Включить счета-фактуры во внутренней валюте S Inkludera inhemska fakturor Inkludera inhemska fakturor TR Yurtiçi Faturaları Dahil Et Yurtiçi Faturaları Dahil Et US Include Domestic Invoices Include Domestic Invoices ZHS 包括国内发票 包括国内发票 8 70 :p_customer LOV Oracle AR_CUST_NAME Y select cust.account_number id, party.party_name value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR العميل العميل D Kunde Kunde E Cliente Cliente F Client Client I Cliente Cliente JA 顧客 顧客 KO 고객 고객 PTB Cliente Cliente RU Заказчик Заказчик S Kund Kund TR Müşteri Müşteri US Customer Customer ZHS 客户 客户 :$flex$.exchange_rate_type Exchange Rate Type Dummy