ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B73869E053B46B63588994Y select r.revenue_status, decode(r.transfer_status_code, 'R', r.transfer_rejection_reason, nvl(trr.meaning,r.transfer_rejection_reason)) transfer_rejection_reason, lka.meaning action, r.pa_date,r.project_number,r.draft_revenue_num revenue_number,r.amount from pa_proj_revenue_view r ,pa_lookups lka ,pa_lookups lkb ,pa_lookups trr where trunc(r.pa_date) between :pa_date_low and :pa_date_high and r.pa_date >= to_date('19000101','YYYYMMDD') and r.transfer_status_code = nvl(:transfer_status,r.transfer_status_code) and r.transfer_status_code != decode(:include_acc_rev,'N','A', 'No', 'A', 'NO', 'A', 'nO', 'A', 'Z') and lkb.lookup_type(+)='INVOICE/REVENUE STATUS' and lkb.meaning = r.revenue_status and lka.lookup_type='REVENUE ACTIONS' and lka.lookup_code=lkb.lookup_code(+) and trr.lookup_type(+)='REVENUE DIST REJECTION CODE' and trr.lookup_code(+)=r.transfer_rejection_reason ORDER BY 1 ASC,r.pa_date,r.project_number,r.draft_revenue_num PA PAXPCRFD_XML AR PA تفاصيل تدفق الإيرادات (بتنسيق XML) Application: المشروعات Source: FLW: تفاصيل تدفق الإيرادات (بتنسيق XML) Short Name: PAXPCRFD_XML DB package: PA_PAXPCRFD_XMLP_PKG D PA Umsatzfluss - Details Application: Projects Source: ADF: Umsatzfluss - Details (XML) Short Name: PAXPCRFD_XML DB package: PA_PAXPCRFD_XMLP_PKG F PA Détail du flux du produit Application: Projects Source: FLW : Détail du flux du produit (XML) Short Name: PAXPCRFD_XML DB package: PA_PAXPCRFD_XMLP_PKG US PA Revenue Flow Detail Application: Projects Source: FLW: Revenue Flow Detail (XML) Short Name: PAXPCRFD_XML DB package: PA_PAXPCRFD_XMLP_PKG ZHS PA FLW：收入流程明细 Application: 项目 Source: FLW：收入流程明细 (XML) Short Name: PAXPCRFD_XML DB package: PA_PAXPCRFD_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_include :c_no_data_found :include_acc_rev :lpa_date_high :lpa_date_low :operating_unit :p_conc_request_id :p_debug_mode :p_rule_optimizer :pa_date_high :pa_date_low :transfer_status 1 10 :pa_date_low Date Y AR من تاريخ محاسبة المشروعات D Von PA-Datum F Date PA - Du US From PA Date ZHS 自 PA 日期 2 20 :pa_date_high Date Y AR إلى تاريخ محاسبة المشروعات D Bis PA-Datum F Date PA - Au US To PA Date ZHS 至 PA 日期 3 30 :transfer_status LOV Oracle PA_SRS_TRANSFER_STATUS Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='TRANSFER STATUS' order by meaning AR موقف تحويل الإيرادات D Status Umsatztransfer F Statut du transfert du produit US Revenue Transfer Status ZHS 收入传送状态 4 40 :include_acc_rev LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' AR تضمين الإيرادات المقبولة D Mit akzeptiertem Umsatz F Inclure le produit accepté US Include Accept Revenue ZHS 包括接受收入