ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EED43869E053B46B63588994Y select trx_number Number_A, ctt.name Type , ct.trx_date Date_A , ctlgld.gl_date GL_Date , substrb(party.party_name,1,50) Name , cust.account_number Number_B, AR_RAXIIR_XMLP_PKG.c_data_not_foundformula(trx_number) C_data_not_found from ra_customer_trx ct, hz_cust_accounts cust, hz_parties party, ra_cust_trx_types ctt, ra_cust_trx_line_gl_dist ctlgld where ct.bill_to_customer_id = cust.cust_account_id (+) and cust.party_id = party.party_id(+) and ct.cust_trx_type_id = ctt.cust_trx_type_id and ct.complete_flag = 'N' and ctlgld. latest_rec_flag(+) = 'Y' and ctlgld.customer_trx_id (+) = ct.customer_trx_id and nvl(ctlgld.account_class,'REC') = 'REC' &lp_item_number_low &lp_item_number_high &lp_customer_name_low &lp_customer_name_high &lp_customer_number_low &lp_customer_number_high order by decode(:p_order_by, 'Invoice', ct.trx_number, party.party_name) AR RAXIIR_XML AR AR تقرير الفواتير غير التامة (بتنسيق XML) Application: المقبوضات Source: تقرير الفواتير غير التامة (بتنسيق XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG D AR Rechnungen - nicht abgeschlossen Application: Debitoren Source: Rechnungen - nicht abgeschlossen (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG F AR Liste des factures incomplètes Application: Receivables Source: Liste des factures incomplètes (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG US AR Incomplete Invoices Application: Receivables Source: Incomplete Invoices Report (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG ZHS AR 未完成发票报表 Application: 应收帐款 Source: 未完成发票报表 (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG BI Publisher &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_item_number_high &lp_item_number_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_item_number_high :lp_item_number_low :operating_unit :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_invoice_num_high :p_invoice_num_low :p_order_by :pd_min_customer_name :pd_min_customer_number :rp_company_name :rp_data_found :rp_report_name 1 10 :p_order_by LOV Oracle AR_RAXIIR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXIIR' order by value,description Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_invoice_num_low LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة من D Von Rechnungsnummer F Numéro de facture - De US Invoice Number Low ZHS 发票编号下限 3 30 :p_invoice_num_high LOV Oracle AR_INVOICE_NUMBER Y Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct where ct.customer_trx_id in ( select max(ct2.customer_trx_id) from ra_customer_trx ct2 where ct.trx_number=ct2.trx_number) order by ct.trx_number,ct.customer_trx_id AR رقم فاتورة إلى D Bis Rechnungsnummer F Numéro de facture - A US Invoice Number High ZHS 发票编号上限 4 40 :p_customer_name_low LOV Oracle AR_CUSTOMER_NAME 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 cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل من D Von Kundenname F Nom de client - De US Customer Name Low ZHS 客户名称下限 5 50 :p_customer_name_high LOV Oracle AR_CUSTOMER_NAME 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 cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل إلى D Bis Kundenname F Nom de client - A US Customer Name High ZHS 客户名称上限 6 60 :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 Low ZHS 客户编号下限 7 70 :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 High ZHS 客户编号上限