ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEB33869E053B46B63588994 SELECT ps.invoice_currency_code Currency_Code, DECODE (:p_order_by ,'Adjustment Status',l2.meaning,NULL) Status_1, DECODE (:p_order_by,'Adjustment Name',rcvbl_trx.name,NULL) Name_1, DECODE (:p_order_by,'Creator',fndc.user_name,NULL) Created_By, cust.cust_account_id Customer_Id , substrb(party.party_name,1,50) Customer_Name, cust.account_number Customer_Number, trx.trx_number Invoice_Number, ra_cust_trx_types.name Type, ps.due_date Due_Date, l2.meaning Status, rcvbl_trx.name Name, l1.meaning Reason, fndc.user_name Entered_By, adj.approved_by Approved_By, TO_CHAR(adj.gl_date,'DD-MON-RR') GL_Date, DECODE(:p_curr_code,NULL , ROUND(adj.acctd_amount,2), adj.amount) Adjustment_Amount, ROUND(adj.acctd_amount,2) Adjustment_Amount_Func, AR_ARXCTA_XMLP_PKG.c_data_not_foundformula(ps.invoice_currency_code) C_DATA_NOT_FOUND, AR_ARXCTA_XMLP_PKG.c_currency_summary_labelformul(ps.invoice_currency_code) C_currency_summary_label, AR_ARXCTA_XMLP_PKG.c_status_summary_labelformula(ps.invoice_currency_code, DECODE ( :p_order_by , 'Adjustment Status' , l2.meaning , NULL )) C_status_summary_label, AR_ARXCTA_XMLP_PKG.c_name_summary_labelformula(ps.invoice_currency_code, DECODE ( :p_order_by , 'Adjustment Name' , rcvbl_trx.name , NULL )) C_name_summary_label, AR_ARXCTA_XMLP_PKG.c_creator_labelformula(ps.invoice_currency_code, DECODE ( :p_order_by , 'Creator' , fndc.user_name , NULL )) C_creator_label from ar_payment_schedules ps, hz_cust_accounts cust, hz_parties party, ar_receivables_trx rcvbl_trx, ra_cust_trx_types, ra_customer_trx trx, ar_adjustments adj, ar_lookups l1, ar_lookups l2, fnd_user fndc where adj.receivables_trx_id = rcvbl_trx.receivables_trx_id &lp_gl_date_low &lp_gl_date_high and adj.reason_code = l1.lookup_code(+) and l1.lookup_type(+) = 'ADJUST_REASON' and adj.payment_schedule_id = ps.payment_schedule_id and ps.invoice_currency_code = DECODE(:p_curr_code,NULL, ps.invoice_currency_code, :p_curr_code) and ps.customer_trx_id = trx.customer_trx_id and trx.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id &lp_invoice_low &lp_invoice_high &lp_adjustment_name_low &lp_adjustment_name_high &lp_invoice_type_low &lp_invoice_type_high &lp_customer_name_low &lp_customer_name_high &lp_customer_number_low &lp_customer_number_high and ps.customer_id = cust.cust_account_id and cust.party_id = party.party_id and adj.status= l2.lookup_code and l2.lookup_type = 'APPROVAL_TYPE' &lp_status_low &lp_status_high and adj.status != 'U' and adj.created_by = fndc.user_id &lp_created_by_low &lp_created_by_high &lp_order_by Y AR ARXCTA_XML AR AR تقرير اعتماد التعديل (بتنسيق XML) Application: المقبوضات Source: تقرير اعتماد التعديل (بتنسيق XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG D AR Korrekturen - Genehmigung Application: Debitoren Source: Korrekturen - Genehmigung (XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG F AR Etat Approbation des ajustements Application: Receivables Source: Etat Approbation des ajustements (XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG US AR Adjustment Approval Application: Receivables Source: Adjustment Approval Report (XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG ZHS AR 调整审批报表 Application: 应收帐款 Source: 调整审批报表 (XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG BI Publisher &lp_adjustment_name_high &lp_adjustment_name_low &lp_created_by_high &lp_created_by_low &lp_customer_name_high &lp_customer_name_low &lp_customer_number_high &lp_customer_number_low &lp_gl_date_high &lp_gl_date_low &lp_invoice_high &lp_invoice_low &lp_invoice_type_high &lp_invoice_type_low &lp_order_by &lp_status_high &lp_status_low :acct_bal_aprompt :lp_adjustment_name_high :lp_adjustment_name_low :lp_created_by_high :lp_created_by_low :lp_customer_name_high :lp_customer_name_low :lp_customer_number_high :lp_customer_number_low :lp_gl_date_high :lp_gl_date_low :lp_invoice_high :lp_invoice_low :lp_invoice_type_high :lp_invoice_type_low :lp_order_by :lp_status_high :lp_status_low :operating_unit :p_adjustment_name_high :p_adjustment_name_low :p_conc_request_id :p_created_by_high :p_created_by_low :p_curr_code :p_customer_name_high :p_customer_name_low :p_customer_number_high :p_customer_number_low :p_gl_date_high :p_gl_date_low :p_invoice_high :p_invoice_low :p_invoice_type_high :p_invoice_type_low :p_meaning :p_order_by :p_status_high :p_status_low :rp_company_name :rp_data_found :rp_func :rp_func_currency :rp_gl_date :rp_grand :rp_order_by :rp_report_name :rp_sum :rp_sumfor :rp_total 1 10 :p_order_by LOV Oracle AR_ARXCTA_SORT_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SORT_BY_ARXCTA' order by value,description Y AR ترتيب حسب D Sortieren nach F Tri par US Order By ZHS 排序依据 2 20 :p_adjustment_name_low LOV Oracle AR_ADJUSTMENTS_NAME Y select name id, name value, null description from ar_receivables_trx where type='ADJUST' order by name,receivables_trx_id AR اسم نشاط من D Von Vorgang F Nom d'événement - De US Activity Name Low ZHS 活动名称下限 3 30 :p_adjustment_name_high LOV Oracle AR_ADJUSTMENTS_NAME Y select name id, name value, null description from ar_receivables_trx where type='ADJUST' order by name,receivables_trx_id AR اسم نشاط إلى D Bis Vorgang F Nom d'événement - A US Activity Name 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 客户编号上限 8 80 :p_invoice_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 发票编号下限 9 90 :p_invoice_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 发票编号上限 10 100 :p_invoice_type_low LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name AR نوع الفاتورة من D Von Rechnungsart F Type de facture - De US Invoice Type Low ZHS 发票类型下限 11 110 :p_invoice_type_high LOV Oracle AR_INVOICE_TYPE Y select name id, name value, null description from ra_cust_trx_types order by name AR نوع الفاتورة إلى D Bis Rechnungsart F Type de facture - A US Invoice Type High ZHS 发票类型上限 12 120 :p_gl_date_low Date AR تاريخ الأستاذ العام من D Von Buchungsdatum F Date GL - Du US GL Date Low ZHS GL 日期下限 13 130 :p_gl_date_high Date AR تاريخ الأستاذ العام إلى D Bis Buchungsdatum F Date GL - Au US GL Date High ZHS GL 日期上限 14 140 :p_status_low LOV Oracle AR_ADJ_STATUS Y select l.meaning id, l.meaning value, null description from ar_lookups l where l.lookup_type='APPROVAL_TYPE' and l.lookup_code!='U' and l.enabled_flag='Y' and sysdate between nvl(l.start_date_active,sysdate) and nvl(l.end_date_active,sysdate) order by l.meaning,l.lookup_code AR الموقف من D Von Status F Statut - De US Status Low ZHS 状态下限 15 150 :p_status_high LOV Oracle AR_ADJ_STATUS Y select l.meaning id, l.meaning value, null description from ar_lookups l where l.lookup_type='APPROVAL_TYPE' and l.lookup_code!='U' and l.enabled_flag='Y' and sysdate between nvl(l.start_date_active,sysdate) and nvl(l.end_date_active,sysdate) order by l.meaning,l.lookup_code AR الموقف إلى D Bis Status F Statut - A US Status High ZHS 状态上限 16 160 :p_created_by_low LOV Oracle FND_USER(User Name) Y select user_name id, user_name value, null description from fnd_user order by value,description AR مُكَون بواسطة من D Von Erstellt von F Créé par - De US Created By Low ZHS 创建者下限 17 170 :p_created_by_high LOV Oracle FND_USER(User Name) Y select user_name id, user_name value, null description from fnd_user order by value,description AR مُكَون بواسطة إلى D Bis Erstellt von F Créé par - A US Created By High ZHS 创建者上限 18 180 :p_curr_code 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 币种