ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEB13869E053B46B63588994Y select organization_name, as_of_date, customer_name, customer_number, tax_reference_num, address_line1, address_line2, address_line3, address_line4, city, state, zip, country, decode( trans_type,'INV','Standard','DM', 'Debit Memo','CB','Chargeback','DEP','Deposit') trans_type, trx_number, transaction_date, trx_currency_code, nvl(trans_amount,0) trans_amount, nvl( trans_amount_remaining,0) trans_amount_remaining, nvl( receipt_amount,0) receipt_amount, nvl(adjustment_amount,0) adjustment_amount, nvl(earned_discount_amount,0) earned_discount_amount, nvl(unearned_discount_amount,0) unearned_discount_amount, nvl(invoice_credit_amount,0) invoice_credit_amount, nvl(bank_charge,0) bank_charge, nvl(on_account_credit_amount,0) on_account_credit_amount, nvl( on_account_receipts,0) on_account_receipts, nvl(unapplied_receipts,0) unapplied_receipts, AR_ARXCOBLX_XMLP_PKG.c_as_of_date_displayformula() C_as_of_date_display, AR_ARXCOBLX_XMLP_PKG.cf_totalformula(:C_inv_open_balance, :CF_credits_and_receipts) CF_Total, AR_ARXCOBLX_XMLP_PKG.cf_credits_and_receiptsformula(:C_unapplied_receipts, :C_on_account_receipts, :C_on_account_credits) CF_credits_and_receipts from ar_customer_balance_itf Where request_id =:p_conc_request_id --order by transaction_date, trx_number order by 3,12,9,8,2,5,11,7,6,13,10,4,1,17,15,14,16,18,19,20,21,22,23,24,25,26,27,28 AR ARXCOBLX_XML AR AR خطاب الرصيد المفتوح للعميل (بتنسيق XML) Application: المقبوضات Source: خطاب الرصيد المفتوح للعميل (بتنسيق XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG D AR Offener Saldo - Kunde Application: Debitoren Source: Offener Saldo - Kunde (XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG F AR Lettre de solde du client Application: Receivables Source: Lettre de solde du client (XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG US AR Customer Open Balance Letter Application: Receivables Source: Customer Open Balance Letter (XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG ZHS AR 客户未结余额信函 Application: 应收帐款 Source: 客户未结余额信函 (XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG BI Publisher :c_inv_open_balance :c_on_account_credits :c_on_account_receipts :c_unapplied_receipts :cf_credits_and_receipts :operating_unit :p_as_of_date :p_conc_request_id :p_currency :p_customer_name_from :p_customer_name_to :p_customer_number_high :p_customer_number_low :p_debug_flag :p_include_on_account_credits :p_include_on_account_receipts :p_include_unapplied_receipts :p_include_uncleared_receipts :p_min_customer_balance :p_min_invoice_balance :p_reference_number :p_set_of_books_id :p_trace_flag 1 10 :p_as_of_date Date Y AR اعتبارًا من تاريخ D Vom F En date du US As of date ZHS 截止日期 2 20 :p_customer_name_from LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description AR اسم العميل من D Von Kundenname F Nom de client - De US Customer Name From ZHS 客户名称自 3 30 :p_customer_name_to LOV Oracle AR_CUSTOMER_NAME_WIDE Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and exists (select cas.cust_account_id from hz_cust_acct_sites cas where cas.cust_account_id=cu.cust_account_id) order by value,description AR اسم العميل إلى D Bis Kundenname F Nom de client - A US Customer Name To ZHS 客户名称至 4 40 :p_customer_number_low LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number 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 Von Kundennummer F Numéro de client - De US Customer Number From ZHS 客户编号自 5 50 :p_customer_number_high LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number 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 Bis Kundennummer F Numéro de client - A US Customer Number To ZHS 客户编号至 6 60 :p_currency LOV Oracle AR_SRS_CURRENCY Y select currency_code id, currency_code value, name description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code AR العملة D Währung F Devise US Currency ZHS 币种 7 70 :p_min_invoice_balance Number AR الحد الأدنى لرصيد الفاتورة D Mindest-Rechnungssaldo F Solde minimum de facture US Minimum Invoice Balance ZHS 最小发票余额 8 80 :p_min_customer_balance Number AR الحد الأدنى للرصيد المفتوح D Offener Mindestsaldo F Solde minimum US Minimum Open Balance ZHS 最小未结余额 9 90 :p_include_on_account_credits LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR تضمين الائتمانات تحت الحساب D Mit Gutschriften ohne Re-Bezug F Inclure les crédits en compte US Include On Account Credits ZHS 包括记帐贷项 10 100 :p_include_on_account_receipts LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR تضمين الإيصالات تحت الحساب D Mit Vorauszahlungen F Inclure les règlements en compte US Include On Account Receipts ZHS 包括记帐收款 11 110 :p_include_unapplied_receipts LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR تضمين الإيصالات غير المطبقة D Mit nicht zugeordneten Zahlungen F Inclure les règlements non lettrés US Include Unapplied Receipts ZHS 包括未核销收款 12 120 :p_include_uncleared_receipts LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR تضمين الإيصالات غير المصفاة D Mit nicht abgestimmten Zahlungen F Inclure les règlements dont l'apurement a été annulé US Include Uncleared Receipts ZHS 包括未结收款 13 130 :p_reference_number Char AR رقم المرجع D Referenznummer F Numéro de référence US Reference Number ZHS 参考编号