ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4653869E053B46B63588994Y select e.request_id request_id, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, e.horizon_end_date horizon_end_date, e.message_name message_name, e.cust_ship_from_org_ext ship_from, e.cust_ship_to_ext ship_to, e.customer_item_ext customer_item, e.inventory_item inventory_item, e.item_detail_type item_detail_type, e.item_detail_subtype item_detail_subtype, e.item_detail_quantity item_detail_quantity, e.qty_type_code qty_type_code, e.interface_header_id interface_header_id, e.interface_line_id interface_line_id, e.schedule_header_id schedule_header_id, e.schedule_line_id schedule_line_id, e.start_date_time start_date_time, e.message_text message_text, e.order_header_id order_header_id, e.order_line_id order_line_id, e.exception_level exception_severity, e.creation_date creation_date, e.purge_status purge_status, oe.order_number order_number, oel.line_number order_line_num, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.sched_generation_date sched_generation_date, sch.cust_name_ext customer_name, e.schedule_line_number sch_line_num, oev.name order_type, RLM_RLMDPPSR_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPPSR_XMLP_PKG.cf_purge_eligibleformula(e.purge_status) CF_purge_eligible, RLM_RLMDPPSR_XMLP_PKG.cf_purge_statusformula(e.purge_status) CF_purge_status from rlm_demand_exceptions e, oe_order_headers_all oe, oe_order_lines_all oel, rlm_schedule_interface_hdr_v sch, oe_order_types_v oev where e.request_id is not null and e.order_header_id = oe.header_id(+) and e.schedule_header_id = sch.header_id(+) and e.order_line_id = oel.line_id(+) and oe.order_type_id = oev.order_type_id(+) and e.origin_table = sch.origin_table(+) and sch.ORG_ID = oe.ORG_ID and sch.ORG_ID = oel.ORG_ID &p_where_clause --order by 27 desc,30,32,31,2,33,1,22,8,19,35,29,34,28,3,4,5,6,7,9,10,11,12,13,14,15,16,17,18,21,23,24,25,26,20 ORDER BY 27 DESC,30 ASC,32 ASC,31 ASC,2 ASC,33 ASC,1 ASC,22 ASC,8 ASC,19 ASC RLM RLMPSRP_XML AR RLM تقرير استثناء شطب جداول إدارة الإصدار Application: إدارة بيانات الإصدار Source: تقرير استثناء شطب جداول إدارة الإصدار (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG D RLM Release Management: Pläne löschen - Ausnahmen Application: Release Management Source: Release Management: Pläne löschen - Ausnahmen (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG F RLM Etat d'exception des programmes de purge de la gestion des appels de livraison Application: Release Management Source: Etat d'exception des programmes de purge de la gestion des appels de livraison (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG US RLM Release Management Purge Schedule Exception Application: Release Management Source: Release Management Purge Schedule Exception Report (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG ZHS RLM 发放管理清除计划例外报表 Application: 发放管理 Source: 发放管理清除计划例外报表 (XML) Short Name: RLMPSRP_XML DB package: RLM_RLMDPPSR_XMLP_PKG BI Publisher &p_where_clause :cp_default_ou :m_2 :operating_unit :p_authorization :p_conc_request_id :p_customer :p_delete_beyond_days :p_execution_mode :p_issue_date_from :p_issue_date_to :p_org_id :p_request_id :p_schedule_ref_no :p_schedule_type :p_ship_to_address_id_from :p_ship_to_address_id_to :p_status :p_translator_code_from :p_translator_code_to :p_where_clause :p_where_clause1 1 10 :p_request_id Number US p_request_id 2 20 :p_execution_mode LOV Oracle RLM_EXECUTION_MODE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_EXECUTION_MODE' order by meaning AR طور التنفيذ D Ausführungsmodus F Mode d'exécution US Execution Mode ZHS 执行模式 3 30 :p_translator_code_from LOV Oracle RLM_CUST_EXT Y select translator_code id, translator_code value, null description from ece_tp_details etd where etd.rowid=(select min(etd1.rowid) from ece_tp_details etd1,hz_cust_accounts cust_acct,hz_cust_acct_sites_all acct_site where etd.translator_code=etd1.translator_code and etd1.document_type in ('C-SPSI','C-SSSI','PSQ','ASN','DSNO') and etd1.edi_flag='Y' and etd1.translator_code is not null and etd1.tp_header_id=acct_site.tp_header_id and cust_acct.cust_account_id=acct_site.cust_account_id) order by etd.translator_code AR الشريك التجاري من D Von Geschäftspartner F Partenaire commercial - De US Trading Partner From ZHS 贸易伙伴自 4 40 :p_translator_code_to LOV Oracle RLM_CUST_EXT Y select translator_code id, translator_code value, null description from ece_tp_details etd where etd.rowid=(select min(etd1.rowid) from ece_tp_details etd1,hz_cust_accounts cust_acct,hz_cust_acct_sites_all acct_site where etd.translator_code=etd1.translator_code and etd1.document_type in ('C-SPSI','C-SSSI','PSQ','ASN','DSNO') and etd1.edi_flag='Y' and etd1.translator_code is not null and etd1.tp_header_id=acct_site.tp_header_id and cust_acct.cust_account_id=acct_site.cust_account_id) order by etd.translator_code AR الشريك التجاري إلى D Bis Geschäftspartner F Partenaire commercial - A US Trading Partner To ZHS 贸易伙伴至 5 50 :p_customer LOV Oracle RLM_CUST_ID Y select cust_account_id id, party.party_name value, account_number description from hz_parties party,hz_cust_accounts cust_acct where cust_acct.party_id=party.party_id order by party.party_name AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 6 60 :p_ship_to_address_id_from LOV Oracle RLM_ADD_ID Y select acct_site.cust_acct_site_id id, ece_tp_location_code value, substr(loc.address1,1,30)||' '||substr(loc.city,1,20)||' '||substr(loc.state,1,8) description from hz_party_sites party_site,hz_locations loc,hz_cust_acct_sites acct_site,hz_cust_site_uses_all site_uses where acct_site.cust_acct_site_id=site_uses.cust_acct_site_id and site_uses.site_use_code='SHIP_TO' and site_uses.status='A' and acct_site.cust_account_id in ( select to_number(:$flex$.rlm_cust_id:null) from dual union select cust_account_id from hz_cust_acct_relate where related_cust_account_id=:$flex$.rlm_cust_id:null and ship_to_flag='Y' and status='A' and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A')) and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and site_uses.org_id=acct_site.org_id order by ece_tp_location_code AR الشحن إلى العنوان من D Von Lieferadresse F Adresse de livraison - De US Ship-To Address From ZHS 收货地址自 7 70 :p_ship_to_address_id_to LOV Oracle RLM_ADD_ID Y select acct_site.cust_acct_site_id id, ece_tp_location_code value, substr(loc.address1,1,30)||' '||substr(loc.city,1,20)||' '||substr(loc.state,1,8) description from hz_party_sites party_site,hz_locations loc,hz_cust_acct_sites acct_site,hz_cust_site_uses_all site_uses where acct_site.cust_acct_site_id=site_uses.cust_acct_site_id and site_uses.site_use_code='SHIP_TO' and site_uses.status='A' and acct_site.cust_account_id in ( select to_number(:$flex$.rlm_cust_id:null) from dual union select cust_account_id from hz_cust_acct_relate where related_cust_account_id=:$flex$.rlm_cust_id:null and ship_to_flag='Y' and status='A' and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A')) and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and site_uses.org_id=acct_site.org_id order by ece_tp_location_code AR الشحن إلى العنوان إلى D Bis Lieferadresse F Adresse de livraison - A US Ship-To Address To ZHS 收货地址至 8 80 :p_issue_date_from DateTime AR تاريخ إصدار الجدول من D Von Planausstellungsdatum F Date d'émission du programme - Du US Schedule Issue date From ZHS 计划发放日期自 9 90 :p_issue_date_to DateTime AR تاريخ إصدار الجدول إلى D Bis Planausstellungsdatum F Date d'émission du programme - Au US Schedule Issue date To ZHS 计划发放日期至 10 100 :p_schedule_type LOV Oracle RLM_SCHEDULE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_SCHEDULE_TYPE' order by meaning US p_schedule_type 11 110 :p_schedule_ref_no LOV Oracle RLM_SCHEDULE_INTERFACE Y select substr(origin_table,1,1) || to_char (header_id) id, schedule_reference_num value, sched_generation_date description from rlm_schedule_interface_hdr_v where (origin_table like 'I%' or (origin_table like 'S%' and process_status=5))and header_id=nvl(:parameter.number1:null,header_id) order by sched_generation_date desc AR رقم مرجع الجدول D Planreferenz-Nr. F Numéro de référence du programme US Schedule Reference Number ZHS 计划参考编号 12 120 :p_delete_beyond_days Number AR حذف أيام التأخير D Löschen nach Tagen F Supprimer les jours ultérieurs US Delete beyond Days ZHS 删除前保留的天数 13 130 :p_authorization 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 AR حذف الجدول الذي له صلاحيات D Pläne mit Genehmigungen löschen F Supprimer des programmes avec autorisations US Delete Schedules with Authorizations ZHS 根据授权删除计划 14 140 :p_status LOV Oracle RLM_STATUS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_STATUS' order by lookup_code AR موقف الجدول D Planstatus F Statut de programme US Schedule Status ZHS 计划状态