ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4633869E053B46B63588994 SELECT e.exception_id exception_id, e.request_id request_id, substrb(e.cust_name_ext, 1, 60) customer_name, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, to_char(e.horizon_end_date,'DD-MON-YY') horizon_end_date, e.sched_generation_date sched_generation_date, e.schedule_line_number schedule_line_num, 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.cust_intermd_shipto_ext sched_intermd_shipto, e.cust_bill_to_ext sched_billto, e.cust_uom_ext sched_cust_uom, e.cust_job_number sched_cust_job, e.customer_prod_seq_num sched_cust_prod_seq, e.cust_model_serial_num sched_model_serial, TO_DATE(null) sched_request_date, TO_DATE(null) sched_schedule_date, e.item_detail_quantity sched_order_quantity, TO_DATE(null) sched_primary_quantity, TO_CHAR(null) sched_cust_po, TO_CHAR(null) sched_record_year, TO_CHAR(null) sched_prod_line, TO_CHAR(null) sched_dock_code, TO_NUMBER(null) oe_order_number, TO_NUMBER(null) order_type_id, TO_NUMBER(null) oe_line_number, TO_NUMBER(null) order_quantity, TO_DATE(null) order_request_date, TO_DATE(null) order_ship_date, TO_NUMBER(null) order_ship_quantity, TO_NUMBER(null) order_cancel_quantity, TO_CHAR(null) order_cust_po, TO_CHAR(null) order_record_year, TO_CHAR(null) order_cust_uom, TO_CHAR(null) order_prod_line, TO_CHAR(null) order_dock_code, TO_CHAR(null) order_prod_seq, TO_CHAR(null) order_cust_job, TO_CHAR(null) order_model_serial, NVL(msg.message_category,0) message_category, NVL(msg.message_category_desc, lu.meaning) message_category_desc, RLM_RLMDPDER_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPDER_XMLP_PKG.cf_schedule_purposeformula(e.schedule_purpose) CF_schedule_purpose, RLM_RLMDPDER_XMLP_PKG.cf_schedule_sourceformula(e.schedule_source) CF_schedule_source, RLM_RLMDPDER_XMLP_PKG.cf_order_typeformula(TO_NUMBER ( null )) CF_order_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_typeformula(e.item_detail_type) CF_item_detail_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_subtypeformula(e.item_detail_subtype) CF_item_detail_subtype, RLM_RLMDPDER_XMLP_PKG.cf_quantity_typeformula(e.qty_type_code) CF_quantity_type FROM rlm_demand_exceptions e, rlm_message_category_v msg, fnd_lookup_values lu WHERE e.order_header_id IS NULL AND e.order_line_id IS NULL AND e.interface_header_id IS NULL AND e.schedule_header_id IS NULL AND e.message_name = msg.message_name AND lu.lookup_type = 'RLM_MESSAGE_CATEGORY' AND lu.lookup_code = '1' AND lu.view_application_id = 0 AND lu.meaning = nvl(msg.message_category_desc, lu.meaning) &p_where_clause &p_where_clause2 UNION SELECT e.exception_id exception_id, e.request_id request_id, substrb(e.cust_name_ext, 1, 60) customer_name, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, to_char(e.horizon_end_date,'DD-MON-YY') horizon_end_date, e.sched_generation_date sched_generation_date, e.schedule_line_number schedule_line_num, 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.cust_intermd_shipto_ext sched_intermd_shipto, e.cust_bill_to_ext sched_billto, e.cust_uom_ext sched_cust_uom, e.cust_job_number sched_cust_job, e.customer_prod_seq_num sched_cust_prod_seq, e.cust_model_serial_num sched_model_serial, TO_DATE(null) sched_request_date, TO_DATE(null) sched_schedule_date, e.item_detail_quantity sched_order_quantity, TO_DATE(null) sched_primary_quantity, TO_CHAR(null) sched_cust_po, TO_CHAR(null) sched_record_year, TO_CHAR(null) sched_prod_line, TO_CHAR(null) sched_dock_code, TO_NUMBER(null) oe_order_number, TO_NUMBER(null) order_type_id, TO_NUMBER(null) oe_line_number, TO_NUMBER(null) order_quantity, TO_DATE(null) order_request_date, TO_DATE(null) order_ship_date, TO_NUMBER(null) order_ship_quantity, TO_NUMBER(null) order_cancel_quantity, TO_CHAR(null) order_cust_po, TO_CHAR(null) order_record_year, TO_CHAR(null) order_cust_uom, TO_CHAR(null) order_prod_line, TO_CHAR(null) order_dock_code, TO_CHAR(null) order_prod_seq, TO_CHAR(null) order_cust_job, TO_CHAR(null) order_model_serial, NVL(msg.message_category,0) message_category, NVL(msg.message_category_desc, lu.meaning) message_category_desc, RLM_RLMDPDER_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPDER_XMLP_PKG.cf_schedule_purposeformula(e.schedule_purpose) CF_schedule_purpose, RLM_RLMDPDER_XMLP_PKG.cf_schedule_sourceformula(e.schedule_source) CF_schedule_source, RLM_RLMDPDER_XMLP_PKG.cf_order_typeformula(TO_NUMBER ( null )) CF_order_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_typeformula(e.item_detail_type) CF_item_detail_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_subtypeformula(e.item_detail_subtype) CF_item_detail_subtype, RLM_RLMDPDER_XMLP_PKG.cf_quantity_typeformula(e.qty_type_code) CF_quantity_type FROM rlm_demand_exceptions e, rlm_message_category_v msg, fnd_lookup_values lu, rlm_schedule_headers_all rlm WHERE e.order_header_id IS NULL AND e.order_line_id IS NULL AND e.message_name = msg.message_name AND lu.lookup_type = 'RLM_MESSAGE_CATEGORY' AND lu.lookup_code = '1' AND lu.view_application_id = 0 AND lu.meaning = nvl(msg.message_category_desc, lu.meaning) and e.request_id = rlm.request_id and e.interface_header_id = rlm.interface_header_id and rlm.org_id = :CP_Org_id and rlm.process_status = 5 &p_where_clause &p_where_clause2 UNION SELECT e.exception_id exception_id, e.request_id request_id, substrb(e.cust_name_ext, 1, 60) customer_name, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, to_char(e.horizon_end_date,'DD-MON-YY') horizon_end_date, e.sched_generation_date sched_generation_date, e.schedule_line_number schedule_line_num, 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.cust_intermd_shipto_ext sched_intermd_shipto, e.cust_bill_to_ext sched_billto, e.cust_uom_ext sched_cust_uom, e.cust_job_number sched_cust_job, e.customer_prod_seq_num sched_cust_prod_seq, e.cust_model_serial_num sched_model_serial, TO_DATE(null) sched_request_date, TO_DATE(null) sched_schedule_date, e.item_detail_quantity sched_order_quantity, TO_DATE(null) sched_primary_quantity, TO_CHAR(null) sched_cust_po, TO_CHAR(null) sched_record_year, TO_CHAR(null) sched_prod_line, TO_CHAR(null) sched_dock_code, TO_NUMBER(null) oe_order_number, TO_NUMBER(null) order_type_id, TO_NUMBER(null) oe_line_number, TO_NUMBER(null) order_quantity, TO_DATE(null) order_request_date, TO_DATE(null) order_ship_date, TO_NUMBER(null) order_ship_quantity, TO_NUMBER(null) order_cancel_quantity, TO_CHAR(null) order_cust_po, TO_CHAR(null) order_record_year, TO_CHAR(null) order_cust_uom, TO_CHAR(null) order_prod_line, TO_CHAR(null) order_dock_code, TO_CHAR(null) order_prod_seq, TO_CHAR(null) order_cust_job, TO_CHAR(null) order_model_serial, NVL(msg.message_category,0) message_category, NVL(msg.message_category_desc, lu.meaning) message_category_desc, RLM_RLMDPDER_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPDER_XMLP_PKG.cf_schedule_purposeformula(e.schedule_purpose) CF_schedule_purpose, RLM_RLMDPDER_XMLP_PKG.cf_schedule_sourceformula(e.schedule_source) CF_schedule_source, RLM_RLMDPDER_XMLP_PKG.cf_order_typeformula(TO_NUMBER ( null )) CF_order_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_typeformula(e.item_detail_type) CF_item_detail_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_subtypeformula(e.item_detail_subtype) CF_item_detail_subtype, RLM_RLMDPDER_XMLP_PKG.cf_quantity_typeformula(e.qty_type_code) CF_quantity_type FROM rlm_demand_exceptions e, rlm_message_category_v msg, fnd_lookup_values lu, rlm_interface_headers_all rlm WHERE e.order_header_id IS NULL AND e.order_line_id IS NULL AND e.message_name = msg.message_name AND lu.lookup_type = 'RLM_MESSAGE_CATEGORY' AND lu.lookup_code = '1' AND lu.view_application_id = 0 AND lu.meaning = nvl(msg.message_category_desc, lu.meaning) and e.request_id = rlm.request_id and e.interface_header_id = rlm.header_id and rlm.org_id = :CP_Org_id &p_where_clause &p_where_clause2 UNION SELECT e.exception_id exception_id, e.request_id request_id, substrb(e.cust_name_ext, 1, 60) customer_name, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, to_char(e.horizon_end_date,'DD-MON-YY') horizon_end_date, e.sched_generation_date sched_generation_date, e.schedule_line_number schedule_line_num, 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.cust_intermd_shipto_ext sched_intermd_shipto, e.cust_bill_to_ext sched_billto, e.cust_uom_ext sched_cust_uom, e.cust_job_number sched_cust_job, e.customer_prod_seq_num sched_cust_prod_seq, e.cust_model_serial_num sched_model_serial, TO_DATE(null) sched_request_date, TO_DATE(null) sched_schedule_date, e.item_detail_quantity sched_order_quantity, TO_DATE(null) sched_primary_quantity, TO_CHAR(null) sched_cust_po, TO_CHAR(null) sched_record_year, TO_CHAR(null) sched_prod_line, TO_CHAR(null) sched_dock_code, oh.order_number oe_order_number, oh.order_type_id order_type_id, TO_NUMBER(null) oe_line_number, TO_NUMBER(null) order_quantity, TO_DATE(null) order_request_date, TO_DATE(null) order_ship_date, TO_NUMBER(null) order_ship_quantity, TO_NUMBER(null) order_cancel_quantity, TO_CHAR(null) order_cust_po, TO_CHAR(null) order_record_year, TO_CHAR(null) order_cust_uom, TO_CHAR(null) order_prod_line, TO_CHAR(null) order_dock_code, TO_CHAR(null) order_prod_seq, TO_CHAR(null) order_cust_job, TO_CHAR(null) order_model_serial, NVL(msg.message_category,0) message_category, NVL(msg.message_category_desc, lu.meaning) message_category_desc, RLM_RLMDPDER_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPDER_XMLP_PKG.cf_schedule_purposeformula(e.schedule_purpose) CF_schedule_purpose, RLM_RLMDPDER_XMLP_PKG.cf_schedule_sourceformula(e.schedule_source) CF_schedule_source, RLM_RLMDPDER_XMLP_PKG.cf_order_typeformula(TO_NUMBER ( null )) CF_order_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_typeformula(e.item_detail_type) CF_item_detail_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_subtypeformula(e.item_detail_subtype) CF_item_detail_subtype, RLM_RLMDPDER_XMLP_PKG.cf_quantity_typeformula(e.qty_type_code) CF_quantity_type FROM rlm_demand_exceptions e, oe_order_headers_all oh, rlm_message_category_v msg, fnd_lookup_values lu WHERE e.order_header_id IS NOT NULL AND e.order_line_id IS NULL AND oh.header_id(+) = e.order_header_id and oh.org_id = :CP_Org_id AND e.message_name = msg.message_name AND lu.lookup_type = 'RLM_MESSAGE_CATEGORY' AND lu.lookup_code = '1' AND lu.view_application_id = 0 AND lu.meaning = nvl(msg.message_category_desc, lu.meaning) &p_where_clause &p_where_clause1 UNION SELECT e.exception_id exception_id, e.request_id request_id, substrb(e.cust_name_ext, 1, 60) customer_name, e.ece_tp_translator_code trading_partner, e.ece_tp_location_code_ext tp_location, e.schedule_reference_num schedule_num, e.schedule_type schedule_type, e.schedule_purpose schedule_purpose, e.schedule_source schedule_source, e.horizon_start_date horizon_start_date, to_char(e.horizon_end_date,'DD-MON-YY') horizon_end_date, e.sched_generation_date sched_generation_date, e.schedule_line_number schedule_line_num, 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.cust_intermd_shipto_ext sched_intermd_shipto, e.cust_bill_to_ext sched_billto, e.cust_uom_ext sched_cust_uom, e.cust_job_number sched_cust_job, e.customer_prod_seq_num sched_cust_prod_seq, e.cust_model_serial_num sched_model_serial, TO_DATE(null) sched_request_date, TO_DATE(null) sched_schedule_date, e.item_detail_quantity sched_order_quantity, TO_DATE(null) sched_primary_quantity, TO_CHAR(null) sched_cust_po, TO_CHAR(null) sched_record_year, TO_CHAR(null) sched_prod_line, TO_CHAR(null) sched_dock_code, oh.order_number oe_order_number, oh.order_type_id order_type_id, ol.line_number oe_line_number, ol.ordered_quantity order_quantity, ol.request_date order_request_date, ol.schedule_ship_date order_ship_date, ol.shipped_quantity order_ship_quantity, ol.cancelled_quantity order_cancel_quantity, ol.cust_po_number order_cust_po, ol.industry_attribute1 order_record_year, ol.industry_attribute8 order_cust_uom, ol.customer_production_line order_prod_line, ol.customer_dock_code order_dock_code, ol.cust_production_seq_num order_prod_seq, ol.customer_job order_cust_job, ol.cust_model_serial_number order_model_serial, NVL(msg.message_category,0) message_category, NVL(msg.message_category_desc, lu.meaning) message_category_desc, RLM_RLMDPDER_XMLP_PKG.cf_schedule_typeformula(e.schedule_type) CF_schedule_type, RLM_RLMDPDER_XMLP_PKG.cf_schedule_purposeformula(e.schedule_purpose) CF_schedule_purpose, RLM_RLMDPDER_XMLP_PKG.cf_schedule_sourceformula(e.schedule_source) CF_schedule_source, RLM_RLMDPDER_XMLP_PKG.cf_order_typeformula(TO_NUMBER ( null )) CF_order_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_typeformula(e.item_detail_type) CF_item_detail_type, RLM_RLMDPDER_XMLP_PKG.cf_item_detail_subtypeformula(e.item_detail_subtype) CF_item_detail_subtype, RLM_RLMDPDER_XMLP_PKG.cf_quantity_typeformula(e.qty_type_code) CF_quantity_type FROM rlm_demand_exceptions e, oe_order_headers_all oh, oe_order_lines_all ol, rlm_message_category_v msg, fnd_lookup_values lu WHERE e.order_header_id IS NOT NULL AND e.order_line_id IS NOT NULL AND oh.header_id = e.order_header_id AND ol.line_id(+)= e.order_line_id AND oh.org_id = ol.org_id AND oh.org_id = :CP_Org_id AND e.message_name = msg.message_name AND lu.lookup_type = 'RLM_MESSAGE_CATEGORY' AND lu.lookup_code = '1' AND lu.view_application_id = 0 AND lu.meaning = nvl(msg.message_category_desc, lu.meaning) &p_where_clause &p_where_clause1 ORDER BY 2 DESC,6 ASC,4 ASC,5 ASC,3 ASC,7 ASC,8 ASC,9 ASC,12 ASC,10 ASC,11 ASC,46 ASC,47 ASC,62 ASC,63 ASC , request_id desc , oe_order_number , schedule_line_num Y RLM RLMDPDER_XML AR RLM تقرير استثناءات إدارة الإصدار Application: إدارة بيانات الإصدار Source: تقرير استثناءات إدارة الإصدار (XML) Short Name: RLMDPDER_XML DB package: RLM_RLMDPDER_XMLP_PKG D RLM Release Management - Ausnahmen Application: Release Management Source: Release Management - Ausnahmen (XML) Short Name: RLMDPDER_XML DB package: RLM_RLMDPDER_XMLP_PKG F RLM Etat des exceptions de la gestion des appels de livraison Application: Release Management Source: Etat des exceptions de la gestion des appels de livraison (XML) Short Name: RLMDPDER_XML DB package: RLM_RLMDPDER_XMLP_PKG US RLM Release Management Exceptions Application: Release Management Source: Release Management Exceptions Report (XML) Short Name: RLMDPDER_XML DB package: RLM_RLMDPDER_XMLP_PKG ZHS RLM 发放管理例外报表 Application: 发放管理 Source: 发放管理例外报表 (XML) Short Name: RLMDPDER_XML DB package: RLM_RLMDPDER_XMLP_PKG BI Publisher &p_where_clause &p_where_clause1 &p_where_clause2 :cp_default_ou :cp_org_id :operating_unit :p_conc_request_id :p_creation_date :p_creation_date_to :p_customer_from :p_customer_item_from :p_customer_item_to :p_customer_to :p_exception_severity :p_item_from :p_item_to :p_message_category_from :p_message_category_to :p_option_of_details :p_order_by :p_order_by1 :p_order_by2 :p_order_number_from :p_order_number_to :p_order_type_from :p_order_type_name_from :p_order_type_name_to :p_order_type_to :p_org_id :p_request_id_from :p_request_id_to :p_schedule_number_from :p_schedule_number_to :p_ship_from_org :p_sort_by :p_sort_by1 :p_sort_by2 :p_tp_location :p_trading_partner_from :p_trading_partner_to :p_where_clause :p_where_clause1 :p_where_clause2 1 10 :p_request_id_from LOV Oracle CONC_REQUEST_IDS Y select request_id id, request_id value, null description from fnd_concurrent_requests order by request_id AR من معرف الطلب D Von Prozess-Nr. F ID demande - De US From Request ID ZHS 起始请求编号 2 20 :p_request_id_to LOV Oracle CONC_REQUEST_IDS Y select request_id id, request_id value, null description from fnd_concurrent_requests order by request_id Select :$FLEX$.From_Request_ID from dual AR إلى معرف الطلب D Bis Prozess-Nr. F ID demande - A US To Request ID ZHS 终止请求编号 3 30 :p_ship_from_org Char AR شحن خارجي من D Externe Versandadresse F Livraison externe - De US External Ship-From ZHS 外部发运方 4 40 :p_customer_from Char AR العميل الخارجي من D Von Externer Kunde F Client externe - De US From External Customer ZHS 外部客户自 5 50 :p_customer_to Char AR إلى العميل D Bis Kunde F Client - A US To Customer ZHS 至客户 6 60 :p_trading_partner_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 From Trading Partner ZHS 自贸易伙伴 7 70 :p_trading_partner_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 SELECT :$FLEX$.From_Trading_Partner FROM DUAL AR إلى الشريك التجاري D Bis Geschäftspartner F Partenaire commercial - A US To Trading Partner ZHS 至贸易伙伴 8 80 :p_tp_location LOV Oracle RLM_TP_LOCATION_CODE Y select ece_tp_location_code id, ece_tp_location_code value, substr(loc.address1,1,30)||' '||substr(loc.city,1,20)||' '||substr(loc.state,1,8) description from ece_tp_headers eth,hz_cust_acct_sites raa,hz_locations loc,hz_party_sites party,hz_loc_assignments loc_assign where exists (select 1 from hz_cust_acct_sites raa,hz_cust_site_uses_all ras where raa.cust_acct_site_id=ras.cust_acct_site_id and ras.site_use_code='SHIP_TO' and ras.status='A' and eth.tp_header_id=raa.tp_header_id and raa.org_id=ras.org_id) and exists (select 1 from ece_tp_details ece where eth.tp_header_id=ece.tp_header_id) and eth.tp_header_id=raa.tp_header_id and raa.party_site_id=party.party_site_id and loc.location_id=party.location_id and loc.location_id=loc_assign.location_id and raa.org_id=loc_assign.org_id order by ece_tp_location_code AR موقع الشريك التجاري الخارجي D Standort Externer Geschäftspartner F Lieu du partenaire commercial externe US External Trading Partner Location ZHS 外部贸易伙伴地点 9 90 :p_customer_item_from Char AR من صنف العميل الخارجي D Von externer Kundenartikel F Article client externe - De US From External Customer Item ZHS 外部客户项目自 10 100 :p_customer_item_to Char AR إلى صنف العميل الخارجي D Bis externer Kundenartikel F Article client externe - A US To External Customer Item ZHS 外部客户项目至 11 110 :p_item_from LOV Oracle RLM_INVENTORY_ITEM Y Y select item_number id, item_number value, description description from mtl_item_flexfields where nvl(organization_id,nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10))),-99)) =nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb (userenv('CLIENT_INFO'),1,10))),-99) order by item_number AR من الصنف المخزني D Von Lagerartikel F Articles stockés - De US From Inventory Item ZHS 自库存项目 12 120 :p_item_to LOV Oracle RLM_INVENTORY_ITEM Y Y select item_number id, item_number value, description description from mtl_item_flexfields where nvl(organization_id,nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb(userenv('CLIENT_INFO'),1,10))),-99)) =nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' ',null,substrb (userenv('CLIENT_INFO'),1,10))),-99) order by item_number AR إلى الصنف المخزني D Bis Lagerartikel F Articles stockés - A US To Inventory Item ZHS 至库存项目 13 130 :p_order_number_from LOV Oracle RLM_SRS_ORDER_NUMBER Y select oh.order_number id, oh.order_number value, null description from oe_order_headers oh,oe_order_types_v ot where oh.order_type_id=ot.order_type_id order by value,description AR من رقم الطلب D Von Auftragsnummer F Numéro de commande - De US From Order Number ZHS 自订单编号 14 140 :p_order_number_to LOV Oracle RLM_SRS_ORDER_NUMBER Y select oh.order_number id, oh.order_number value, null description from oe_order_headers oh,oe_order_types_v ot where oh.order_type_id=ot.order_type_id order by value,description SELECT :$FLEX$.From_Order_Number FROM DUAL AR إلى رقم الطلب D Bis Auftragsnummer F Numéro de commande - A US To Order Number ZHS 至订单编号 15 150 :p_order_type_from LOV Oracle RLM_SRS_ORDER_TYPES Y select order_type_id id, name value, null description from oe_order_types_v order by name AR من نوع الطلب D Von Auftragsart F Type de commande - De US From Order Type ZHS 自订单类型 16 160 :p_order_type_to LOV Oracle RLM_SRS_ORDER_TYPES Y select order_type_id id, name value, null description from oe_order_types_v order by name Select :$FLEX$.From_Order_Type from dual AR إلى نوع الطلب D Bis Auftragsart F Type de commande - A US To Order Type ZHS 至订单类型 17 170 :p_schedule_number_from Char AR من رقم الجدول D Von Plannummer F Numéro de programme - De US From Schedule Number ZHS 自计划编号 18 180 :p_schedule_number_to Char AR إلى رقم الجدول D Bis Plannummer F Numéro de programme - A US To Schedule Number ZHS 至计划编号 19 190 :p_message_category_from LOV Oracle RLM_MESSAGE_CATEGORY Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='RLM_MESSAGE_CATEGORY' order by lookup_code AR فئة الرسالة من D Von Nachrichtenkategorie F Catégorie de messages - De US From Message Category ZHS 自消息类别 20 200 :p_message_category_to LOV Oracle RLM_MESSAGE_CATEGORY Y select lookup_code id, lookup_code value, meaning description from fnd_lookups where lookup_type='RLM_MESSAGE_CATEGORY' order by lookup_code SELECT :$FLEX$.From_Message_Category FROM DUAL AR فئة الرسالة إلى D Bis Nachrichtenkategorie F Catégorie de messages - A US To Message Category ZHS 至消息类别 21 210 :p_exception_severity LOV Oracle RLM_EXCEPTION_SEVERITY_LEVEL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_EXCEPTION_SEVERITY' order by value,description AR خطورة الاستثناء D Ausnahmebedeutung F Gravité d'exception US Exception Severity ZHS 例外严重程度 22 220 :p_option_of_details 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 Druckdetails F Détails d'impression US Print Details ZHS 打印详细资料 23 230 :p_creation_date Date AR من تاريخ التكوين D Von Erstellungsdatum F Date de création - De US From Creation Date ZHS 起始创建日期 24 240 :p_creation_date_to Date AR إلى تاريخ التكوين D Bis Erstellungsdatum F Date de création - Au US To Creation Date ZHS 终止创建日期 25 250 :p_sort_by LOV Oracle RLM_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_REPORT_SORT_BY' and enabled_flag='Y' order by value,description AR فرز بواسطة D Sortieren nach F Tri par US Sort by ZHS 排序依据 :$FLEX$.From_Message_Category From Message Category To Message Category :$FLEX$.From_Order_Number From Order Number To Order Number :$FLEX$.From_Order_Type From Order Type To Order Type :$FLEX$.From_Request_ID From Request ID To Request ID :$FLEX$.From_Trading_Partner From Trading Partner To Trading Partner