ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EECE3869E053B46B63588994Y select distinct(nvl(trx.invoice_currency_code, :functional_currency)) currency_code, decode(upper(:p_sort_by), 'COMMITMENT NUMBER', trx.trx_number, 'CUSTOMER NAME',substrb(party.party_name,1,50), 'CUSTOMER NUMBER',cust.account_number, 'AGREEMENT NAME',agree.name, 'AGREEMENT TYPE',agree.name, trx.trx_number) dummy_order_by, trx.customer_trx_id customer_trx_id, trx.trx_number trx_number, substrb(party.party_name,1,50) customer_name, cust.account_number customer_number, type.name type_name, type.type commit_type, agree.name agree_name, trx.start_date_commitment start_date , trx.end_date_commitment end_date, rep.name rep_name, upper(fnd_user.user_name) user_name, nvl(lines.extended_amount,0) commitment_amount, trx.trx_number dummya, substrb(party.party_name,1,50) dummyb, cust.account_number dummyc, agree.name dummyd, trx.trx_date commitment_trx_date, lgd.gl_date commitment_gl_date, NULL dummye, AR_RAXCBR_XMLP_PKG.c_sum_invoiced_amount_arformul(:Sum_Invoiced_Amount_Inv, :Sum_Invoiced_Amount_CM) C_Sum_Invoiced_Amount_AR, AR_RAXCBR_XMLP_PKG.c_sum_freight_amount_arformula(:Sum_Freight_Amount_Inv, :Sum_Freight_Amount_CM) C_Sum_Freight_Amount_AR, AR_RAXCBR_XMLP_PKG.c_sum_tax_amount_arformula(:Sum_Tax_Amount_Inv, :Sum_Tax_Amount_CM) C_Sum_Tax_Amount_AR, AR_RAXCBR_XMLP_PKG.c_sum_bal_amount_arformula(:Sum_Bal_Amount_Inv, :Sum_Bal_Amount_CM) C_Sum_Bal_Amount_AR, AR_RAXCBR_XMLP_PKG.c_sum_line_amount_arformula(:Sum_Line_Amount_Inv, :Sum_Line_Amount_CM) C_Sum_Line_Amount_AR, AR_RAXCBR_XMLP_PKG.c_sum_adjusted_amount_arformul(:Sum_Adjusted_Amount_Inv, :Sum_Adjusted_Amount_CM) C_Sum_Adjusted_Amount_AR, AR_RAXCBR_XMLP_PKG.c_commitment_balanceformula(nvl ( lines.extended_amount , 0 ), trx.customer_trx_id, type.type) C_Commitment_Balance, AR_RAXCBR_XMLP_PKG.c_oe_amountformula(trx.customer_trx_id) C_OE_Amount, --AR_RAXCBR_XMLP_PKG.c_commitment_remformula(nvl ( lines.extended_amount , 0 ), :C_Commitment_Balance, :C_OE_Amount) C_COMMITMENT_REM AR_RAXCBR_XMLP_PKG.c_commitment_remformula(nvl ( lines.extended_amount , 0 ), AR_RAXCBR_XMLP_PKG.c_commitment_balanceformula(nvl ( lines.extended_amount , 0 ), trx.customer_trx_id, type.type), AR_RAXCBR_XMLP_PKG.c_oe_amountformula(trx.customer_trx_id)) C_COMMITMENT_REM from hz_cust_accounts cust, hz_parties party, ra_cust_trx_line_gl_dist lgd, ra_cust_trx_types type, so_agreements agree, fnd_user, ra_customer_trx_lines lines, ra_salesreps rep, ra_customer_trx trx where trx.customer_trx_id = lines.customer_trx_id and trx.bill_to_customer_id = cust.cust_account_id and cust.party_id = party.party_id &lp_customer_number_low &lp_customer_number_high &lp_customer_name_low &lp_customer_name_high and trx.cust_trx_type_id = type.cust_trx_type_id and type.type in ('DEP','GUAR') &lp_commitment_type_low &lp_commitment_type_high and trx.complete_flag = 'Y' &lp_commitment_low &lp_commitment_high &lp_currency_code_low &lp_currency_code_high &lp_end_date_low &lp_end_date_high and trx.agreement_id = agree.agreement_id(+) &lp_agreement_name_low &lp_agreement_name_high and trx.primary_salesrep_id = rep.salesrep_id(+) and trx.created_by = fnd_user.user_id and trx.customer_trx_id = lgd.customer_trx_id and lgd.latest_rec_flag = 'Y' and lgd.account_class = 'REC' &lp_gl_date_low &lp_gl_date_high &lp_trx_date_low &lp_trx_date_high /*order by nvl(invoice_currency_code, :functional_currency), decode(upper(:p_sort_by), 'END DATE', trx.end_date_commitment), decode(upper(:p_sort_by), 'COMMITMENT NUMBER', trx.trx_number, 'CUSTOMER NAME', substrb(party.party_name,1,50), 'CUSTOMER NUMBER',cust.account_number, 'AGREEMENT NAME',agree.name, 'AGREEMENT TYPE',agree.name, trx.trx_number), substrb(party.party_name,1,50), type.type*/ ORDER BY 1 ASC,2 ASC , nvl (invoice_currency_code , :functional_currency ) , decode ( upper ( :p_sort_by ) , 'END DATE' , trx.end_date_commitment ) , decode ( upper ( :p_sort_by ) , 'COMMITMENT NUMBER' , trx.trx_number , 'CUSTOMER NAME' , substrb ( party.party_name , 1 , 50 ) , 'CUSTOMER NUMBER' , cust.account_number , 'AGREEMENT NAME' , agree.name , 'AGREEMENT TYPE' ,agree.name , trx.trx_number ) , substrb ( party.party_name , 1 , 50 ) ,type.type AR RAXCBR_XML AR AR تقرير رصيد الارتباط (بتنسيق XML) Application: المقبوضات Source: تقرير رصيد الارتباط (بتنسيق XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG D AR Verpflichtungen - Saldenauswertung Application: Debitoren Source: Verpflichtungen - Saldenauswertung (XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG F AR Balance des contrats Application: Receivables Source: Balance des contrats (XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG US AR Commitment Balance Application: Receivables Source: Commitment Balance Report (XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG ZHS AR 承付款余额报表 Application: 应收帐款 Source: 承付款余额报表 (XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG BI Publisher &lp_agreement_name_high &lp_agreement_name_low &lp_commitment_high &lp_commitment_low &lp_commitment_type_high &lp_commitment_type_low &lp_currency_code_high &lp_currency_code_low &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_end_date_high &lp_end_date_low &lp_gl_date_high &lp_gl_date_low &lp_trx_date_high &lp_trx_date_low :c_industry_code :c_salesorder_title :c_salesrep_title :functional_currency :lp_agreement_name_high :lp_agreement_name_low :lp_commitment_high :lp_commitment_low :lp_commitment_type_high :lp_commitment_type_low :lp_currency_code_high :lp_currency_code_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_end_date_high :lp_end_date_low :lp_gl_date_high :lp_gl_date_low :lp_trx_date_high :lp_trx_date_low :lp_unbooked :operating_unit :p_agreement_name_high :p_agreement_name_low :p_commitment_high :p_commitment_low :p_commitment_type_high :p_commitment_type_low :p_conc_request_id :p_currency_code_high :p_currency_code_low :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_end_date_high :p_end_date_high_1 :p_end_date_low :p_end_date_low_1 :p_gl_date_high :p_gl_date_low :p_level :p_min_precision :p_so_source_code :p_sort_by :p_trx_date_high :p_trx_date_low :p_unbooked :rp_company_name :rp_data_found :rp_report_name :sum_adjusted_amount_cm :sum_adjusted_amount_inv :sum_bal_amount_cm :sum_bal_amount_inv :sum_freight_amount_cm :sum_freight_amount_inv :sum_invoiced_amount_cm :sum_invoiced_amount_inv :sum_line_amount_cm :sum_line_amount_inv :sum_tax_amount_cm :sum_tax_amount_inv 1 10 :p_sort_by LOV Oracle AR_RAXCBR_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_RAXCBR' order by upper(meaning) Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_commitment_low LOV Oracle AR_COMMITMENT_NUMBER Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct,ra_cust_trx_types ctt where ct.cust_trx_type_id=ctt.cust_trx_type_id and ctt.type in ('GUAR','DEP') and ct.complete_flag='Y' and ct.customer_trx_id=( select max(ct2.customer_trx_id) from ra_customer_trx ct2, ra_cust_trx_types ctt2 where ct2.trx_number=ct.trx_number and ct2.cust_trx_type_id=ctt2.cust_trx_type_id and ctt2.type in ('GUAR','DEP') and ct2.complete_flag='Y') order by ct.trx_number,ct.customer_trx_id AR رقم ارتباط من D Von Verpflichtungs-Nr. F Numéro de contrat - De US Commitment Number Low ZHS 承付款编号下限 3 30 :p_commitment_high LOV Oracle AR_COMMITMENT_NUMBER Y select ct.trx_number id, ct.trx_number value, null description from ra_customer_trx ct,ra_cust_trx_types ctt where ct.cust_trx_type_id=ctt.cust_trx_type_id and ctt.type in ('GUAR','DEP') and ct.complete_flag='Y' and ct.customer_trx_id=( select max(ct2.customer_trx_id) from ra_customer_trx ct2, ra_cust_trx_types ctt2 where ct2.trx_number=ct.trx_number and ct2.cust_trx_type_id=ctt2.cust_trx_type_id and ctt2.type in ('GUAR','DEP') and ct2.complete_flag='Y') order by ct.trx_number,ct.customer_trx_id AR رقم ارتباط إلى D Bis Verpflichtungs-Nr. F Numéro de contrat - A US Commitment Number High ZHS 承付款编号上限 4 40 :p_agreement_name_high LOV Oracle SO_SRS_AGREEMENT_NAME Y select name id, name value, null description from so_agreements order by value,description AR اسم اتفاقية من D Von Vereinbarung F Nom d'accord-cadre - De US Agreement Name High ZHS 协议名称下限 5 50 :p_agreement_name_low LOV Oracle SO_SRS_AGREEMENT_NAME Y select name id, name value, null description from so_agreements order by value,description AR اسم اتفاقية من D Von Vereinbarung F Nom accord-client - De US Agreement Name Low ZHS 协议名称下限 6 60 :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 客户名称下限 7 70 :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 客户名称上限 8 80 :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 客户编号下限 9 90 :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 客户编号上限 10 100 :p_commitment_type_low LOV Oracle AR_COMMITMENT_TYPE Y select name id, name value, description description from ra_cust_trx_types where type in ('GUAR','DEP') order by name,cust_trx_type_id AR نوع ارتباط من D Von Verpflichtungsart F Type de contrat - De US Commitment Type Low ZHS 承付款类型下限 11 110 :p_commitment_type_high LOV Oracle AR_COMMITMENT_TYPE Y select name id, name value, description description from ra_cust_trx_types where type in ('GUAR','DEP') order by name,cust_trx_type_id AR نوع ارتباط إلى D Bis Verpflichtungsart F Type de contrat - A US Commitment Type High ZHS 承付款类型上限 12 120 :p_end_date_low Date AR تاريخ من D Von Datum F Date - Du US Date Low ZHS 日期下限 13 130 :p_end_date_high Date AR تاريخ إلى D Bis Datum F Date - Au US Date High ZHS 日期上限 14 140 :p_gl_date_low Date AR تاريخ الأستاذ العام من D Von Buchungsdatum F Date GL - Du US GL Date Low ZHS GL 日期下限 15 150 :p_gl_date_high Date AR تاريخ الأستاذ العام إلى D Bis Buchungsdatum F Date GL - Au US GL Date High ZHS GL 日期上限 16 160 :p_trx_date_low Date AR تاريخ ارتباط من D Von Verpflichtungsdatum F Date de contrat - Du US Commitment Date Low ZHS 承付款日期下限 17 170 :p_trx_date_high Date AR تاريخ ارتباط من D Bis Verpflichtungsdatum F Date de contrat - Au US Commitment Date High ZHS 承付款日期上限 18 180 :p_currency_code_low 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 Von Währung F Code devise - De US Currency Code Low ZHS 币种代码下限 19 190 :p_currency_code_high 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 Bis Währung F Code devise - A US Currency Code High ZHS 币种代码上限 20 200 :p_level LOV Oracle AR_RAXCBR_FORMAT_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type='RAXCBR_FORMAT' order by meaning select meaning from fnd_lookup_values_vl where lookup_type = 'RAXCBR_FORMAT' and lookup_code = 'SUMMARY' Y AR مستوى الصيغة D Formatebene F Niveau de format US Format Level ZHS 格式层 21 210 :p_unbooked 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 select l.meaning from fnd_lookups l where l.lookup_type ='YES_NO' and l.lookup_code = 'N' AR إظهار الطلبات غير المحجوزة D Nicht gebuchte Aufträge anzeigen F Afficher les commandes non validées US Show Unbooked Orders ZHS 显示未登记的订单