ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4710C51A9E05362FB09050512Y 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,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, db.booking_id registration_id, etl.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, avt.version_name, evt.duration, hr_general.decode_lookup ('FREQUENCY',evt.duration_units) duration_units, decode(db.customer_id,null,org1.name,rcu.customer_name) company, hr_general.decode_lookup ('FINANCE_HEADER_TYPE', fh.type) finance_header_type, del.employee_number employee_id, db.delegate_person_id person_id, OTA_OTARPATT_XMLP_PKG.cf_yes_no_meaning(decode(db.internal_booking_flag, 'N', decode(lns.flow_status_code,'ENTERED','N',nvl(hld.released_flag,'Y')), 'Y', decode(fl.finance_line_id, null, null, 'Y'))) pmt_confirmed, fl.finance_line_id, ftv.TERRITORY_SHORT_NAME, OTA_OTARPATT_XMLP_PKG.cf_optional_columnformula() CF_OPTIONAL_COLUMN, OTA_OTARPATT_XMLP_PKG.cf_venueformula(evt.event_id) CF_venue /* Commented during DT Fixes OTA_OTARPATT_XMLP_PKG.cf_venueformula(evt.event_id) CF_venue, OTA_OTARPATT_XMLP_PKG.CP_venue_p CP_venue End of DT Fix Comment */ From ota_events evt, ota_events_tl etl, ota_activity_versions_tl avt, ota_activity_versions acv, ota_delegate_bookings db, per_all_people_f del, (select substrb( PARTY.person_last_name,1,50) LAST_NAME, substrb( PARTY.person_first_name,1,40) FIRST_NAME, party.person_pre_name_adjunct 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, hr_all_organization_units org1, hr_all_organization_units org2, ota_finance_lines fl, ota_finance_headers fh, per_all_people_f del2, ( select substrb( PARTY.person_last_name,1,50) LAST_NAME, substrb( PARTY.person_first_name,1,40) FIRST_NAME, party.person_pre_name_adjunct 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 ) dlc2, ( Select substrb(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_booking_status_types bst, oe_hold_definitions hdf, oe_hold_sources_all hsrc, oe_order_holds_all hld, oe_order_lines_all lns, FND_TERRITORIES_VL ftv, HR_LOCATIONS_ALL loc Where evt.activity_version_id = acv.activity_version_id(+) and fl.finance_header_id = fh.finance_header_id(+) and fl.booking_id(+) = db.booking_id and db.organization_id = org1.organization_id(+) and db.customer_id = rcu.customer_id(+) and db.event_id = evt.event_id and 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.location_id =loc.location_id(+) and loc.country = ftv.territory_code(+) 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 db.booking_status_type_id = bst.booking_status_type_id and (hld.order_hold_id = (select max(order_hold_id) from oe_hold_sources_all hsrc2, oe_order_holds_all hld2 where hsrc2.hold_source_id = hld2.hold_source_id and hld2.header_id = hld.header_id and hsrc2.hold_id = hsrc.hold_id) or nvl(hdf.name, 'X') not in ('Credit Card Auth Failure', 'Credit Check Failure')) and hdf.hold_id (+) = hsrc.hold_id and hsrc.hold_source_id (+) = hld.hold_source_id and hld.header_id (+) = lns.header_id and lns.line_id (+) = db.line_id and org2.organization_id(+) = evt.training_center_id and evt.event_type NOT IN ('DEVELOPMENT', 'SESSION') and bst.type = 'P' and evt.business_group_id = :p_business_group_id and ota_admin_access_util.admin_can_access_object('CL',evt.event_id)='Y' and etl.event_id = evt.event_id and etl.language = Userenv('LANG') and avt.activity_version_id = acv.activity_version_id and avt.language = userenv('LANG') &p_and ORDER BY nvl(del.order_name,del.full_name), company, employee_id OTA OTARPATT_XML AR OTA تقرير ورقة توقيع الحضور (بتنسيق XML) Imported from BI Publisher Description: تقرير ورقة توقيع الحضور Application: إدارة التعليم Source: تقرير ورقة توقيع الحضور (بتنسيق XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG D OTA Anwesenheitsliste Imported from BI Publisher Description: Anwesenheitsliste Application: Learning Management Source: Anwesenheitsliste (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG E OTA Hoja de Firmas y Asistencia Imported from BI Publisher Description: Informe Hoja de Firmas y Asistencia Application: Learning Management Source: Hoja de Firmas y Asistencia (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG F OTA Etat des feuilles d'émargement Imported from BI Publisher Description: Etat des feuilles d'émargement Application: Learning Management Source: Etat des feuilles d'émargement (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG I OTA Rapporto Foglio firme partecipazione Imported from BI Publisher Description: Rapporto Foglio firme partecipazione Application: Learning Management Source: Rapporto Foglio firme partecipazione (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG JA OTA 出席署名シート・レポート Imported from BI Publisher Description: 出席署名シート・レポート Application: Learning Management Source: 出席署名シート・レポート(XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG KO OTA 출석부 보고서 Imported from BI Publisher Description: 출석부 보고서 Application: Learning Management Source: 출석부 보고서(XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG PTB OTA Relatório da Planilha de Assinaturas e Presença Imported from BI Publisher Description: Relatório da Planilha de Assinaturas e Presença Application: Learning Management Source: Relatório da Planilha de Assinaturas e Presença (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG RU OTA Отчет по журналу регистрации посещений Imported from BI Publisher Description: Отчет по журналу регистрации посещений Application: Управление обучением Source: Отчет по журналу регистрации посещений (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG S OTA Närvarolista - rapport Imported from BI Publisher Description: Närvarolista - rapport Application: Learning Management Source: Närvarolista - rapport (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG TR OTA Katılımcı İmza Sayfası Raporu Imported from BI Publisher Description: Katılımcı İmza Sayfası Raporu Application: Eğitim Yönetimi Source: Katılımcı İmza Sayfası Raporu (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG US OTA Attendance Signature Sheet Imported from BI Publisher Description: Attendance Signature Sheet Report Application: Learning Management Source: Attendance Signature Sheet Report (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG ZHS OTA 出席签名表报表 Imported from BI Publisher Description: 出席签名表报表 Application: Oracle Learning Management Source: 出席签名表报表 (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_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_venue :lp_session_date :p_and :p_booking_id :p_business :p_business_group_id :p_conc_request_id :p_course_end_date :p_course_start_date :p_display_pmt_conf :p_display_pmt_conf_mean :p_display_trainer_sig_mean :p_display_trainer_signature :p_event_id :p_event_name :p_optional_column :p_report_title :p_session_date :p_trainer_and :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_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 培训中心 培训中心 5 30 :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 课起始日期 事件起始日期 6 40 :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 课终止日期 事件终止日期 7 50 :p_booking_id Number AR رقم التسجيل رقم التسجيل D Anmeldungsnummer Anmeldungsnummer E Número de Inscripción Número de inscripción F Numéro d'inscription Numéro d'inscription I Numero iscrizione Numero di iscrizione JA 登録番号 登録番号 KO 등록 번호 등록 번호 PTB Número da Inscrição Número da Inscrição RU Номер зачисления Номер зачисления S Anmälningsnummer Anmälningsnummer TR Kayıt Numarası Kayıt Numarası US Enrollment Number Enrollment Number ZHS 登记编号 登记编号 8 60 :p_optional_column Char AR عنوان العمود الاختياري عنوان العمود الاختياري D Optionaler Spaltentitel Optionaler Spaltentitel E Cabecera de Columna Opcional Cabecera de columna opcional F En-tête de colonne facultative En-tête de colonne facultative I Intestazione colonna facoltativa Intestazione di colonna facoltativa JA オプション列見出し オプション列見出し KO 선택 열 헤딩 선택 열 헤딩 PTB Cabeçalho da Coluna Opcional Cabeçalho da Coluna Opcional RU Заголовок дополнительного столбца Заголовок дополнительного столбца S Rubrik på valfri kolumn Rubrik på valfri kolumn TR İsteğe Bağlı Sütun Başlığı İsteğe Bağlı Sütun Başlığı US Optional Column Heading Optional Column Heading ZHS 可选列标题 可选列标题 9 70 :p_display_pmt_conf LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='Y' AR عرض تأكيد السداد عرض تأكيد السداد D Zahlungsbestätigung anzeigen Zahlungsbestätigung anzeigen E Mostrar Confirmación de Pago Mostrar confirmación de pago F Afficher la confirmation du règlement Afficher la confirmation du règlement I Visualizza conferma pagamento Visualizza la conferma di pagamento JA 支払確認の表示 支払確認の表示 KO 지급 확정 표시 지급 확정 표시 PTB Exibir Confirmação de Pagamento Exibir Confirmação de Pagamento RU Вывод подтверждения оплаты Вывод подтверждения оплаты S Visa betalningsbekräftelse Visa betalningsbekräftelse TR Ödeme Teyidini Görüntüle Ödeme Teyidini Görüntüle US Display Payment Confirmation Display Payment Confirmation ZHS 显示付款确认 显示付款确认 10 80 :p_display_trainer_signature LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type='YES_NO' and lookup_code='N' AR عرض توقيع المدرب عرض توقيع المدرب D Dozentenunterschrift anzeigen Dozentenunterschrift anzeigen E Mostrar Firma del Formador Mostrar firma del formador F Afficher la signature du formateur Afficher la signature du formateur I Visualizza firma istruttore Visualizza la firma dell'istruttore JA 講師署名の表示 講師署名の表示 KO 강사 서명 표시 강사 서명 표시 PTB Exibir Assinatura do Instrutor Exibir Assinatura do Instrutor RU Вывод подписи инструктора Вывод подписи инструктора S Visa lärarens underskrift Visa lärarens underskrift TR Eğitmen İmzasını Görüntüle Eğitmen İmzasını Görüntüle US Display Trainer Signature Display Trainer Signature ZHS 显示培训人签名 显示培训人签名