ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EED73869E053B46B63588994 select rtrim(rpad(l_types.meaning,11)) invoice_type, A.trx_number trx_number, rtrim(rpad(types.name,8)) type, substrb(PARTY.party_name,1,50) name, B.account_number customer_number, A.trx_date invoice_date, P.due_date ps_due_date, nvl( P.amount_due_original + decode(a.initial_customer_trx_id, '', 0, nvl(com_adj.amount,0) ), ( rec.amount * ( NVL(TL.RELATIVE_AMOUNT, 100) * (100/NVL(T.BASE_AMOUNT,100)) ) / 100 ) ) amount, rtrim(rpad(A.invoice_currency_code, 11)) invoice_currency_code, printing_last_printed last_print_date, decode(printing_pending, 'Y', '*', '') printing_pending, A.last_printed_sequence_num last_printed_sequence_num, TL.sequence_num sequence_num, AR_RAXINVPR_XMLP_PKG.installment_last_print_datefor(TL.sequence_num, A.last_printed_sequence_num, decode ( printing_pending , 'Y' , '*' , '' ), printing_last_printed) INSTALLMENT_LAST_PRINT_DATE, AR_RAXINVPR_XMLP_PKG.INSTALLMENT_PRINTING_PENDING_p INSTALLMENT_PRINTING_PENDING ,AR_RAXINVPR_XMLP_PKG.D_AmountFormula() FROM &p_table1 WHERE &p_where1 UNION select rtrim(rpad(l_types.meaning,11)) invoice_type, A.trx_number trx_number, rtrim(rpad(types.name,8)) type, substrb(PARTY.party_name,1,50) name, B.account_number customer_number, A.trx_date invoice_date, P.due_date ps_due_date, P.amount_due_original + decode(a.initial_customer_trx_id, '', 0, nvl(com_adj.amount,0) ) amount, rtrim(rpad(A.invoice_currency_code,11) ) invoice_currency_code, printing_last_printed last_print_date, decode(printing_pending, 'Y', '*', '') printing_pending, A.last_printed_sequence_num last_printed_sequence_num, P.terms_sequence_number sequence_num, AR_RAXINVPR_XMLP_PKG.installment_last_print_datefor(TL.sequence_num, A.last_printed_sequence_num, decode ( printing_pending , 'Y' , '*' , '' ), printing_last_printed) INSTALLMENT_LAST_PRINT_DATE, AR_RAXINVPR_XMLP_PKG.INSTALLMENT_PRINTING_PENDING_p INSTALLMENT_PRINTING_PENDING ,AR_RAXINVPR_XMLP_PKG.D_AmountFormula() FROM &p_table2 WHERE &p_where2 order by 9,1,3,2,6,7 Y AR RAXINVPR_XML AR AR تقرير عرض أولي لطباعة الفاتورة (بتنسيق XML) Application: المقبوضات Source: تقرير عرض أولي لطباعة الفاتورة (بتنسيق XML) Short Name: RAXINVPR_XML DB package: AR_RAXINVPR_XMLP_PKG D AR Voranzeige Application: Debitoren Source: Rechnungsdruck: Voranzeige (XML) Short Name: RAXINVPR_XML DB package: AR_RAXINVPR_XMLP_PKG F AR Simulation d'impression des factures Application: Receivables Source: Simulation d'impression des factures (XML) Short Name: RAXINVPR_XML DB package: AR_RAXINVPR_XMLP_PKG US AR Invoice Print Preview Application: Receivables Source: Invoice Print Preview Report (XML) Short Name: RAXINVPR_XML DB package: AR_RAXINVPR_XMLP_PKG ZHS AR 发票打印预览报表 Application: 应收帐款 Source: 发票打印预览报表 (XML) Short Name: RAXINVPR_XML DB package: AR_RAXINVPR_XMLP_PKG BI Publisher &p_table1 &p_table2 &p_where1 &p_where2 :batch_id :customer_id :functional_currency :installment_printing_pending :invoice_dates :invoice_numbers :open_invoices :operating_unit :p_adj_dates_high :p_adj_dates_low :p_adj_number_high :p_adj_number_low :p_batch_id :p_choice :p_conc_request_id :p_cust_trx_class :p_cust_trx_type_id :p_customer_class_code :p_customer_id :p_customer_trx_id :p_dates_high :p_dates_low :p_installment_number :p_min_precision :p_open_invoice :p_table1 :p_table2 :p_trx_number_high :p_trx_number_low :p_where1 :p_where2 :print_option :rp_company_name :rp_data_found :rp_report_name :type_id 1 10 :p_choice LOV Oracle AR_SRS_INVOICE_PRINTING Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='INVOICE_PRINTING' and enabled_flag='Y' order by meaning Y AR اختيار الطباعة D Druckoption F Option d'impression US Print Choice ZHS 打印选项 2 20 :p_open_invoice 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 Y AR فواتير مفتوحة فقط D Nur offene Rechnungen F Factures non soldées uniquement US Open Invoices Only ZHS 仅限于未结发票 3 30 :p_cust_trx_type_id LOV Oracle AR_RAXINV_TRX_TYPE Y select ctt.cust_trx_type_id id, ctt.name value, ctt.description description from ra_cust_trx_types ctt where nvl(:$flex$.ar_raxinv_invoice_class:null, ctt.type)=ctt.type order by ctt.name AR نوع الحركة D Transaktionsart F Type de mouvement US Transaction Type ZHS 事务处理类型 4 40 :p_trx_number_low LOV Oracle AR_RAXINV_TRX_NUMBER Y Y select trx.trx_number id, trx.trx_number value, substr(l1.meaning || ' : ' || type.name,1,30) description from ra_customer_trx trx,ra_cust_trx_types type,ar_lookups l1 where trx.complete_flag='Y' and trx.printing_option='PRI' and trx.cust_trx_type_id=type.cust_trx_type_id and type.type=l1.lookup_code and l1.lookup_type='INV/CM' and type.type= nvl(:$flex$.ar_raxinv_invoice_class:null,type.type) and trx.cust_trx_type_id= nvl(:$flex$.ar_raxinv_trx_type:null,trx.cust_trx_type_id) and trx.customer_trx_id in (select max(trx2.customer_trx_id) from ra_customer_trx trx2, ra_cust_trx_types type2, ar_lookups l2 where trx2.complete_flag='Y' and trx2.printing_option='PRI' and trx2.cust_trx_type_id= type2.cust_trx_type_id and type2.type=l2.lookup_code and l2.lookup_type='INV/CM' and type2.type= nvl(:$flex$.ar_raxinv_invoice_class:null, type2.type) and trx2.cust_trx_type_id= nvl(:$flex$.ar_raxinv_trx_type:null, trx2.cust_trx_type_id) and trx2.trx_number=trx.trx_number) order by trx.trx_number,l1.meaning, trx.cust_trx_type_id, trx.customer_trx_id AR رقم الحركة من D Von Transaktionsnummer F Numéro de mouvement - De US Transaction Number Low ZHS 事务处理编号下限 5 50 :p_trx_number_high LOV Oracle AR_RAXINV_TRX_NUMBER Y Y select trx.trx_number id, trx.trx_number value, substr(l1.meaning || ' : ' || type.name,1,30) description from ra_customer_trx trx,ra_cust_trx_types type,ar_lookups l1 where trx.complete_flag='Y' and trx.printing_option='PRI' and trx.cust_trx_type_id=type.cust_trx_type_id and type.type=l1.lookup_code and l1.lookup_type='INV/CM' and type.type= nvl(:$flex$.ar_raxinv_invoice_class:null,type.type) and trx.cust_trx_type_id= nvl(:$flex$.ar_raxinv_trx_type:null,trx.cust_trx_type_id) and trx.customer_trx_id in (select max(trx2.customer_trx_id) from ra_customer_trx trx2, ra_cust_trx_types type2, ar_lookups l2 where trx2.complete_flag='Y' and trx2.printing_option='PRI' and trx2.cust_trx_type_id= type2.cust_trx_type_id and type2.type=l2.lookup_code and l2.lookup_type='INV/CM' and type2.type= nvl(:$flex$.ar_raxinv_invoice_class:null, type2.type) and trx2.cust_trx_type_id= nvl(:$flex$.ar_raxinv_trx_type:null, trx2.cust_trx_type_id) and trx2.trx_number=trx.trx_number) order by trx.trx_number,l1.meaning, trx.cust_trx_type_id, trx.customer_trx_id AR رقم الحركة إلى D Bis Transaktionsnummer F Numéro de mouvement - A US Transaction Number High ZHS 事务处理编号上限 6 60 :p_dates_low Date AR تاريخ الطباعة من D Von Druckdatum F Date d'impression - Du US Print Date Low ZHS 打印日期下限 7 70 :p_dates_high Date AR تاريخ الطباعة إلى D Bis Druckdatum F Date d'impression - Au US Print Date High ZHS 打印日期上限 8 80 :p_customer_id LOV Oracle AR_CUSTOMER_NAME_ID Y Y select cust.cust_account_id id, party.party_name||' ('||cust.account_number||')' value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id and nvl(cust.customer_class_code,'X')= nvl(:$flex$.ar_raxinv_customer_class:null, nvl(cust.customer_class_code,'X')) order by party.party_name,cust.account_number,cust.cust_account_id AR العميل D Kunde F Client US Customer ZHS 客户 9 90 :p_batch_id LOV Oracle AR_RAXINV_BATCH Y select b.batch_id id, b.name||' ('||bs.name||')' value, null description from ra_batches b,ra_batch_sources bs where bs.batch_source_id=b.batch_source_id order by b.name,bs.name AR المجموعة D Stapel F Lot US Batch ZHS 批 10 100 :p_installment_number Number AR رقم القسط D Ratenzahlungs-Nr. F Numéro d'échéance US Installment Number ZHS 分期付款编号