ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2823869E053B46B63588994Y SELECT uudp.project_number,uudp.project_type,uudp.draft_revenue_num, uudp.gl_period,uudp.revenue_amount,uudp.unbilled_receivables_amount, uudp.unearned_revenue_amount,uudp.gl_header_id,uudp.gl_line_num FROM pa_ubr_uer_dr_prj_v uudp WHERE uudp.request_id = :p_conc_request_id ORDER BY uudp.project_number,uudp.draft_revenue_num PA PAUBRUER_XML AR PA عملية إعداد إجمالي أرصدة المقبوضات غير المفوترة/الإيرادات غير المكتسبة (بتنسيق XML) Application: المشروعات Source: PRC: عملية إعداد إجمالي أرصدة المقبوضات غير المفوترة/الإيرادات غير المكتسبة (بتنسيق XML) Short Name: PAUBRUER_XML DB package: PA_PAUBRUER_XMLP_PKG D PA Salden für nicht fakturierte Forderungen/nicht geleisteten Umsatz zusammenfassen Application: Projects Source: PA: Salden für nicht fakturierte Forderungen/nicht geleisteten Umsatz zusammenfassen (XML) Short Name: PAUBRUER_XML DB package: PA_PAUBRUER_XMLP_PKG F PA Traitement Synthétiser les soldes des factures à établir/des avances Application: Projects Source: PRC : Traitement Synthétiser les soldes des factures à établir/des avances (XML) Short Name: PAUBRUER_XML DB package: PA_PAUBRUER_XMLP_PKG US PA Summarize Unbilled Receivables/Unearned Revenue Balances Process Application: Projects Source: PRC: Summarize Unbilled Receivables/Unearned Revenue Balances Process (XML) Short Name: PAUBRUER_XML DB package: PA_PAUBRUER_XMLP_PKG ZHS PA PRC：汇总未开单应收款/未实现收入余额流程 Application: 项目 Source: PRC：汇总未开单应收款/未实现收入余额流程 (XML) Short Name: PAUBRUER_XML DB package: PA_PAUBRUER_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_error_buf :c_no_data_found :c_retcode :curr_code :operating_unit :p_conc_request_id :p_debug_mode :p_from_project_number :p_gl_period_name :p_to_project_number 1 10 :p_from_project_number Char AR من رقم المشروع D Von Projektnummer F Du numéro de projet US From Project Number ZHS 自项目编号 2 20 :p_to_project_number Char AR إلى رقم المشروع D Bis Projektnummer F Au numéro de projet US To Project Number ZHS 至项目编号 3 30 :p_gl_period_name LOV Oracle PA_SRS_GL_PERIODS Y Y select c.period_name id, c.period_name value, null description from pa_implementations a,gl_sets_of_books b,gl_periods c where a.set_of_books_id=b.set_of_books_id and b.period_set_name=c.period_set_name and b.accounted_period_type=c.period_type order by c.end_date SELECT gps.period_name Gl_Period_Name FROM gl_period_statuses gps, pa_implementations pi WHERE pi.set_of_books_id = gps.set_of_books_id AND gps.application_id = 101 AND TO_DATE(SYSDATE) between start_date and end_date ORDER BY Gl_Period_Name Y AR فترة الأستاذ العام D RW-Periode F Période GL US GL Period ZHS GL 期间