ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FD051A9E05362FB09050512Y SELECT to_char(to_date(trunc(start_time),'DD-MM-YY')) start_time, to_char(to_date(trunc(stop_time),'DD-MM-YY')) stop_time, person_name, person_number, resource_id1, payroll_id, assignment_id, organization_id, organization_name, location_code, payroll_name, supervisor_id, supervisor_name, vendor_name, approval_status, application_name, application_id, count , archived FROM ( select distinct trunc(htb_timecard.start_time) start_time, trunc(htb_timecard.stop_time) stop_time, hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to) person_name, DECODE(paf.assignment_type,'E',ppf.employee_number, 'C', ppf.npw_number, nvl(ppf.employee_number,ppf.npw_number)) person_number, ppf.person_id resource_id1, paf.payroll_id payroll_id, paf.assignment_id assignment_id, paf.organization_id organization_id, hxc_tpd_end.get_org_name(paf.organization_id) organization_name, hxc_tpd_end.get_locn_name(paf.location_id) location_code, hxc_tpd_end.get_payroll_name(paf.payroll_id) payroll_name, paf.supervisor_id supervisor_id, hxc_tpd_end.get_supervisor_name(paf.supervisor_id,htb_timecard.start_time) supervisor_name, hxc_missing_tcard_report.get_vendor_name(:p_date_from,:p_date_to,paf.person_id) vendor_name, htb_timecard.approval_status approval_status, hasc.time_recipient_name application_name, hasc.time_recipient_id application_id, 0 count, hxc_tpd_end.return_archived_status(htb_timecard.stop_time) Archived from hxc_timecard_summary htb_timecard, hxc_application_set_comps_v hasc, hxc_application_sets_v hasv, per_person_types ppt, per_person_type_usages_f ptu, per_assignment_status_types past, per_assignments_f paf, per_people_f ppf where ppf.business_group_id = :p_business_group_id &person_condition and ptu.person_id = ppf.person_id -- ppf doesnt contain all types -- and ptu.person_type_id = ppf.person_type_id and ptu.effective_start_date <= :p_date_to and ptu.effective_end_date >= :p_date_from and ppf.effective_start_date between ptu.effective_start_date and ptu.effective_end_date and ppt.person_type_id = ptu.person_type_id -- and ppt.system_person_type in ('EMP_APL','EMP','CWK') /* 4720480 */ &person_type3 /* 4720480 */ &per_no_condition and paf.person_id = ppf.person_id and ppf.effective_start_date <= paf.effective_end_date and ppf.effective_end_date >= paf.effective_start_date and ppf.effective_start_date= ( select max(ppf1.effective_start_date) from per_people_f ppf1 where ppf.person_id=ppf1.person_id and ppf.person_type_id=PPf1.person_type_id and ppf1.effective_start_date <= :p_date_to and ppf1.effective_end_date >= :p_date_from ) and paf.effective_start_date = (select max(effective_start_date) from per_assignments_f where assignment_id = paf.assignment_id and effective_start_date <= trunc(htb_timecard.start_time) and assignment_type <> 'B' and assignment_status_type_id = past.assignment_status_type_id) and paf.assignment_status_type_id = past.assignment_status_type_id and past.pay_system_status in ('P','D') and paf.assignment_type <> 'B' &locn_condition2 &org_condition2 &payroll_condition2 &sup_condition2 and hasv.application_set_id = hxc_tpd_end.check_appln_set(ppf.person_id, :p_date_from, :p_date_to, htb_timecard.start_time, htb_timecard.stop_time) and hasv.application_set_id = hasc.application_set_id and hasc.time_recipient_id = nvl(:p_application,hasc.time_recipient_id) and hxc_tpd_end.check_tc_required(ppf.person_id, :p_date_from, :p_date_to, htb_timecard.start_time, htb_timecard.stop_time, hasc.time_recipient_id ) = 'Y' and 'Y' = decode(:p_payroll_assignment_set, null, 'Y', hxc_missing_tcard_report.check_assignment_set (:p_payroll_assignment_set,paf.assignment_id)) and 'Y' = decode(:p_vendor_id, null, 'Y', hxc_missing_tcard_report.check_vendor_exists(:p_date_from,:p_date_to,paf.assignment_id,paf.person_id,:p_vendor_id)) and htb_timecard.resource_id = ppf.person_id and htb_timecard.start_time <= :p_date_to and htb_timecard.stop_time >= :p_date_from and :p_date_from <= :p_date_to and htb_timecard.start_time between paf.effective_start_date and paf.effective_end_date &assignment_type1 &status_condition AND ( :person_id1 = ppf.person_id) AND ( :Assignment_Id1 = paf.assignment_id) AND ( :Application_Id1 = hasc.time_recipient_id) UNION ALL select distinct to_date('01/01/1900','dd/mm/yyyy') start_time, to_date('01/01/1900','dd/mm/yyyy') stop_time, hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to) person_name, DECODE(paf.assignment_type,'E',ppf.employee_number, 'C', ppf.npw_number, nvl(ppf.employee_number, ppf.npw_number)) person_number, ppf.person_id resource_id1, -- paf.supervisor_id supervisor_id, paf.payroll_id payroll_id, paf.assignment_id assignment_id, paf.organization_id organization_id, hxc_tpd_end.get_org_name(paf.organization_id) organization_name, hxc_tpd_end.get_locn_name(paf.location_id) location_code, hxc_tpd_end.get_payroll_name(paf.payroll_id) payroll_name, paf.supervisor_id supervisor_id, hxc_tpd_end.get_supervisor_name(paf.supervisor_id,:p_date_from) supervisor_name, hxc_missing_tcard_report.get_vendor_name(:p_date_from,:p_date_to,paf.person_id), 'NOT ENTERED' approval_status, hasc.time_recipient_name application_name, hasc.time_recipient_id application_id, hxc_tpd_end.populate_missing_time_periods(ppf.person_id, paf.assignment_id, :p_date_from, :p_date_to, hasv.application_set_id, hasc.time_recipient_id) count, NULL Archived from hxc_application_set_comps_v hasc, hxc_application_sets_v hasv, per_person_types ppt, per_person_type_usages_f ptu, per_assignment_status_types past, per_assignments_f paf, per_people_f ppf where ppf.business_group_id = :p_business_group_id &person_condition and ptu.person_id = ppf.person_id and ptu.effective_start_date <= :p_date_to and ptu.effective_end_date >= :p_date_from and ppf.effective_start_date between ptu.effective_start_date and ptu.effective_end_date and ppt.person_type_id = ptu.person_type_id -- and ppt.system_person_type in ('EMP_APL','EMP','CWK') /* 4720480 */ &person_type3 /* 4720480 */ &per_no_condition and paf.person_id = ppf.person_id and ppf.effective_start_date <= paf.effective_end_date and ppf.effective_end_date >= paf.effective_start_date and ppf.effective_start_date= ( select max(ppf1.effective_start_date) from per_people_f ppf1 where ppf.person_id=ppf1.person_id and ppf.person_type_id=PPf1.person_type_id and ppf1.effective_start_date <= :p_date_to and ppf1.effective_end_date >= :p_date_from and ppf1.person_id = ptu.person_id and ppf1.effective_start_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date ) and paf.effective_start_date = (select max(effective_start_date) from per_assignments_f where assignment_id = paf.assignment_id and effective_start_date <= :p_date_to and effective_end_date >= :p_date_from and assignment_type <> 'B' and assignment_status_type_id=past.assignment_status_type_id) and paf.assignment_status_type_id = past.assignment_status_type_id and past.pay_system_status in ('P','D') and paf.assignment_type <> 'B' &locn_condition2 &org_condition2 &payroll_condition2 &sup_condition2 and hasv.application_set_id = hasc.application_set_id and hasc.time_recipient_id = nvl(:p_application,hasc.time_recipient_id) and 'Y' = decode(:p_payroll_assignment_set, null, 'Y', hxc_missing_tcard_report.check_assignment_set (:p_payroll_assignment_set,paf.assignment_id)) and 'Y' = decode(:p_vendor_id, null, 'Y', hxc_missing_tcard_report.check_vendor_exists(:p_date_from,:p_date_to,paf.assignment_id,paf.person_id,:p_vendor_id)) and :p_date_from <= :p_date_to and hxc_tpd_end.check_appln_set_id(ppf.person_id, :p_date_from, :p_date_to, hasv.application_set_id) = 'Y' &assignment_type1 AND ( :person_id1 = ppf.person_id) AND (:Assignment_Id1 = paf.assignment_id) AND ( :Application_Id1 = hasc.time_recipient_id) ) result where HXC_HXCMISTC_XMLP_PKG.G_START_TIMEGROUPFILTER_2(approval_status, count, resource_id1) = 1 HXC HXCMISTC_XML AR HXC تقرير بطاقة قيد الوقت غير الموجودة Imported from BI Publisher Description: تقرير بطاقة قيد الوقت غير الموجودة في OTL Application: محرك الوقت والعمالة Source: تقرير بطاقة قيد الوقت غير الموجودة (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG D HXC Fehlende Stundennachweise Imported from BI Publisher Description: OTL Auswertung "Fehlende Stundennachweise" Application: Time & Labor-Engine Source: Fehlende Stundennachweise (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG E HXC Ficha de Horas que Falta Imported from BI Publisher Description: OTL: Informe de ficha de horas que falta Application: Sistema de Oracle Time and Labor Source: Ficha de Horas que Falta (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG F HXC Etat Feuilles de temps manquantes Imported from BI Publisher Description: Etat des feuilles de temps manquantes OTL Application: Moteur Time and Labor Source: Etat Feuilles de temps manquantes (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG I HXC Rapporto Foglio ore mancante(1) Imported from BI Publisher Description: OTL: rapporto Foglio ore mancante (1) Application: Time and Labor Engine Source: Rapporto Foglio ore mancante(1) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG JA HXC 欠落タイムカード・レポート Imported from BI Publisher Description: OTL欠落タイムカード・レポート Application: Time and Labor Engine Source: 欠落タイムカード・レポート(XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG KO HXC 누락된 근무 기록 카드 보고서 Imported from BI Publisher Description: OTL 누락된 근무 기록 카드 보고서 Application: Time and Labor 엔진 Source: 누락된 근무 기록 카드 보고서 (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG PTB HXC Relatório de Cartão de Ponto Ausente Imported from BI Publisher Description: OTL - Relatório de Cartão de Ponto Ausente Application: Mecanismo do Time and Labor Source: Relatório de Cartão de Ponto Ausente (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG RU HXC Отчет об отсутствующих карточках табельного учета Imported from BI Publisher Description: Отчет об отсутствующих карточках табельного учета ПРВ Application: Ядро Oracle Time and Labor Source: Отчет об отсутствующих карточках табельного учета (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG S HXC Saknad tidrapport Imported from BI Publisher Description: OTL: Saknad tidrapport Application: Time and Labor Engine Source: Saknad tidrapport (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG TR HXC Eksik Zaman Çizelgesi Raporu Imported from BI Publisher Description: OTL Eksik Zaman Çizelgesi Raporu Application: Zaman ve İşgücü Yönetimi Altyapısı Source: Eksik Zaman Çizelgesi Raporu (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG US HXC Missing Timecard Imported from BI Publisher Description: OTL Missing Timecard Report Application: Time and Labor Engine Source: Missing Timecard Report (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG ZHS HXC 缺少工时记录卡报表 Imported from BI Publisher Description: OTL 缺少工时记录卡报表 Application: 时间和人工引擎 Source: 缺少工时记录卡报表 (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG BI Publisher &assignment_type1 &locn_condition2 &org_condition2 &payroll_condition2 &per_no_condition &person_condition &person_type3 &status_condition &sup_condition2 :application_id1 :assignment_id1 :assignment_type1 :col_1 :col_2 :col_3 :col_4 :locn_condition :locn_condition2 :opt_hint :opt_hint2 :org_condition :org_condition2 :p_application :p_application_label :p_assignment_set_label :p_assignment_type :p_assignment_type_label :p_business_group_id :p_conc_request_id :p_date_from :p_date_to :p_debug :p_define_label :p_define_missing :p_location :p_location_label :p_organization :p_organization_label :p_payroll :p_payroll_assignment_set :p_payroll_label :p_person_name :p_person_name_label :p_person_number :p_person_number_label :p_person_type :p_person_type_label :p_select_condition :p_select_condition2 :p_select_condition3 :p_sort1_label :p_sort2_label :p_sort3_label :p_sort4_label :p_sort_option1 :p_sort_option2 :p_sort_option3 :p_sort_option4 :p_supervisor :p_supervisor_label :p_vendor_id :p_vendor_label :payroll_condition :payroll_condition2 :per_no_condition :person_condition :person_id1 :person_type1 :person_type2 :person_type3 :status_condition :sup_condition :sup_condition2 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y 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 10 :p_date_from Date Y US PER_DATES 3 20 :p_date_to Date Y US PER_DATES_STANDARD 4 30 :p_define_missing LOV Oracle HXC_DEFINE_MISSING Y select hl.lookup_code id, hl.meaning value, null description from hxc_lookups hl where hl.lookup_type='HXC_DEFINE_MISSING' order by value,description Y AR تحديد 'غير موجود' تحديد بطاقات قيد الوقت غير الموجودة D Fehlende definieren Fehlende Stundennachweise definieren E Definir 'Que Falta' Definir fichas de horas que faltan F Définir "Manquant" Définir les feuilles de temps manquantes I Definisci 'mancante' Definisce i fogli ore mancanti JA 「欠落」の定義 欠落タイムカードの定義 KO '누락' 정의 누락 근무 기록 카드 정의 PTB Definir 'Ausente' Definir Cartões de Ponto Ausentes RU Определение отсутствия Определение отсутствующих карточек табельного учета S Definiera saknade Definiera saknade tidrapporter TR 'Eksik' Olanı Tanımla Eksik Zaman Çizelgelerini Tanımla US Define 'Missing' Define Missing Timecards ZHS 定义“缺少” 定义缺少工时记录卡 5 40 :p_application LOV Oracle HXC_TIME_RECIPIENT Y select time_recipient_id id, name value, null description from hxc_time_recipients order by value,description AR طلب الوظيفة D Anwendung E Aplicación I Applicazione JA アプリケーション KO 애플리케이션 PTB Aplicação RU Заявка S Applikation TR Başvuru US Application ZHS 应用产品 6 50 :p_organization LOV Oracle HXC_ORGANIZATION Y select hou.organization_id id, hou.name value, null description from hr_organization_units hou,hr_organization_information hoi where hou.business_group_id= fnd_global.per_business_group_id and hou.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='HR_ORG' order by hou.name AR المنشأة D Organisation E Organización F Organisation I Organizzazione JA 組織 KO 조직 PTB Organização RU Организация S Organisation TR Organizasyon US Organization ZHS 组织 7 60 :p_location LOV Oracle HR_US_LOCATIONS Y select hl.location_id id, hl.location_code value, null description from hr_locations hl where location_use='HR' order by location_code AR الموقع D Standort E Ubicación F Lieu I Ubicazione JA 事業所 KO 국외근무처 PTB Local RU Расположение S Placering TR Yerleşim US Location ZHS 地点 8 70 :p_payroll_assignment_set LOV Oracle HXC_ASSIGNMENT_SET Y select has.assignment_set_id id, has.assignment_set_name value, null description from hr_assignment_sets has where has.business_group_id+0= fnd_global.per_business_group_id order by value,description AR مجموعة التعيين بكشف الرواتب D StellenSet Lohn- und Gehaltsabrechnung E Juego de Asignaciones de Nómina F Jeu d'affectations de paye I Serie di assegnazioni ciclo paghe JA 給与アサイメント・セット KO 급여 대상자 세트 PTB Conjunto de Atribuições da Folha de Pagamento RU Набор назначений ведомости S Lön: Anställningsgrupp TR Bordro Görev Kümesi US Payroll Assignment Set ZHS 工资单分配集 9 80 :p_payroll LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name AR اسم كشف الرواتب D Bezeichnung Lohn- und Gehaltsabrechnung E Nombre de Nómina F Nom de la paie I Nome ciclo paghe JA 給与 KO 급여명 PTB Nome da Folha de Pagamento RU Имя ведомости S Lönegrupp TR Bordro Adı US Payroll Name ZHS 工资单名称 10 90 :p_person_type LOV Oracle HXC_PERSON_TYPE Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where hl.lookup_type='HXC_PERSON_TYPES' and hl.enabled_flag='Y' order by hl.lookup_code select meaning from hr_lookups where lookup_type = 'HXC_PERSON_TYPES' and lookup_code = 'EMP_CWK' AR نوع الشخص D Personenart E Tipo de Persona F Type de personne I Tipo di persona JA Personタイプ KO 개인 유형 PTB Tipo de Pessoa RU Тип лица S Persontyp TR Kişi Tipi US Person Type ZHS 人员类型 11 100 :p_supervisor LOV Oracle HXC_US_PERSON Y Y select ppf.person_id id, ppf.full_name value, null description from per_people_f ppf,per_person_types ppt,per_person_type_usages_f ptu where ppf.business_group_id+0=fnd_global.per_business_group_id and ptu.person_id=ppf.person_id and ptu.effective_start_date=(select max(ptu2.effective_start_date) from per_person_type_usages_f ptu2 where ptu2.person_type_usage_id=ptu.person_type_usage_id) and ppt.person_type_id=ptu.person_type_id+0 and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL','CWK','EX_CWK') and ppf.effective_start_date=(select max(ppf1.effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) order by ppf.last_name,ppf.first_name AR اسم المشرف D Name Vorgesetzter E Nombre de Supervisor F Nom du supérieur hiérarchique I Nome supervisore JA 管理者名 KO 상위자명 PTB Nome do Supervisor RU Имя руководителя S Chef TR Yönetici Adı US Supervisor Name ZHS 主管姓名 12 110 :p_person_name LOV Oracle HXC_US_PERSON Y Y select ppf.person_id id, ppf.full_name value, null description from per_people_f ppf,per_person_types ppt,per_person_type_usages_f ptu where ppf.business_group_id+0=fnd_global.per_business_group_id and ptu.person_id=ppf.person_id and ptu.effective_start_date=(select max(ptu2.effective_start_date) from per_person_type_usages_f ptu2 where ptu2.person_type_usage_id=ptu.person_type_usage_id) and ppt.person_type_id=ptu.person_type_id+0 and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL','CWK','EX_CWK') and ppf.effective_start_date=(select max(ppf1.effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) order by ppf.last_name,ppf.first_name AR اسم الشخص D Personenname E Nombre de Persona F Nom de la personne I Nome persona JA 個人名 KO 개인명 PTB Nome da Pessoa RU Имя лица S Namn TR Kişi Adı US Person Name ZHS 人员姓名 13 120 :p_person_number LOV Oracle HXC_PERSON_NUMBER Y select ppf.person_id id, nvl(ppf.employee_number,ppf.npw_number) value, null description from per_people_f ppf,per_person_types ppt,per_person_type_usages_f ptu where ppf.business_group_id+0= fnd_global.per_business_group_id and ptu.person_id=ppf.person_id and ptu.effective_start_date= (select max(ptu2.effective_start_date) from per_person_type_usages_f ptu2 where ptu2.person_type_usage_id= ptu.person_type_usage_id) and ppt.person_type_id=ptu.person_type_id+0 and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL','CWK','EX_CWK') and ppf.effective_start_date= (select max(effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) order by ppf.last_name,ppf.first_name AR رقم الشخص D Personalnummer E Número de Persona F Numéro de personne I Numero persona JA 個人番号 KO 개인 번호 PTB Número da Pessoa RU Личный номер S Personnummer TR Kişi Numarası US Person Number ZHS 人员编号 14 130 :p_assignment_type LOV Oracle HXC_ASSIGNMENT_TYPES Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where hl.lookup_type='HXC_ASSIGNMENT_TYPES' and hl.enabled_flag='Y' order by hl.lookup_code select meaning from hr_lookups where lookup_type = 'HXC_ASSIGNMENT_TYPES' and lookup_code = 'ACTIVE' AR نوع التعيين D Stellenart E Tipo de Asignación F Type d'affectation I Tipo di assegnazione JA アサイメント・タイプ KO 지정 유형 PTB Tipo de Atribuição RU Тип назначения S Uppdragstyp TR Görev Tipi US Assignment Type ZHS 分配类型 15 140 :p_vendor_id LOV Oracle HXC_VENDORS_LIST Y select pov.vendor_id id, pov.vendor_name value, null description from po_vendors pov where exists (select '1' from per_assignments_f a,per_all_people_f pp where a.assignment_type='C' and a.person_id=pp.person_id and a.vendor_id=pov.vendor_id and to_date(:$flex$.per_dates,'YYYY/MM/DD HH24:MI:SS')<=a.effective_end_date and to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS')>=a.effective_start_date and to_date(:$flex$.per_dates,'YYYY/MM/DD HH24:MI:SS')<=pp.effective_end_date and to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS')>=pp.effective_start_date and a.vendor_id is not null ) order by value,description AR المُورَّد D Lieferant E Proveedor F Fournisseur I Fornitore JA 仕入先 KO 공급자 PTB Fornecedor RU Поставщик S Leverantör TR Tedarikçi US Supplier ZHS 供应商 16 150 :p_sort_option1 LOV Oracle HXC_MISSING_TCARD_SORT_ONE Y select hl.lookup_code id, hl.meaning value, null description from hxc_lookups hl where hl.lookup_type='HXC_MISSING_TCARD_REP_SORT_BY' and enabled_flag='Y' order by hl.lookup_code AR خيار الفرز رقم واحد D Sortieroption 1 E Opción de Clasificación Uno F Première option de tri I Opzione di ordinamento 1 JA ソート・オプション1 KO 정렬 옵션 1 PTB Opção de Classificação Um RU Первый параметр сортировки S Sorteringsalternativ ett TR Sıralama Seçeneği Bir US Sort Option One ZHS 排序选项 1 17 160 :p_sort_option2 LOV Oracle HXC_MISSING_TCARD_SORT_TWO Y select hl.lookup_code id, hl.meaning value, null description from hxc_lookups hl where hl.lookup_type='HXC_MISSING_TCARD_REP_SORT_BY' and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_one and enabled_flag='Y' order by hl.lookup_code AR خيار الفرز رقم اثنين D Sortieroption 2 E Opción de Clasificación Dos F Deuxième option de tri I Opzione di ordinamento 2 JA ソート・オプション2 KO 정렬 옵션 2 PTB Opção de Classificação Dois RU Второй параметр сортировки S Sorteringsalternativ två TR Sıralama Seçeneği İki US Sort Option Two ZHS 排序选项 2 18 170 :p_sort_option3 LOV Oracle HXC_MISSING_TCARD_SORT_THREE Y select hl.lookup_code id, hl.meaning value, null description from hxc_lookups hl where hl.lookup_type='HXC_MISSING_TCARD_REP_SORT_BY' and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_one and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_two and enabled_flag='Y' order by hl.lookup_code AR خيار الفرز رقم ثلاثة D Sortieroption 3 E Opción de Clasificación Tres F Troisième option de tri I Opzione di ordinamento 3 JA ソート・オプション3 KO 정렬 옵션 3 PTB Opção de Classificação Três RU Третий параметр сортировки S Sorteringsalternativ tre TR Sıralama Seçeneği Üç US Sort Option Three ZHS 排序选项 3 19 180 :p_sort_option4 LOV Oracle HXC_MISSING_TCARD_SORT_FOUR Y select hl.lookup_code id, hl.meaning value, null description from hxc_lookups hl where hl.lookup_type='HXC_MISSING_TCARD_REP_SORT_BY' and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_one and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_two and hl.lookup_code<>:$flex$.hxc_missing_tcard_sort_three and enabled_flag='Y' order by hl.lookup_code AR خيار الفرز رقم أربعة D Sortieroption 4 E Opción de Clasificación Cuatro F Quatrième option de tri I Opzione di ordinamento 4 JA ソート・オプション4 KO 정렬 옵션 4 PTB Opção de Classificação Quatro RU Четвертый параметр сортировки S Sorteringsalternativ fyra TR Sıralama Seçeneği Dört US Sort Option Four ZHS 排序选项 4