ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F26A3869E053B46B63588994Y Select decode(db.customer_id, null, decode(del.last_name,null,del2.last_name, del.last_name), dlc.last_name)||', '|| decode(db.customer_id, null, decode(del.last_name, null, decode(del2.title, null, null, del2.title||' '),decode(del.title, null, null,dlc.title||' ')), decode(dlc.title, null, null,dlc.title||' '))|| decode (db.customer_id, null, decode(del.first_name, null, del2.first_name, del.first_name), dlc.first_name) student_name, decode(db.customer_id, null, decode(del.last_name, null, del2.last_name, del.last_name), dlc.last_name) last_name, fl.transfer_status, -- fl.currency_code, fl.currency_code currency_code1, nvl(e.standard_price,0) standard_price, nvl(fl.money_amount,0) money_amount, fl.finance_line_id, -- e.event_id, e.event_id event_id1, OTA_OTARPBUD_XMLP_PKG.cf_conv_amountformula(:EVENT_ID, fl.currency_code, nvl ( fl.money_amount , 0 ), :CF_eff_date, :CF_currency_type) CF_conv, OTA_OTARPBUD_XMLP_PKG.CP_prev_event_p CP_prev_event, OTA_OTARPBUD_XMLP_PKG.CP_conv_p CP_conv From ota_delegate_bookings db, ota_events e, ota_finance_lines fl, ota_finance_headers fh, ota_activity_versions av, per_all_people_f del, per_all_people_f del2, (select substrb( PARTY.person_last_name,1,50) FIRST_NAME, substrb( PARTY.person_first_name,1,40) LAST_NAME, ORG_CONT.title TITLE, ACCT_ROLE.cust_account_role_id CONTACT_ID, ACCT_ROLE.cust_account_id CUSTOMER_ID from HZ_CUST_ACCOUNT_ROLES acct_role, HZ_PARTIES party, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS org_cont, HZ_PARTIES rel_party, HZ_CUST_ACCOUNTS role_acct where acct_role.party_id = rel.party_id and acct_role.role_type = 'CONTACT' and org_cont.party_relationship_id = rel.relationship_id and rel.subject_id = party.party_id and rel.party_id = rel_party.party_id and rel.subject_table_name = 'HZ_PARTIES' and rel.object_table_name = 'HZ_PARTIES' and acct_role.cust_account_id = role_acct.cust_account_id and role_acct.party_id = rel.object_id ) dlc, (Select substr(PARTY.party_name,1,50) CUSTOMER_NAME, CUST_ACCT.cust_account_id CUSTOMER_ID, CUST_ACCT. account_number CUSTOMER_NUMBER, CUST_ACCT.status STATUS From HZ_PARTIES party, HZ_CUST_ACCOUNTS cust_acct Where CUST_ACCT.party_id = PARTY.party_id ) rcu Where db.delegate_person_id = del.person_id(+) and db.delegate_contact_id = dlc.contact_id(+) and db.sponsor_person_id = del2.person_id(+) and db.customer_id = rcu.customer_id(+) and nvl(e.course_start_date, db.date_booking_placed) between nvl(del.effective_start_date, nvl(e.course_start_date, db.date_booking_placed)) and nvl(del.effective_end_date, nvl(e.course_start_date, db.date_booking_placed)) and db.booking_id = fl.booking_id(+) and e.activity_version_id = av.activity_version_id(+) and fl.finance_header_id = fh.finance_header_id(+) and fl.cancelled_flag <> 'Y' and e.event_id = db.event_id and (upper(fl.currency_code) like upper(:p_delegate_booking_currency||'%') or :p_delegate_booking_currency is null) and (upper(fl.transfer_status) like upper(:p_transfer_status||'%') or :p_transfer_status is null) and (e.standard_price <= nvl(:p_price,99999) or :p_price is null) and (upper(fh.payment_status_flag) like upper(:p_payment_status||'%') or :p_payment_status is null) and e.event_id=:event_id and ota_admin_access_util.admin_can_access_object('CL',e.event_id)='Y' OTA OTARPBUD_XML AR OTA تقرير تقسيم الموازنة والتكاليف (بتنسيق XML) Application: إدارة التعليم Source: تقرير تقسيم الموازنة والتكاليف (بتنسيق XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG D OTA Budget- und Kostenaufgliederung Application: Learning Management Source: Budget- und Kostenaufgliederung (XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG F OTA Etat de ventilation des coûts budgétaires Application: Learning Management Source: Etat de ventilation des coûts budgétaires (XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG US OTA Budget Costs Breakdown Application: Learning Management Source: Budget Costs Breakdown Report (XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG ZHS OTA 预算成本细分报表 Application: Oracle Learning Management Source: 预算成本细分报表 (XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG BI Publisher :c_activity_name :c_activity_version_name :c_business_group_name :c_event_title :c_program_name :c_report_subtitle :cf_currency_type :cf_eff_date :cp_conv :cp_conv1 :cp_cost_curr :cp_prev_event :cp_prev_event2 :cp_resource_booking_status :cp_rev_curr :cp_transfer_status :cp_venue :event_id :lp_session_date :p_activity_id :p_activity_version_id :p_business :p_business_group_id :p_conc_request_id :p_course_end_date :p_course_start_date :p_delegate_booking_currency :p_delegate_display_currency :p_display_mode :p_event_id :p_payment_status :p_price :p_program_id :p_report_title :p_resource_booking_currency :p_resource_booking_status :p_revenue_display_currency :p_session_date :p_transfer_status 1 10 :p_activity_id LOV Oracle OTA_ACTIVITY_TYPES Y select activity_id id, name value, null description from ota_activity_definitions_vl where business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_object('C',category_usage_id)='Y' order by value,description AR نوع النشاط D Fortbildungsart F Type d'activité US Activity Type ZHS 活动类型 2 20 :p_activity_version_id LOV Oracle OTA_ACTIVITY_VERSIONS Y select activity_version_id id, version_name value, null description from ota_activity_versions_vl tav,ota_activity_definitions_vl tad where tad.activity_id=nvl(:$flex$.ota_activity_types:null,tad.activity_id) and tad.activity_id=tav.activity_id and tad.business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_object('H',tav.activity_version_id)='Y' order by value,description AR البرنامج التدريبي D Kurs F Cours US Course ZHS 课程 3 30 :p_event_id LOV Oracle OTA_EVENT_LIST Y select evt_tl.event_id id, rpad(to_char(evt_tl.event_id),10,' ')||evt_tl.title value, null description from ota_events evt,ota_events_tl evt_tl,hr_all_organization_units org,ota_activity_versions_tl tav where org.organization_id(+)=evt.training_center_id and org.business_group_id(+)=evt.business_group_id and evt.event_id=evt_tl.event_id(+) and evt_tl.language=userenv('LANG') and tav.language=userenv('LANG') and evt.activity_version_id=tav.activity_version_id and evt.business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_object('H',tav.activity_version_id)='Y' and tav.activity_version_id=nvl(:$flex$.ota_activity_versions:null,tav.activity_version_id) order by evt.title AR الفصل الدراسي D Schulung F Session de cours US Class ZHS 课 4 40 :p_program_id LOV Oracle OTA_PROGRAM_LIST Y select event_id id, title value, null description from ota_events_vl where event_type='PROGRAMME' and business_group_id=ota_general.get_business_group_id order by value,description AR البرنامج D Programm F Programme US Program ZHS 方案 5 50 :p_transfer_status LOV Oracle OTA_TRANSFER_STATUS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='GL_TRANSFER_STATUS' order by value,description AR حالة التحويل D Transferstatus F Statut du transfert US Transfer Status ZHS 转移状态 6 60 :p_resource_booking_status LOV Oracle OTA_RES_BOOKING_STATUS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='RESOURCE_BOOKING_STATUS' order by value,description AR حالة تسجيل المورد D Buchungsstatus Ressource F Statut de réservation des ressources US Resource Booking Status ZHS 资源预订状态 7 70 :p_delegate_booking_currency LOV Oracle OTA_CURRENCIES Y select currency_code id, name value, null description from fnd_currencies_vl order by value,description AR عملة تسجيل الطالب D Teilnehmer Buchungswährung F Devise de réservation du stagiaire US Student Booking Currency ZHS 学员预订币种 8 80 :p_resource_booking_currency LOV Oracle OTA_CURRENCIES Y select currency_code id, name value, null description from fnd_currencies_vl order by value,description AR عملة تسجيل المورد D Ressourcen Buchungswährung F Devise de réservation des ressources US Resource Booking Currency ZHS 资源预订币种 9 90 :p_display_mode LOV Oracle OTA_SUMMARY_DISPLAY_MODE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_common_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR إجمالي العرض D Übersicht anzeigen? F Afficher la synthèse US Display Summary ZHS 显示汇总 10 100 :p_course_start_date Date AR تاريخ بداية الفصل الدراسي D Schulungsbeginn F Date de début de la session de cours US Class Start Date ZHS 课起始日期 11 110 :p_course_end_date Date AR تاريخ نهاية الفصل الدراسي D Schulungsende F Date de fin de la session de cours US Class End Date ZHS 课终止日期 12 120 :p_payment_status LOV Oracle OTA_PAYMENT_STATUS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description AR تم السداد D Zahlung geleistet F Règlement effectué US Payment Made ZHS 已付 13 130 :p_price Number AR سعر التسجيل القياسي D Standard-Anmeldungspreis F Prix d'inscription standard US Standard Enrollment Price ZHS 标准登记价格