ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4721151A9E05362FB09050512Y SELECT sih.SCHEDULE_REFERENCE_NUM, sih.SCHEDULE_SOURCE, sih.SCHEDULE_TYPE atype, flv0.MEANING stype, sih.SCHEDULE_TYPE_EXT, sih.SCHEDULE_PURPOSE, flv7.MEANING spurpose, sih.SCHEDULE_PURPOSE_EXT, sih.SCHED_GENERATION_DATE,sih.EDI_TEST_INDICATOR, substrb(sih.CUST_NAME_EXT, 1, 60) cust_name_ext, sih.CUSTOMER_ID, sih.CUSTOMER_EXT, sih.ECE_TP_TRANSLATOR_CODE,sih.ECE_TP_LOCATION_CODE_EXT, sih.SCHED_HORIZON_START_DATE,sih.SCHED_HORIZON_END_DATE, sih.HEADER_ID,sih.PROCESS_STATUS, sih.CREATION_DATE, flv1.MEANING status, sih.LAST_UPDATE_DATE,sih.EDI_CONTROL_NUM_1, sih.EDI_CONTROL_NUM_2,sih.EDI_CONTROL_NUM_3, sih.CUST_ADDRESS_1_EXT,sih.CUST_ADDRESS_2_EXT, sih.CUST_ADDRESS_3_EXT,sih.CUST_ADDRESS_4_EXT, sih.CUST_CITY_EXT,sih.CUST_STATE_EXT, sih.CUST_COUNTRY_EXT,sih.CUST_POSTAL_CD_EXT, sil.CUST_SHIP_FROM_ORG_EXT,sil.CUST_SHIP_TO_EXT,sil.CUSTOMER_ITEM_EXT, sil.CUSTOMER_ITEM_ID, sil.ITEM_DETAIL_TYPE,sil.ITEM_DETAIL_SUBTYPE, sil.INVENTORY_ITEM_ID,sil.INTRMD_SHIP_TO_ID,sil.BILL_TO_ADDRESS_ID, sil.CUST_MODEL_SERIAL_NUMBER,sil.CUSTOMER_JOB,sil.HEADER_Id, sil.LINE_NUMBER,sil.CUST_PRODUCTION_SEQ_NUM, sil.SCHEDULE_ITEM_NUM,sil.SHIP_FROM_ORG_ID,sil.SHIP_TO_ORG_ID, sil.CUST_PO_NUMBER,sil.SHIP_TO_ADDRESS_ID, decode(sil.item_detail_type,'0',:P_detail_type,'1',:P_detail_type,'2',:P_detail_type,'6',:P_detail_type, '3',:P_Auth,'4',:P_shipped_rec_cum,'5',:P_other) detail_type1, flv2.MEANING detail_type, flv3.MEANING sub_type, flv5.MEANING qty_type, flv6.MEANING date_type, sil.ITEM_DETAIL_QUANTITY,sil.UOM_CODE,sil.DATE_TYPE_CODE, sil.START_DATE_TIME,sil.END_DATE_TIME,sil.QTY_TYPE_CODE, sil.SHIP_DEL_PATTERN_EXT,sil.PROCESS_STATUS,sil.CUSTOMER_DOCK_CODE, sil.INDUSTRY_ATTRIBUTE1, flv4.MEANING lprocess_status, RLM_RLMSCHRL_XMLP_PKG.cf_schedule_sourceformula(sih.SCHEDULE_SOURCE) CF_schedule_source, RLM_RLMSCHRL_XMLP_PKG.cf_address1formula(sih.CUST_ADDRESS_1_EXT, sih.CUST_ADDRESS_2_EXT, sih.CUST_ADDRESS_3_EXT, sih.CUST_ADDRESS_4_EXT) CF_Address1, RLM_RLMSCHRL_XMLP_PKG.cf_address2formula(sih.CUST_ADDRESS_1_EXT, sih.CUST_ADDRESS_2_EXT, sih.CUST_ADDRESS_3_EXT, sih.CUST_ADDRESS_4_EXT) CF_Address2, RLM_RLMSCHRL_XMLP_PKG.cf_address4formula(sih.CUST_ADDRESS_1_EXT, sih.CUST_ADDRESS_2_EXT, sih.CUST_ADDRESS_3_EXT, sih.CUST_ADDRESS_4_EXT) CF_Address4, RLM_RLMSCHRL_XMLP_PKG.cf_address3formula(sih.CUST_ADDRESS_1_EXT, sih.CUST_ADDRESS_2_EXT, sih.CUST_ADDRESS_3_EXT, sih.CUST_ADDRESS_4_EXT) CF_Address3, RLM_RLMSCHRL_XMLP_PKG.cf_test_indicatorformula(sih.EDI_TEST_INDICATOR) CF_test_indicator, RLM_RLMSCHRL_XMLP_PKG.cf_customer_numformula(sih.CUSTOMER_ID) CF_CUSTOMER_NUM, RLM_RLMSCHRL_XMLP_PKG.cf_ship_del_patternformula(sil.SHIP_DEL_PATTERN_EXT) CF_ship_del_pattern, RLM_RLMSCHRL_XMLP_PKG.cf_inv_item_conc_segmentformul(sil.INVENTORY_ITEM_ID, sil.SHIP_FROM_ORG_ID) CF_inv_item_conc_segment, RLM_RLMSCHRL_XMLP_PKG.cf_ship_to_locformula(sih.SCHEDULE_SOURCE, sil.SHIP_TO_ADDRESS_ID, sil.CUST_SHIP_TO_EXT) CF_ship_to_loc, RLM_RLMSCHRL_XMLP_PKG.cf_bill_to_locformula(sil.BILL_TO_ADDRESS_ID) CF_bill_to_loc, RLM_RLMSCHRL_XMLP_PKG.cf_ship_from_orgformula(sih.SCHEDULE_SOURCE, sil.SHIP_FROM_ORG_ID, sil.CUST_SHIP_FROM_ORG_EXT) CF_ship_from_org, RLM_RLMSCHRL_XMLP_PKG.cf_cust_item_numformula(sih.SCHEDULE_SOURCE, sil.CUSTOMER_ITEM_ID, sih.CUSTOMER_ID, sil.CUSTOMER_ITEM_EXT) CF_cust_item_num FROM rlm_schedule_interface_hdr_v sih, rlm_schedule_interface_lines_v sil , fnd_lookup_values_vl flv0, fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2, fnd_lookup_values_vl flv3, fnd_lookup_values_vl flv4, fnd_lookup_values_vl flv5, fnd_lookup_values_vl flv6, fnd_lookup_values_vl flv7 WHERE sil.header_id = sih.header_id and flv0.lookup_type = 'RLM_SCHEDULE_TYPE' and flv0.lookup_code = sih.schedule_type and flv1.lookup_type = 'RLM_PROCESS_STATUS' and flv1.lookup_code = sih.process_status and flv2.lookup_type = 'RLM_DETAIL_TYPE_CODE' and flv2.lookup_code = sil.item_detail_type and flv3.lookup_type = 'RLM_DETAIL_SUBTYPE_CODE' and flv3.lookup_code = sil.item_detail_subtype and flv4.lookup_type = 'RLM_PROCESS_STATUS' and flv4.lookup_code = sil.process_status and flv5.lookup_type = 'RLM_QTY_TYPE_CODE' and flv5.lookup_code = sil.qty_type_code and flv6.lookup_type = 'RLM_DATE_TYPE_CODE' and flv6.lookup_code = sil.date_type_code and flv7.lookup_type = 'RLM_SCHEDULE_PURPOSE' and flv7.lookup_code = sih.schedule_purpose &P_WHERE_CLAUSE ORDER BY 1 ASC, 2 ASC, 3 ASC, 20 ASC, 5 ASC, 6 ASC, 8 ASC, 19 ASC, 4 ASC, 7 ASC, 9 ASC, 21 ASC, 13 ASC, 10 ASC, 11 ASC, 12 ASC, 14 ASC, 15 ASC, 16 ASC, 17 ASC, 18 ASC, 23 ASC, 24 ASC, 25 ASC, 26 ASC, 27 ASC, 28 ASC, 29 ASC, 30 ASC, 22 ASC, 31 ASC, 33 ASC, 32 ASC, 34 ASC, 67 ASC, 66 ASC, 37 ASC, 52 ASC, 35 ASC, 36 ASC, 41 ASC, 42 ASC, 40 ASC, 51 ASC, 50 ASC, 49 ASC, 44 ASC, 64 ASC, 43 ASC, 45 ASC, 53 ASC, sih.last_update_date DESC, sih.sched_generation_date DESC, sil.line_number ASC RLM RLMSCHRL_XML AR RLM تقرير الجدول/الإصدار Imported from BI Publisher Description: تقرير الجدول/الإصدار Application: إدارة بيانات الإصدار Source: تقرير الجدول/الإصدار (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG D RLM Plan/Abruf Imported from BI Publisher Description: Auswertung "Plan/Abruf" Application: Release Management Source: Plan/Abruf (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG E RLM Informe Programa/Pedidos Parciales Imported from BI Publisher Description: Informe Programa/Pedidos Parciales Application: Release Management Source: Informe Programa/Pedidos Parciales (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG F RLM Etat Programmes/Appels de livraison Imported from BI Publisher Description: Etat Programmes/Appels de livraison Application: Release Management Source: Etat Programmes/Appels de livraison (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG I RLM Rapporto Programma/rilascio Imported from BI Publisher Description: Rapporto Programma/rilascio Application: Release Management Source: Rapporto Programma/rilascio (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG JA RLM スケジュール/リリース・レポート Imported from BI Publisher Description: スケジュール/リリース・レポート Application: Release Management Source: スケジュール/リリース・レポート(XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG KO RLM 스케줄/릴리즈 보고서 Imported from BI Publisher Description: 스케줄/릴리즈 보고서 Application: Release Management Source: 스케줄/릴리즈 보고서(XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG PTB RLM Relatório de Programação/Liberação Imported from BI Publisher Description: Relatório de Programação/Liberação Application: Release Management Source: Relatório de Programação/Liberação (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG RU RLM Отчет "График/релиз" Imported from BI Publisher Description: Отчет "График/релиз" Application: Управление комплектованием Source: Отчет "График/релиз" (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG S RLM Planering/frisläppning - rapport Imported from BI Publisher Description: Planering/frisläppning - rapport Application: Release Management Source: Planering/frisläppning - rapport (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG TR RLM Çizelge/Yayın Raporu Imported from BI Publisher Description: Çizelge/Yayın Raporu Application: Yayın Yönetimi Source: Çizelge/Yayın Raporu (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG US RLM Schedule/Release Imported from BI Publisher Description: Schedule/Release Report Application: Release Management Source: Schedule/Release Report (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG ZHS RLM 计划/发放报表 Imported from BI Publisher Description: 计划/发放报表 Application: 发放管理 Source: 计划/发放报表 (XML) Short Name: RLMSCHRL_XML DB package: RLM_RLMSCHRL_XMLP_PKG BI Publisher &p_where_clause :cp_customer :cp_default_ou :cp_horizon_end_date :cp_horizon_start_date :cp_issue_date_from :cp_issue_date_to :cp_process_date_from :cp_process_date_to :cp_process_status :cp_schedule_purpose :cp_schedule_ref_num :cp_schedule_source :cp_schedule_type :cp_ship_from_org :cp_ship_to :cp_title :cp_tp_from :cp_tp_loc_code_from :cp_tp_loc_code_to :cp_tp_to :operating_unit :p_auth :p_conc_request_id :p_customer :p_detail_type :p_horizon_end_date :p_horizon_start_date :p_issue_date_from :p_issue_date_to :p_org_id :p_other :p_process_date_from :p_process_date_to :p_process_status :p_ref_num :p_schedule_num :p_schedule_purpose :p_schedule_source :p_schedule_type :p_ship_from :p_ship_to :p_shipped_rec_cum :p_title :p_tp_from :p_tp_loc_from :p_tp_loc_to :p_tp_to :p_where_clause 1 -60 :p_detail_type Char select 'Past Due/Firm/Forecast demand' from dual AR تقدير/تأكيد/المتجاوز للاستحقاق تقدير/تأكيد/المتجاوز للاستحقاق D Überfällig/Fixiert/Forecast Überfällig/Fixiert/Forecast E Vencido/En Firme/ Previsto Vencido/En Firme/ Previsto F En retard/Ferme/Prévision En retard/Ferme/Prévision I Previsioni/scadute/confermate Previsioni/scadute/confermate JA 納期超過/確定/予測 納期超過/確定/予測 KO 납기 경과/확정/수요예측 납기 경과/확정/수요예측 PTB Vecimento/Firme/Previsão Vecimento/Firme/Previsão RU Просрочено/закреплено/прогноз Просрочено/закреплено/прогноз S Förfallen/fast/prognos Förfallen/fast/prognos TR Vadesi Geçen/Kesin/Tahmin Vadesi Geçen/Kesin/Tahmin US Past Due/Firm/Forecast Past Due/Firm/Forecast ZHS 过期/固定/预测 过期/固定/预测 2 -50 :p_title Char Schedule/Release Report AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 3 -40 :p_shipped_rec_cum Char select 'Shipped/Received/CUM Information' from dual AR معلومات الكمية المشحونة/المستلمة/المتراكمة معلومات الكمية المشحونة/المستلمة/المتراكمة D Geliefert/Eingegangen/FSZ-Daten Geliefert/Eingegangen/FSZ-Daten E Enviado/Recibido/Información de ACUMULACIÓN Enviado/Recibido/Información de ACUMULACIÓN F Expédié/reçu/info. cumul Expédié/reçu/info. cumul I Informazioni cumulative/spedizione/ricezione Informazioni cumulative/spedizione/ricezione JA 出荷済/受入済/CUM情報 出荷済/受入済/CUM情報 KO 출하/입고/CUM 정보 출하/입고/CUM 정보 PTB Informações Entregues/Recebidas/CUM Informações Entregues/Recebidas/CUM RU Данные "Отгружено/получено/совокупно" Данные "Отгружено/получено/совокупно" S Info. om levererad/mottagen/ack. Info. om levererad/mottagen/ack. TR Sevkedildi/Teslim Alındı/KÜM Bilgileri Sevkedildi/Teslim Alındı/KÜM Bilgileri US Shipped/Received/CUM Info Shipped/Received/CUM Info ZHS 已发运/收到/CUM 信息 已发运/收到/CUM 信息 4 -30 :p_auth Char select 'Authorization Demand' from dual AR طلب الصلاحية الصلاحية D Bedarf Autorisierung Autorisierung E Demanda de Autorización Autorización F Demande de feu vert Feu vert I Domanda autorizzazione Autorizzazione JA 承認需要 承認 KO 승인 수요 승인 PTB Demanda de Autorização Autorização RU Требуется авторизация Авторизация S Behörighetsbehov Behörighet TR Yetki Talebi Yetki US Authorization Demand Authorization ZHS 批准需求 批准 5 -20 :p_other Char select 'Other Demand' from dual AR طلب آخر طلب آخر D Sonstiger Bedarf Sonstiger Bedarf E Otra Demanda Otra Demanda F Autre demande Autre demande I Altra domanda Altra domanda JA その他需要 その他需要 KO 기타 수요 기타 수요 PTB Outra Demanda Outra Demanda RU Другие требования Другие требования S Övrig efterfrågan Övrig efterfrågan TR Diğer Talep Diğer Talep US Other Demand Other Demand ZHS 其它需求 其它需求 6 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 7 10 :p_customer LOV Oracle RLM_CUSTOMER 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,account_number AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre del Cliente Nombre del Cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 8 20 :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 AR نوع الجدول نوع الجدول D Planart Planart E Tipo de Programa Tipo de Programa F Type de programme Type de programme I Tipo di programma Tipo di programma JA スケジュール・タイプ スケジュール・タイプ KO 스케줄 유형 스케줄 유형 PTB Tipo de Programação Tipo de Programação RU Тип графика Тип графика S Planeringstyp Planeringstyp TR Çizelge Tipi Çizelge Tipi US Schedule Type Schedule Type ZHS 计划类型 计划类型 9 30 :p_schedule_num LOV Oracle RLM_SCH_REF_NUM Y select origin_table || to_char (header_id) id, schedule_reference_num value, sched_generation_date description from rlm_sch_rel_v where ( customer_id=nvl(:$flex$.rlm_customer:null,customer_id) or (customer_id is null and ece_tp_translator_code in (select distinct(etd.translator_code) from hz_cust_acct_sites rad, ece_tp_details etd where rad.tp_header_id=etd.tp_header_id and rad.cust_account_id =nvl (:$flex$.rlm_customer:null, rad.cust_account_id ) ) ) ) and schedule_type=nvl (:$flex$.rlm_schedule_type:null, schedule_type ) order by schedule_reference_num AR رقم مرجع الجدول رقم مرجع الجدول D Planreferenz-Nr. Planreferenz-Nr. E Número de Referencia del Programa Número de Referencia del Programa F Numéro de référence du programme Numéro de référence du programme I Numero di riferimento programma Numero di riferimento programma JA スケジュール参照番号 スケジュール参照番号 KO 스케줄 참조 번호 스케줄 참조 번호 PTB Nr. Referência da Programação Número de Referência da Programação RU Шифр графика № ссылки на график S Planreferensnummer Planreferensnummer TR Çizelge Referans Numarası Çizelge Referans Numarası US Schedule Reference Num Schedule Reference Number ZHS 计划参考编号 计划参考编号 10 40 :p_ship_from LOV Oracle RLM_SHIP_FROM_ORG Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code,organization_name AR شحن من التنظيم شحن من التنظيم D Versandorganisation Versandorganisation E Organización de Origen de Envío Organización de Origen de Envío F Organisation d'expédition Organisation d'expédition I Organizzazione di spedizione Organizzazione di spedizione JA 出荷元組織 出荷元組織 KO 출고처 조직 출고처 조직 PTB Org. de Entrega Org. de Entrega RU Организация-отправитель товара Организация-отправитель товара S Avsändaradress - org. Avsändaradress - org. TR Sevk Çıkış Org Sevk Çıkış Org US Ship From Org Ship From Org ZHS 发货组织 发货组织 11 50 :p_ship_to LOV Oracle RLM_SHIP_TO_ADDRESS Y select acct_site.cust_acct_site_id id, cust_site.location value, null description from hz_party_sites party_site,hz_locations loc,hz_cust_acct_sites acct_site,hz_cust_site_uses_all cust_site where ( :$flex$.rlm_customer:null is null and acct_site.status='A' and cust_site.cust_acct_site_id =acct_site.cust_acct_site_id and acct_site.party_site_id =party_site.party_site_id and loc.location_id =party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) or ( :$flex$.rlm_customer:null is not null and acct_site.cust_account_id in ( select to_number(:$flex$.rlm_customer:null) from dual union select cust_account_id from hz_cust_acct_relate where related_cust_account_id=:$flex$.rlm_customer:null and ship_to_flag='Y' and status='A' and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A')) and acct_site.status='A' and cust_site.cust_acct_site_id =acct_site.cust_acct_site_id and acct_site.party_site_id =party_site.party_site_id and loc.location_id =party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) order by cust_site.location AR شحن إلى شحن إلى D Liefern an Liefern an E Envío Envío F Livraison Livraison I Spedisci a Spedisci a JA 出荷先 出荷先 KO 납품처 납품처 PTB Entregar Para Entregar Para RU Получатель товара Получатель товара S Lev.adress Lev.adress TR Sevkedilen Yer Sevkedilen Yer US Ship To Ship To ZHS 收货方 收货方 12 60 :p_schedule_purpose LOV Oracle RLM_SCHEDULE_PURPOSE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_SCHEDULE_PURPOSE' order by meaning AR الغرض من الجدول الغرض من الجدول D Planungszweck Planungszweck E Objetivo del Programa Objetivo del Programa F Objet du programme Objet du programme I Scopo del programma Scopo del programma JA スケジュール目的 スケジュール目的 KO 스케줄 목적 스케줄 목적 PTB Objetivo da Programação Objetivo da Programação RU Цель графика Цель графика S Planeringssyfte Planeringssyfte TR Çizelge Amaçları Çizelge Amaçları US Schedule Purpose Schedule Purpose ZHS 计划用途 计划用途 13 70 :p_schedule_source Char AR مصدر الجدول مصدر الجدول D Planherkunft Planherkunft E Origen del Programa Origen del Programa F Origine du programme Origine du programme I Orig. progr. Orig. progr. JA スケジュール・ソース スケジュール・ソース KO 스케줄 자원 스케줄 자원 PTB Origem da Programação Origem da Programação RU Источник графика Источник графика S Planeringskälla Planeringskälla TR Çizelge Kaynağı Çizelge Kaynağı US Schedule Source Schedule Source ZHS 计划来源 计划来源 14 80 :p_horizon_start_date DateTime AR تاريخ بداية النطاق تاريخ بداية النطاق D Von Horizont Von Horizont E Fecha de Inicio del Horizonte Fecha de Inicio del Horizonte F Date de début de l'horizon Date de début horizon I Data inizio orizzonte Data di inizio dell'orizzonte JA 範囲開始日 範囲開始日 KO 계획 대상 기간 시작 일자 계획 대상 기간 시작 일자 PTB Data Inicial do Horizonte Data Inicial Horizonte RU Начало горизонта Начало горизонта S Startdatum för horisont Startdatum för horisont TR Dönem Başlangıç Tarihi Dönem Balangıç Tarihi US Horizon Start Date Horizon Start Date ZHS 展望期起始日期 展望期起始日期 15 90 :p_horizon_end_date DateTime AR تاريخ نهاية النطاق تاريخ نهاية النطاق D Horizontende Horizontende E Fecha de Finalización de Horizonte Fecha de Finalización de Horizonte F Date de fin horizon Date de fin horizon I Data fine orizzonte Data fine orizzonte JA 範囲終了日 範囲終了日 KO 계획 대상 기간 종료 일자 계획 대상 기간 종료 일자 PTB Data Final do Horizonte Data Final do Horizonte RU Конец горизонта Конец горизонта S Slutdatum för horisont Slutdatum för horisont TR Dönem Bitiş Tarihi Dönem Bitiş Tarihi US Horizon End Date Horizon End Date ZHS 展望期终止日期 展望期终止日期 16 100 :p_issue_date_from DateTime AR تاريخ الإصدار من تاريخ الإصدار من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Emisión De Fecha de Emisión F Date d'émission - Du Date d'émission - Du I Data emissione - Da Data emissione - Da JA 出庫日:自 出庫日:自 KO 출고 일자: 부터 출고 일자: 부터 PTB Data da Emissão - De Data da Emissão - De RU Дата выпуска с Дата выпуска с S Från datum för utfärdande Från datum för utfärdande TR Çıkış Başlangıç Tarihi Çıkış Başlangıç Tarihi US Issue Date From Issue Date From ZHS 发放日期自 发放日期自 17 110 :p_issue_date_to DateTime select fnd_date.date_to_chardt(fnd_date.canonical_to_date(:$flex$.issue_date_from)) from dual AR تاريخ الجدول إلى تاريخ الجدول إلى D Bis Erstellungsdatum Bis Erstellungsdatum E A Fecha de Emisión A Fecha de Emisión F Date d'émission - Au Date d'émission - Au I Data emissione - A Data emissione - A JA 出庫日:至 出庫日:至 KO 출고 일자: 까지 출고 일자: 까지 PTB Data da Emissão - Até Data da Emissão - Até RU Дата выпуска по Дата выпуска по S Till datum för utfärdande Till datum för utfärdande TR Çıkış Bitiş Tarihi Çıkış Bitiş Tarihi US Issue Date To Issue Date To ZHS 发放日期至 发放日期至 18 120 :p_tp_from LOV Oracle RLM_TP_FROM 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 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 acct_site.cust_account_id=nvl(:$flex$.rlm_customer:null,acct_site.cust_account_id) 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 Von Geschäftspartner E De Partner Comercial De Partner Comercial F Partenaire commercial - De Partenaire commercial - De I Partner commerciale - Da Partner commerciale - Da JA 取引先:自 取引先:自 KO 거래 파트너:부터 거래 파트너:부터 PTB Parceiro Comercial - De Parceiro Comercial - De RU Торговый партнер с Торговый партнер с S Från handelspartner Från handelspartner TR İlk Ticari Ortak İlk Ticari Ortak US Trading Partner From Trading Partner From ZHS 贸易伙伴自 贸易伙伴自 19 130 :p_tp_to LOV Oracle RLM_TP_TO 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 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 acct_site.cust_account_id=nvl(:$flex$.rlm_customer:null,acct_site.cust_account_id) 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$.trading_partner_from from dual AR الشريك التجاري إلى الشريك التجاري إلى D Bis Geschäftspartner Bis Geschäftspartner E A Partner Comercial A Partner Comercial F Partenaire commercial - A Partenaire commercial - A I Partner commerciale - A Partner commerciale - A JA 取引先:至 取引先:至 KO 거래 파트너:까지 거래 파트너:까지 PTB Parceiro Comercial - Até Parceiro Comercial - Até RU Торговый партнер по Торговый партнер по S Till handelspartner Till handelspartner TR Son Ticari Ortak Son Ticari Ortak US Trading Partner To Trading Partner To ZHS 贸易伙伴至 贸易伙伴至 20 140 :p_tp_loc_from LOV Oracle RLM_TP_LOC_CODE Y select raa.ece_tp_location_code id, raa.ece_tp_location_code value, null description from hz_cust_acct_sites raa where raa.rowid=(select min(raa1.rowid) from ece_tp_details etd,hz_cust_acct_sites raa1,hz_cust_accounts rac where raa.ece_tp_location_code=raa1.ece_tp_location_code and raa1.cust_account_id=rac.cust_account_id and etd.tp_header_id=raa1.tp_header_id and etd.translator_code>=nvl(:$flex$.rlm_tp_from:null,etd.translator_code) and etd.translator_code<=nvl(:$flex$.rlm_tp_to:null,etd.translator_code) and raa1.cust_account_id=nvl(:$flex$.rlm_customer:null,raa1.cust_account_id)) order by raa.ece_tp_location_code AR رمز موقع الشريك التجاري من رمز موقع الشريك التجاري من D Von Standortschlüssel Geschäftspartner Von Standortschlüssel Geschäftspartner E De Código de Ubicación de Partner Comercial De Código de Ubicación de Partner Comercial F Code lieu partenaire commercial - De Code lieu partenaire commercial - De I Codice ubicazione TP - Da Codice ubicazione TP - Da JA 取引先事業所コード: 自 取引先事業所コード: 自 KO TP 위치 코드: 부터 TP 위치 코드: 부터 PTB Código do Local TP - De Código do Local TP - De RU Код расположения ТП с Код расположения ТП с S Från HP-adresskod Från HP-adresskod TR İlk Ticari Ortak Yerleşim Kodu İlk Ticari Ortak Yerleşim Kodu US TP Location Code From TP Location Code From ZHS TP 地点代码自 TP 地点代码自 21 150 :p_tp_loc_to LOV Oracle RLM_TP_LOC_CODE Y select raa.ece_tp_location_code id, raa.ece_tp_location_code value, null description from hz_cust_acct_sites raa where raa.rowid=(select min(raa1.rowid) from ece_tp_details etd,hz_cust_acct_sites raa1,hz_cust_accounts rac where raa.ece_tp_location_code=raa1.ece_tp_location_code and raa1.cust_account_id=rac.cust_account_id and etd.tp_header_id=raa1.tp_header_id and etd.translator_code>=nvl(:$flex$.rlm_tp_from:null,etd.translator_code) and etd.translator_code<=nvl(:$flex$.rlm_tp_to:null,etd.translator_code) and raa1.cust_account_id=nvl(:$flex$.rlm_customer:null,raa1.cust_account_id)) order by raa.ece_tp_location_code SELECT :$flex$.tp_location_code_from from dual AR رمز موقع الشريك التجاري إلى رمز موقع الشريك التجاري إلى D Bis Standortschlüssel Geschäftspartner Bis Standortschlüssel Geschäftspartner E A Código de Ubicación de Partner Comercial A Código de Ubicación de Partner Comercial F Code lieu partenaire commercial - A Code lieu partenaire commercial - A I Codice ubicazione TP - A Codice ubicazione TP - A JA 取引先事業所コード: 至 取引先事業所コード: 至 KO TP 위치 코드: 까지 TP 위치 코드: 까지 PTB Código do Local TP - Até Código do Local TP - Até RU Код расположения ТП по Код расположения ТП по S Till HP-adresskod Till HP-adresskod TR Son Ticari Ortak Yerleşim Kodu Son Ticari Ortak Yerleşim Kodu US TP Location Code To TP Location Code To ZHS TP 地点代码至 TP 地点代码至 22 160 :p_process_date_from DateTime AR تاريخ المعالجة من تاريخ المعالجة من D Von Verarbeitungsdatum Von Verarbeitungsdatum E Fecha de Proceso De Fecha de Proceso De F Date du traitement - Du Date du traitement - Du I Data processo - Da Data processo - Da JA 処理日:自 処理日:自 KO 처리 일자: 부터 처리 일자: 부터 PTB Data do Processo - De Data do Processo - De RU Дата обработки с Дата обработки с S Från bearbetningsdatum Från bearbetningsdatum TR İlk İşlem Tarihi İlk İşlem Tarihi US Process Date From Process Date From ZHS 处理日期自 处理日期自 23 170 :p_process_date_to DateTime select fnd_date.date_to_chardt(fnd_date.canonical_to_date(:$flex$.process_date_from)) from dual AR تاريخ المعالجة إلى تاريخ المعالجة إلى D Bis Verarbeitungsdatum Bis Verarbeitungsdatum E Fecha de Proceso A Fecha de Proceso A F Date du traitement - Au Date du traitement - Au I Data processo - A Data processo - A JA 処理日:至 処理日:至 KO 처리 일자: 까지 처리 일자: 까지 PTB Data do Processo - Até Data do Processo - Até RU Дата обработки по Дата обработки по S Till bearbetningsdatum Till bearbetningsdatum TR Son İşlem Tarihi Son İşlem Tarihi US Process Date To Process Date To ZHS 处理日期至 处理日期至 24 180 :p_process_status LOV Oracle RLM_PROCESS_STATUS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_PROCESS_STATUS' and lookup_code<>3 order by meaning AR موقف المعالجة موقف المعالجة D Prozessstatus Prozessstatus E Estado del Proceso Estado del Proceso F Statut du traitement Statut du traitement I Stato processo Stato processo JA 処理ステータス 処理ステータス KO 프로세스 상태 프로세스 상태 PTB Status do Processo Status do Processo RU Статус обработки Статус обработки S Processtatus Processtatus TR İşlem Statüsü İşlem Statüsü US Process Status Process Status ZHS 流程状态 流程状态