ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4710D51A9E05362FB09050512Y Select evt.title, evt.event_id, fnd_date.date_to_displaydate(evt.course_start_date,2) course_start_date, fnd_date.date_to_displaydate(evt.course_end_date,2) course_end_date, 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,del.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, decode(db.corespondent, 'S',db.delegate_contact_phone,null) student_number, decode(db.customer_id, null, decode(del2.last_name,null, null, del2.last_name||', '), decode(dlc2.last_name, null, null,dlc2.last_name||', '))|| decode(db.customer_id, null, decode(del2.title, null, null,del2.title||' '), decode(dlc2.title, null, null, dlc2.title||' '))|| decode (db.customer_id, null, del2.first_name, dlc2.first_name) contact_name, decode(db.corespondent, 'C',db.delegate_contact_phone,null) contact_number, avt.version_name activity_name, tbst.name enrollment_status, fl.finance_header_id, fh.payment_status_flag, OTA_OTARPREG_XMLP_PKG.cf_venueformula(evt.event_id) CF_venue, OTA_OTARPREG_XMLP_PKG.CP_venue_p CP_venue From ota_delegate_bookings db, ota_events_vl evt, ota_finance_lines fl, ota_finance_headers fh, per_all_people_f del, ( select substrb( PARTY.person_last_name,1,50) FIRST_NAME, substrb( PARTY.person_first_name,1,40) LAST_NAME, ORG_CONT.title TITLE, ORG_CONT.contact_number, 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, 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, ORG_CONT.contact_number, 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 ) dlc2, ota_booking_status_types_vl tbst, ( 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, ota_activity_versions acv, ota_activity_versions_tl avt, hr_all_organization_units org1, hr_all_organization_units org2 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.contact_id = dlc2.contact_id(+) and evt.activity_version_id = acv.activity_version_id(+) and db.organization_id = org1.organization_id(+) and db.customer_id = rcu.customer_id(+) and db.booking_id = fl.booking_id(+) and fl.finance_header_id = fh.finance_header_id(+) and org2.organization_id(+) = evt.training_center_id and db.event_id = evt.event_id and db.booking_status_type_id = tbst.booking_status_type_id and avt.activity_version_id(+) = acv.activity_version_id and avt.language(+) = userenv('LANG') and ((db.internal_booking_flag = 'Y' and (trunc(evt.course_start_date) between decode(del.last_name, null, del2.effective_start_date, del.effective_start_date) and decode(del.last_name, null,del2.effective_end_date, del.effective_end_date) ) and (trunc(evt.course_start_date) between decode(del2.last_name, null, del.effective_start_date, del2.effective_start_date) and decode(del2.last_name, null, del.effective_end_date, del2.effective_end_date) )) or db.internal_booking_flag = 'N') and evt.event_type NOT IN ('DEVELOPMENT','SESSION') and ota_admin_access_util.admin_can_access_object('CL',evt.event_id)='Y' and tbst.type in ('A','P') and org1.business_group_id(+) = :p_business_group_id and evt.business_group_id = :p_business_group_id &p_and order by nvl(del.order_name,del.full_name) OTA OTARPREG_XML AR OTA تقرير التسجيل (بتنسيق XML) Imported from BI Publisher Description: تقرير التسجيل Application: إدارة التعليم Source: تقرير التسجيل (بتنسيق XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG D OTA Registrierungen Imported from BI Publisher Description: Auswertung "Registrierungen" Application: Learning Management Source: Registrierungen (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG E OTA Registro Imported from BI Publisher Description: Informe de registro Application: Learning Management Source: Registro (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG F OTA Etat des inscriptions Imported from BI Publisher Description: Etat des inscriptions Application: Learning Management Source: Etat des inscriptions (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG I OTA Rapporto Registrazione Imported from BI Publisher Description: Rapporto Registrazione Application: Learning Management Source: Rapporto Registrazione (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG JA OTA 登録レポート Imported from BI Publisher Description: 登録レポート Application: Learning Management Source: 登録レポート(XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG KO OTA 등록 보고서 Imported from BI Publisher Description: 등록 보고서 Application: Learning Management Source: 등록 보고서(XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG PTB OTA Relatório de Registro Imported from BI Publisher Description: Relatório de Registro Application: Learning Management Source: Relatório de Registro (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG RU OTA Отчет о регистрации Imported from BI Publisher Description: Отчет о регистрации Application: Управление обучением Source: Отчет о регистрации (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG S OTA Registrering - rapport Imported from BI Publisher Description: Registrering - rapport Application: Learning Management Source: Registrering - rapport (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG TR OTA Kayıt Raporu Imported from BI Publisher Description: Kayıt Raporu Application: Eğitim Yönetimi Source: Kayıt Raporu (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG US OTA Registration Imported from BI Publisher Description: Registration Report Application: Learning Management Source: Registration Report (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG ZHS OTA 注册报表 Imported from BI Publisher Description: 注册报表 Application: Oracle Learning Management Source: 注册报表 (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG BI Publisher &p_and :c_business_group_name :c_event_title :c_report_subtitle :cp_course_end_date :cp_course_start_date :cp_current_date :cp_session_date :cp_venue :p_and :p_business :p_business_group_id :p_conc_request_id :p_course_end_date :p_course_start_date :p_event_id :p_event_name :p_event_type :p_report_title :p_session_date :p_training_center_id :p_training_center_name 1 -30 :p_business_group_id Number select ota_general.get_business_group_id from dual AR معرف مجموعة الأعمال معرف مجموعة الأعمال D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Identificador de grupo de trabajo F ID entité professionnelle ID entité professionnelle I Id business group Id del business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB ID do Grupo Funcional ID do Grupo Funcional RU Идентификатор бизнес-группы Идентификатор бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu No İş Grubu No US Business Group ID Business Group ID ZHS 业务组标识 业务组标识 2 -20 :p_session_date Char select fnd_date.date_to_canonical(sysdate) from dual AR تاريخ الدورة تاريخ الدورة D Sitzungsdatum Sitzungsdatum E Fecha de Sesión Fecha de sesión F Date de la session Date de la session I Data sessione Data della sessione JA セッション日付 セッション日付 KO 세션 일자 세션 일자 PTB Data da Sessão Data da Sessão RU Дата сессии Дата сессии S Lektionsdatum Lektionsdatum TR Ders Tarihi Ders Tarihi US Session Date Session Date ZHS 会话日期 会话日期 3 10 :p_event_id LOV Oracle OTA_REPORT_EVENT Y select evt_tl.event_id id, evt_tl.title value, null description from ota_events evt,ota_events_tl evt_tl,hr_all_organization_units org where evt.training_center_id=org.organization_id(+) and evt.event_id=evt_tl.event_id(+) and evt_tl.language(+)=userenv('LANG') and evt.business_group_id=ota_general.get_business_group_id and decode(evt.event_type,'SESSION',ota_admin_access_util.admin_can_access_object('CL',evt.parent_event_id),ota_admin_access_util.admin_can_access_object('CL',evt.event_id))='Y' order by value,description AR الفصل الدراسي عنوان الحدث D Schulung Veranstaltung E Clase Título de Evento F Session de cours Titre événement I Classe Titolo evento JA クラス イベント・タイトル KO 클래스 이벤트명 PTB Classe Título do Evento RU Класс Название события S Kurstillfälle Händelsenamn TR Sınıf Kurs Başlığı US Class Event Title ZHS 课 事件名称 4 20 :p_event_type LOV Oracle OTA_EVENT_TYPES Y select meaning id, meaning value, null description from hr_lookups where lookup_type='TRAINING_EVENT_TYPE' order by value,description AR نوع الفصل الدراسي نوع الحدث D Schulungsart Veranstaltungsart E Tipo de Clase Tipo de evento F Type de session de cours Type d'événement I Tipo classe Tipo di evento JA クラス・タイプ イベント・タイプ KO 클래스 유형 이벤트 유형 PTB Tipo de Classe Tipo de Evento RU Тип класса Тип события S Typ av kurstillfälle Händelsetyp TR Sınıf Tipi Kurs Tipi US Class Type Event Type ZHS 分类类型 事件类型 5 30 :p_training_center_id LOV Oracle OTA_REPORT_TRAINING_CENTERS Y select org.organization_id id, name value, null description from hr_all_organization_units org,hr_organization_information ori where org.business_group_id=ota_general.get_business_group_id and org.organization_id=ori.organization_id and ori.org_information_context='CLASS' and ori.org_information1='OTA_TC' order by value,description AR مركز التدريب مركز التدريب D Schulungsort Schulungsort E Centro de Formación Centro de formación F Centre de formation Centre de formation I Centro di formazione Centro di formazione JA 研修センター 研修センター KO 교육장 교육장 PTB Centro de Treinamento Centro de Treinamento RU Учебный центр Учебный центр S Utbildningscenter Utbildningscenter TR Eğitim Merkezi Eğitim Merkezi US Training Center Training Center ZHS 培训中心 培训中心 6 40 :p_course_start_date Date AR تاريخ بداية الفصل الدراسي تاريخ بداية الحدث D Schulungsbeginn Veranstaltungsbeginn E Fecha de Inicio de Clase Fecha de inicio de evento F Date de début de la session de cours Date de début de l'événement I Data inizio classe Data di inizio dell'evento JA クラス開始日 イベント開始日 KO 클래스 시작 일자 이벤트 시작 일자 PTB Data Inicial da Classe Data Inicial do Evento RU Дата начала класса Дата начала события S Startdatum för kurstillfälle Startdatum för händelse TR Sınıf Başlangıç Tarihi Kurs Başlangıç Tarihi US Class Start Date Event Start Date ZHS 课起始日期 事件起始日期 7 50 :p_course_end_date Date AR تاريخ نهاية الفصل الدراسي تاريخ نهاية الحدث D Schulungsende Veranstaltungsende E Fecha de Finalización de Clase Fecha de finalización de evento F Date de fin de la session de cours Date de fin de l'événement I Data fine classe Data di fine dell'evento JA クラス終了日 イベント終了日 KO 클래스 종료 일자 이벤트 종료 일자 PTB Data Final da Classe Data Final do Evento RU Дата окончания класса Дата окончания события S Slutdatum för kurstillfälle Slutdatum för händelse TR Sınıf Bitiş Tarihi Kurs Bitiş Tarihi US Class End Date Event End Date ZHS 课终止日期 事件终止日期