ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F35F3869E053B46B63588994 select ame_approver_type_pkg.getApproverDisplayName3(aprd.name) name ,aprd.approver_order_number order_number ,ame_approver_deviation_pkg.getreasonDescription(aprd.reason) reason ,to_char(aprd.effective_date,'YYYY-MM-DD"T"HH24:MI:SS') effective_date ,apprcategory.meaning apprcategory ,origsys.meaning origsystem ,aprd.display_name display_name ,aprd.authority authority ,(select meaning from fnd_lookups where lookup_type = 'AME_APPROVAL_STATUS' and lookup_code = aprd.approval_status ) approval_status ,actl.user_action_type_name action_type ,aprd.member_order_number member_order_number ,aprd.api_insertion api_insertion from ame_txn_approvers aprd ,fnd_lookups origsys ,fnd_lookups apprcategory ,ame_action_types_vl actl where temp_transactions_id = :transSequenceId and aprd.item_class = :tempItemClass and aprd.item_id = :itmid and origsys.lookup_type = 'FND_WF_ORIG_SYSTEMS' and origsys.lookup_code = aprd.orig_system and apprcategory.lookup_type = 'AME_APPROVER_CATEGORY' and apprcategory.lookup_code = aprd.approver_category and aprd.action_type_id = actl.action_type_id(+) and sysdate between nvl(actl.start_date,sysdate-(1/86400)) and nvl(actl.end_Date,sysdate) order by aprd.temp_transactions_id,aprd.approver_order_number Y PER AME_DEVIATION_RPT AR PER تقرير انحراف الاعتمادات Application: الموارد البشرية Source: تقرير انحراف الاعتمادات Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG D PER Genehmigungsabweichungen Application: Human Resources Source: Genehmigungsabweichungen Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG F PER Etat des changements apportés à la liste des approbateurs Application: Human Resources Source: Etat des changements apportés à la liste des approbateurs Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG US PER Approvals Deviation Application: Human Resources Source: Approvals Deviation Report Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG ZHS PER 审批偏差报表 Application: 人力资源管理系统 Source: 审批偏差报表 Short Name: AME_DEVIATION_RPT DB package: AME_APPROVER_DEVIATION_PKG BI Publisher :itmid :p_ameapplid :p_application :p_enddate :p_reason :p_startdate :p_txntypeid :temp_applid :temp_reason :tempitemclass :transsequenceid 1 10 :p_application LOV Oracle AME_APPLICATION_LIST Y select application_id id, application_name value, null description from fnd_application_tl where language=userenv('LANG') and exists (select null from ame_calling_apps aca where aca.fnd_application_id=fnd_application_tl.application_id and sysdate between start_date and nvl(end_date-(1/86400),sysdate)) order by value,description Y AR التطبيق D Anwendung US Application ZHS 申请 2 20 :p_ameapplid LOV Oracle AME_TXNTYPE_LIST Y select application_id id, application_name value, null description from ame_calling_apps_tl where application_id in (select application_id from ame_calling_apps where sysdate between start_date and nvl(end_date,sysdate) and fnd_application_id=:$flex$.ame_application_list ) and language=userenv('LANG') order by value,description Y AR نوع الحركة D Transaktionsart F Type de transaction US Transaction Type ZHS 事务处理类型 3 30 :p_startdate Date select fnd_date.date_to_displayDate(sysdate) from dual Y AR من تاريخ D Von Datum F Date de début US From Date ZHS 自日期 4 40 :p_enddate Date select fnd_date.date_to_displayDate(sysdate) from dual AR إلى تاريخ D Bis Datum F Date de fin US To Date ZHS 至日期 5 50 :p_reason LOV Oracle AME_DEV_REASONLIST Y select meaning id, meaning value, null description from fnd_lookup_values where lookup_type='AME_DEVIATION_REASON' and language=userenv('LANG') order by value,description AR نوع الانحراف D Abweichungsart F Type de changement US Deviation Type ZHS 偏差类型 :$flex$.ame_application_list Application Transaction Type