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）限制的操作单元。 C6E085D4721051A9E05362FB09050512Y SELECT RCSD.SCH_HEADER_ID AHEADER_ID, RCSD.CUSTOMER_ID CUSTOMER_NUMBER, RCSD.CUSTOMER_NAME, RCSD.SCHEDULE_TYPE ASCHEDULE_TYPE, flv3.MEANING SCHEDULE_TYPE_MEAN, RCSD.SCHEDULE_SOURCE, RCSD.ECE_TP_TRANSLATOR_CODE TP_CODE, RCSD.ECE_TP_LOCATION_CODE_EXT TP_LOCATION_CODE, RCSD.SCHEDULE_REFERENCE_NUM, RCSD.SCHED_HORIZON_START_DATE HORIZON_START_DATE, RCSD.SCHED_HORIZON_END_DATE HORIZON_END_DATE, RCSD.SCHED_GENERATION_DATE ISSUE_DATE, RCSD.CREATION_DATE PROCESSED_DATE, RCSD.SCHEDULE_PURPOSE, flv4.MEANING SCHEDULE_PURPOSE_MEAN, RCSD.SHIP_FROM_ORG_ID, RCSD.SHIP_TO_ORG_ID, RCSD.SHIP_TO_ADDRESS_ID, RCSD.CUSTOMER_ITEM_ID, RCSD.INVENTORY_ITEM_ID, RMA.CUSTOMER_ITEM_NUMBER, RMA.CUSTOMER_ITEM_DESC, RMA.INVENTORY_ITEM_NUMBER, RMA.INVENTORY_ITEM_DESC, RMA.FROZEN_DAY_FROM, RMA.FROZEN_DAY_TO, RMA.FIRM_DAY_FROM, RMA.FIRM_DAY_TO, RMA.FORECAST_DAY_FROM, RMA.FORECAST_DAY_TO, RMA.INTRANSIT_TIME, RMA.TIME_UOM_CODE , RMA.FROZEN_FLAG , RMA.SHIP_DELIVERY_PATTERN, RMA.ROUND_TO_STANDARD_PACK, RMA.INTRANSIT_CALC_BASIS, RMA.EXCLUDE_NON_WORKDAYS_FLAG, RMA.UNSHIPPED_FIRM_DISP_CD PREHORIZON_DESPOSITION_CODE, RCSD.ITEM_DETAIL_SUBTYPE BUCKET_TYPE, flv2.MEANING BUCKET_TYPE_MEAN, RCSD.ITEM_DETAIL_TYPE DEMAND_TYPE, flv1.MEANING DEMAND_TYPE_MEAN , RCSD.WEEK_START_DATE, RCSD.WEEK_NAME, RCSD.CUSTOMER_DOCK_CODE, RCSD.CUSTOMER_JOB, RCSD.CUST_MODEL_SERIAL_NUMBER, RCSD.CUST_PRODUCTION_LINE, RCSD.CUST_PRODUCTION_SEQ_NUM, RCSD.CUST_PO_NUMBER SCH_PO_NUMBER, RCSD.CUSTOMER_ITEM_REVISION, RCSD.PULL_SIGNAL_START_SERIAL_NUM, RCSD.PULL_SIGNAL_END_SERIAL_NUM, RCSD.PULL_SIGNAL_REF_NUM, RCSD.CUSTOMER_REQUEST_DATE, RCSD.RECORD_YEAR, RCSD.SCH_LINE_ID SCHEDULE_LINE_ID, DECODE(:P_SCHEDULE_TYPE, 'SEQUENCED', NULL,to_char(RCSD.START_DATE_TIME,'DD-MON-RR HH24:MI:SS') ) REQUEST_DATE_NON_SEQUENCED, DECODE(:P_SCHEDULE_TYPE, 'SEQUENCED', to_char(RCSD.START_DATE_TIME,'DD-MON-RR HH24:MI:SS'), NULL) REQUEST_DATE_SEQUENCED, RCSD.ITEM_DETAIL_QUANTITY SCHEDULE_QUANTITY, RCSD.UOM_CODE, OLA.ORDERED_QUANTITY, OLA.ORDER_QUANTITY_UOM, DECODE(:P_SCHEDULE_TYPE, 'SEQUENCED', NULL,to_char( OLA.SCHEDULE_SHIP_DATE,'DD-MON-RR HH24:MI:SS')) SCHEDULE_SHIP_DATE_NON_SEQ, DECODE(:P_SCHEDULE_TYPE, 'SEQUENCED', to_char(OLA.SCHEDULE_SHIP_DATE,'DD-MON-RR HH24:MI:SS'), NULL) SCHEDULE_SHIP_DATE_SEQ, OLA.HEADER_ID ORDER_NUMBER, TO_CHAR(OLA.LINE_NUMBER) || DECODE(OLA.SHIPMENT_NUMBER, NULL, NULL, '.' || TO_CHAR(OLA.SHIPMENT_NUMBER))|| DECODE(OLA.OPTION_NUMBER, NULL, NULL, '.' || TO_CHAR(OLA.OPTION_NUMBER)) || DECODE(OLA.COMPONENT_NUMBER, NULL, NULL, DECODE(OLA.OPTION_NUMBER, NULL, '.',NULL)|| '.'||TO_CHAR(OLA.COMPONENT_NUMBER))|| DECODE(OLA.SERVICE_NUMBER,NULL,NULL, DECODE(OLA.COMPONENT_NUMBER, NULL, '.' , NULL) || DECODE(OLA.OPTION_NUMBER, NULL, '.', NULL ) || '.'|| TO_CHAR(OLA.SERVICE_NUMBER)) ORDER_LINE_NUMBER, OLA.CUST_PO_NUMBER PURCHASE_ORDER_NO, DECODE(:P_SCHEDULE_TYPE,'SEQUENCED',OLA.REQUEST_DATE,NULL) REQUEST_DATE_TIME, RLM_RLMDMCOM_XMLP_PKG.cf_customer_number_meanformula(RCSD.CUSTOMER_ID) CF_CUSTOMER_NUMBER_MEAN, RLM_RLMDMCOM_XMLP_PKG.cf_ship_toformula(RCSD.SHIP_TO_ADDRESS_ID) CF_SHIP_TO, RLM_RLMDMCOM_XMLP_PKG.cf_frozen_flagformula(RMA.FROZEN_FLAG) CF_FROZEN_FLAG, RLM_RLMDMCOM_XMLP_PKG.cf_time_uom_codeformula(RMA.TIME_UOM_CODE) CF_TIME_UOM_CODE, RLM_RLMDMCOM_XMLP_PKG.cf_ship_from_org_idformula(RCSD.SHIP_FROM_ORG_ID) CF_SHIP_FROM_ORG_ID, RLM_RLMDMCOM_XMLP_PKG.cf_pre_horizon_disp_codeformul(RMA.UNSHIPPED_FIRM_DISP_CD) CF_PRE_HORIZON_DISP_CODE, RLM_RLMDMCOM_XMLP_PKG.cf_intransit_calc_basisformula(RMA.INTRANSIT_CALC_BASIS) CF_INTRANSIT_CALC_BASIS, RLM_RLMDMCOM_XMLP_PKG.cf_exclude_nonworkdaysformula(RMA.EXCLUDE_NON_WORKDAYS_FLAG) CF_EXCLUDE_NONWORKDAYS, RLM_RLMDMCOM_XMLP_PKG.cf_match_seqformula(RCSD.CUSTOMER_ITEM_REVISION, RCSD.CUSTOMER_DOCK_CODE, RCSD.CUSTOMER_JOB, RCSD.CUST_PRODUCTION_LINE, RCSD.CUST_MODEL_SERIAL_NUMBER, RCSD.CUST_PO_NUMBER, RCSD.CUST_PRODUCTION_SEQ_NUM, RCSD.RECORD_YEAR, RCSD.CUSTOMER_REQUEST_DATE, RCSD.PULL_SIGNAL_REF_NUM, RCSD.PULL_SIGNAL_START_SERIAL_NUM, RCSD.PULL_SIGNAL_END_SERIAL_NUM, DECODE ( :P_SCHEDULE_TYPE , 'SEQUENCED' , OLA.REQUEST_DATE , NULL )) CF_MATCH_SEQ, RLM_RLMDMCOM_XMLP_PKG.CP_SEQ_MATCH_LABEL_p CP_SEQ_MATCH_LABEL, RLM_RLMDMCOM_XMLP_PKG.CP_SEQ_COLUMN_p CP_SEQ_COLUMN, RLM_RLMDMCOM_XMLP_PKG.cf_ordernumformula(OLA.HEADER_ID) CF_ORDER_NUM FROM RLM_COMP_SCHED_TO_DEMAND_TEMP RCSD, RLM_MATCH_SETUP_TEMP RMA, OE_ORDER_LINES OLA, FND_LOOKUP_VALUES_VL FLV1 , FND_LOOKUP_VALUES_VL FLV2, FND_LOOKUP_VALUES_VL FLV3, FND_LOOKUP_VALUES_VL FLV4 WHERE RMA.CUSTOMER_ID = RCSD.CUSTOMER_ID AND RMA.SHIP_FROM_ORG_ID = RCSD.SHIP_FROM_ORG_ID AND RMA.SHIP_TO_ORG_ID = RCSD.SHIP_TO_ORG_ID AND RMA.CUSTOMER_ITEM_ID = RCSD.CUSTOMER_ITEM_ID AND RMA.INVENTORY_ITEM_ID = RCSD.INVENTORY_ITEM_ID AND OLA.SOURCE_DOCUMENT_LINE_ID(+) = RCSD.SCH_LINE_ID AND OLA.SOURCE_DOCUMENT_ID (+) = RCSD.SCH_HEADER_ID AND OLA.SOURCE_DOCUMENT_TYPE_ID(+) = 5 AND OLA.header_id (+)= RCSD.order_header_id AND OLA.inventory_item_id (+) = RCSD.inventory_item_id AND FLV1.LOOKUP_TYPE = 'RLM_DETAIL_TYPE_CODE' AND FLV1.LOOKUP_CODE =RCSD.ITEM_DETAIL_TYPE AND FLV1.ENABLED_FLAG ='Y' AND FLV2.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE' AND FLV2.LOOKUP_CODE =RCSD.ITEM_DETAIL_SUBTYPE AND FLV2.ENABLED_FLAG ='Y' AND FLV3.LOOKUP_CODE =RCSD.SCHEDULE_TYPE AND FLV3.LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE' AND FLV3.ENABLED_FLAG = 'Y' AND FLV4.LOOKUP_CODE = RCSD.SCHEDULE_PURPOSE AND FLV4.LOOKUP_TYPE = 'RLM_SCHEDULE_PURPOSE' AND FLV4.ENABLED_FLAG = 'Y' ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,15 ASC,14 ASC,13 ASC,10 ASC,12 ASC,9 ASC,8 ASC,11 ASC,17 ASC,18 ASC,33 ASC,32 ASC,26 ASC,59 ASC,38 ASC,65 ASC,36 ASC,35 ASC,34 ASC,31 ASC,30 ASC,29 ASC,28 ASC,27 ASC,21 ASC,25 ASC,24 ASC,22 ASC,20 ASC,23 ASC,19 ASC,37 ASC,16 ASC,43 ASC,58 ASC,57 ASC,39 ASC,40 ASC,41 ASC,42 ASC,44 ASC,45 ASC,46 ASC,47 ASC,48 ASC,49 ASC,50 ASC,51 ASC,55 ASC,52 ASC,53 ASC,54 ASC,56 ASC,60 ASC,61 ASC,69 ASC , RCSD.CUSTOMER_ID , RCSD.CREATION_DATE , RCSD.SHIP_FROM_ORG_ID , RCSD.SHIP_TO_ORG_ID , RCSD.CUSTOMER_ITEM_ID , RCSD.INVENTORY_ITEM_ID , RCSD.WEEK_START_DATE , REQUEST_DATE_NON_SEQUENCED , SCHEDULE_SHIP_DATE_NON_SEQ RLM RLMDMCOM_XML AR RLM تقرير مقارنة الجدول بالطلب Imported from BI Publisher Description: تقرير مقارنة الجدول بالطلب Application: إدارة بيانات الإصدار Source: تقرير مقارنة الجدول بالطلب (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG D RLM Plan mit Bedarf vergleichen Imported from BI Publisher Description: Auswertung "Plan mit Bedarf vergleichen" Application: Release Management Source: Plan mit Bedarf vergleichen (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG E RLM Informe Comparación de Programa con Demanda Imported from BI Publisher Description: Informe Comparación de Programa con Demanda Application: Release Management Source: Informe Comparación de Programa con Demanda (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG F RLM Etat Comparer le programme à la demande Imported from BI Publisher Description: Etat Comparer le programme à la demande Application: Release Management Source: Etat Comparer le programme à la demande (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG I RLM Rapporto Confronta programma con domanda Imported from BI Publisher Description: Rapporto Confronto programma con domanda Application: Release Management Source: Rapporto Confronta programma con domanda (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG JA RLM スケジュールと需要の比較レポート Imported from BI Publisher Description: スケジュールと需要の比較レポート Application: Release Management Source: スケジュールと需要の比較レポート(XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG KO RLM 스케줄과 수요 비교 보고서 Imported from BI Publisher Description: 스케줄과 수요 비교 보고서 Application: Release Management Source: 스케줄과 수요 비교 보고서(XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG PTB RLM Comparar Programação com Relatório de Demanda Imported from BI Publisher Description: Comparar Programação com Relatório de Demanda Application: Release Management Source: Comparar Programação com Relatório de Demanda (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG RU RLM Отчет о сравнении графика и спроса Imported from BI Publisher Description: Отчет о сравнении графика и спроса Application: Управление комплектованием Source: Отчет о сравнении графика и спроса (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG S RLM Jämför planen med behovsrapporten Imported from BI Publisher Description: Jämför planen med behovsrapporten Application: Release Management Source: Jämför planen med behovsrapporten (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG TR RLM Çizelge - Talep Karşılaştırma Raporu Imported from BI Publisher Description: Çizelge - Talep Karşılaştırma Raporu Application: Yayın Yönetimi Source: Çizelge - Talep Karşılaştırma Raporu (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG US RLM Compare Schedule To Demand Imported from BI Publisher Description: Compare Schedule To Demand Report Application: Release Management Source: Compare Schedule To Demand Report (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG ZHS RLM 比较计划和需求报表 Imported from BI Publisher Description: 比较计划和需求报表 Application: 发放管理 Source: 比较计划和需求报表 (XML) Short Name: RLMDMCOM_XML DB package: RLM_RLMDMCOM_XMLP_PKG BI Publisher :cp_default_ou :cp_p_demand_type :cp_p_discrepancies_only :cp_p_schedule_ref_num :cp_p_schedule_type :cp_p_seq_match_label :cp_p_ship_from :cp_p_ship_to :cp_seq_column :cp_seq_match_label :operating_unit :p_conc_request_id :p_customer_item_from :p_customer_item_to :p_customer_name_from :p_customer_name_to :p_demand_type :p_discrepancies_only :p_internal_item_from :p_internal_item_to :p_issue_date_from :p_issue_date_to :p_org_id :p_process_date_from :p_process_date_to :p_request_date_from :p_request_date_to :p_schedule_reference_num :p_schedule_type :p_seq_match_attribute :p_ship_from_org_id :p_ship_to :p_title :p_tp_code_from :p_tp_code_to :p_tp_location_from :p_tp_location_to 1 -20 :p_title Char Compare Schedule To Demand Report Y 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 标题 标题 2 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 3 10 :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 Y 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 计划类型 计划类型 4 20 :p_schedule_reference_num LOV Oracle RLM_SCHEDULE_REFNUM Y select header_id id, schedule_reference_num value, last_update_date description from rlm_schedule_headers where process_status in (5,7) and schedule_type=(:$flex$.rlm_schedule_type) order by last_update_date desc 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 计划参考编号 计划参考编号 5 30 :p_customer_name_from LOV Oracle RLM_CUSTOMER_NAMES Y select party.party_name 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 Von Kundenname Von Kundenname E De Nombre de Cliente De Nombre de Cliente F Nom du client - De Nom du client - De I Nome cliente - Da Nome cliente - Da JA 顧客名:自 顧客名:自 KO 고객명 From 고객명 From PTB Nome do Cliente - De Nome do Cliente - De RU Имя заказчика с Имя заказчика с S Från kundnamn Från kundnamn TR İlk Müşteri Adı İlk Müşteri Adı US Customer Name From Customer Name From ZHS 客户名称自 客户名称自 6 40 :p_customer_name_to LOV Oracle RLM_CUSTOMER_NAMES_T Y select party.party_name 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 SELECT :$flex$.customer_name_from from dual AR اسم العميل إلى اسم العميل إلى D Bis Kundenname Bis Kundenname E A Nombre del Cliente A Nombre del Cliente F Nom du client - A Nom du client - A I Nome cliente - A Nome cliente - A JA 顧客名:至 顧客名:至 KO 고객명 To 고객명 To PTB Nome do Cliente - Até Nome do Cliente - Até RU Имя заказчика по Имя заказчика по S Till kundnamn Till kundnamn TR Son Müşteri Adı Son Müşteri Adı US Customer Name To Customer Name To ZHS 客户名称至 客户名称至 7 50 :p_ship_from_org_id 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 Liefern von Liefern von E Origen del Envío Origen del Envío F Expédition Expédition I Spedisci da Spedisci da JA 出荷元 出荷元 KO 납품 출처 납품 출처 PTB Entregar de Entregar de RU Отправитель товара Отправитель товара S Avsändaradress Avsändaradress TR Sevk Çıkış Yeri Sevk Çıkış Yeri US Ship From Ship From ZHS 发货方 发货方 8 60 :p_ship_to LOV Oracle RLM_SHIP_TO_ADD 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 acct_site.cust_account_id in (select relate.cust_account_id from hz_cust_acct_relate relate,hz_parties party, hz_cust_accounts cust_acct where cust_acct.cust_account_id=relate.related_cust_account_id and cust_acct.party_id=party.party_id and party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A') union select cust_account_id from hz_parties party,hz_cust_accounts cust_acct where cust_acct.party_id=party.party_id and party.party_name between nvl(:$flex$.rlm_customer_names:null, party.party_name) and nvl(:$flex$.rlm_customer_names_t:null, party.party_name) ) 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 Enviar a Enviar a F Livraison à Livraison à I Spedisci a Spedisci a JA 出荷先 出荷先 KO 납품처 납품처 PTB Entregar para Entregar para RU Получатель товара Получатель товара S Lev.adress Lev.adress TR Sevk varış yeri Sevk varış yeri US Ship to Ship to ZHS 收货方 收货方 9 70 :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 发放日期自 发放日期自 10 80 :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 发放日期至 发放日期至 11 90 :p_request_date_from DateTime AR تاريخ الطلب من تاريخ الطلب من D Von Anforderungsdatum Von Anforderungsdatum E De Fecha de Solicitud De Fecha de Solicitud F Date de besoin - Du Date de besoin - Du I Data richiesta - Da Data richiesta - Da JA 要求日:自 要求日:自 KO 요청 일자: 부터 요청 일자: 부터 PTB Data da Solicitação - De Data da Solicitação - De RU Дата запроса с Дата запроса с S Från beställningsdatum Från beställningsdatum TR İlk Talep Tarihi İlk Talep Tarihi US Request Date From Request Date From ZHS 请求日期自 请求日期自 12 100 :p_request_date_to DateTime select fnd_date.date_to_chardt(fnd_date.canonical_to_date(:$flex$.request_date_from)) from dual AR تاريخ الطلب إلى تاريخ الطلب إلى D Bis Anforderungsdatum Bis Anforderungsdatum E A Fecha de Solicitud A Fecha de Solicitud F Date de besoin - Au Date de besoin - Au I Data richiesta - A Data richiesta - A JA 要求日:至 要求日:至 KO 요청 일자: 까지 요청 일자: 까지 PTB Data da Solicitação - Até Data da Solicitação - Até RU Дата запроса по Дата запроса по S Till önskat datum Till önskat datum TR Son Talep Tarihi Son Talep Tarihi US Request Date To Request Date To ZHS 请求日期至 请求日期至 13 110 :p_customer_item_from LOV Oracle RLM_CUST_ITEM_NUM Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items mci where mci.rowid=(select min(mci1.rowid) from mtl_customer_items mci1,hz_parties party,hz_cust_accounts cust_acct where mci.customer_item_number=mci1.customer_item_number and cust_acct.cust_account_id=mci1.customer_id and party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id) order by mci.customer_item_number AR صنف العميل من صنف العميل من D Von Kundenartikel Von Kundenartikel E De Artículo de Cliente De Artículo de Cliente F Article client - De Article client - De I Articolo cliente - Da Articolo cliente - Da JA 顧客品目:自 顧客品目:自 KO 고객 품목 From 고객 품목 From PTB Item do Cliente - De Item do Cliente - De RU Позиция заказчика с Позиция заказчика с S Från kundartikel Från kundartikel TR İlk Müşteri Kalemi İlk Müşteri Kalemi US Customer Item From Customer Item From ZHS 客户项目自 客户项目自 14 120 :p_customer_item_to LOV Oracle RLM_CUST_ITEM_NUM Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items mci where mci.rowid=(select min(mci1.rowid) from mtl_customer_items mci1,hz_parties party,hz_cust_accounts cust_acct where mci.customer_item_number=mci1.customer_item_number and cust_acct.cust_account_id=mci1.customer_id and party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id) order by mci.customer_item_number select :$flex$.customer_item_from from dual AR صنف العميل إلى صنف العميل إلى D Bis Kundenartikel Bis Kundenartikel E A Artículo de Cliente A Artículo de Cliente F Article client - A Article client - A I Articolo cliente - A Articolo cliente - A JA 顧客品目:至 顧客品目:至 KO 고객 품목 To 고객 품목 To PTB Item do Cliente - Até Item do Cliente - Até RU Позиция заказчика по Позиция заказчика по S Till kundartikel Till kundartikel TR Son Müşteri Kalemi Son Müşteri Kalemi US Customer Item To Customer Item To ZHS 客户项目至 客户项目至 15 130 :p_internal_item_from LOV Oracle RLM_INV_ITEM Y select item_number id, item_number value, description description from rlm_cust_inv_item_v1 order by item_number AR الصنف الداخلي من الصنف الداخلي من D Von Interner Artikel Von Interner Artikel E De Artículo Interno De Artículo Interno F Article interne - De Article interne - De I Articolo interno - Da Articolo interno - Da JA 内部品目:自 内部品目:自 KO 내부 품목 From 내부 품목 From PTB Item Interno - De Item Interno - De RU Внутренняя позиция с Внутренняя позиция с S Från intern artikel Från intern artikel TR İlk Dahili Kalem İlk Dahili Kalem US Internal Item From Internal Item From ZHS 内部项目自 内部项目自 16 140 :p_internal_item_to LOV Oracle RLM_INV_ITEM Y select item_number id, item_number value, description description from rlm_cust_inv_item_v1 order by item_number SELECT :$flex$.internal_item_from from dual AR الصنف الداخلي إلى الصنف الداخلي إلى D Bis Interner Artikel Bis Interner Artikel E A Artículo Interno A Artículo Interno F Article interne - A Article interne - A I Articolo interno - A Articolo interno - A JA 内部品目:至 内部品目:至 KO 내부 품목 To 내부 품목 To PTB Item Interno - Até Item Interno - Até RU Внутренняя позиция по Внутренняя позиция по S Till intern artikel Till intern artikel TR Son Dahili Kalem Son Dahili Kalem US Internal Item To Internal Item To ZHS 内部项目至 内部项目至 17 150 :p_tp_code_from LOV Oracle RLM_TP_F 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_acct_sites raa,hz_parties party,hz_cust_accounts cust_acct 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 party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id and etd1.tp_header_id=raa.tp_header_id and raa.cust_account_id=cust_acct.cust_account_id and cust_acct.party_id=party.party_id) order by etd.translator_code AR رمز الشريك التجاري من رمز الشريك التجاري من D Von Schlüssel Geschäftspartner Von Schlüssel Geschäftspartner E De Código de Partner Comercial De Código de Partner Comercial F Code partenaire commercial - De Code partenaire commercial - De I Codice partner commerciale - Da Codice partner commerciale - Da JA TPコード:自 TPコード:自 KO TP 코드 From TP 코드 From PTB Código TP - De Código TP - De RU Код ТП с Код ТП с S Från HP-kod Från HP-kod TR İlk Ticari Ortak Kodu İlk Ticari Ortak Kodu US TP Code From TP Code From ZHS TP 代码自 TP 代码自 18 160 :p_tp_code_to LOV Oracle RLM_TP_T 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_acct_sites raa,hz_parties party,hz_cust_accounts cust_acct 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 party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id and etd1.tp_header_id=raa.tp_header_id and raa.cust_account_id=cust_acct.cust_account_id and cust_acct.party_id=party.party_id) order by etd.translator_code SELECT :$flex$.tp_code_from from dual AR رمز الشريك التجاري إلى رمز الشريك التجاري إلى D Bis Schlüssel Geschäftspartner Bis Schlüssel Geschäftspartner E A Código de Partner Comercial A Código de Partner Comercial F Code partenaire commercial - A Code partenaire commercial - A I Codice partner commerciale - A Codice partner commerciale - A JA TPコード:至 TPコード:至 KO TP 코드 To TP 코드 To PTB Código TP - Até Código TP - Até RU Код ТП по Код ТП по S Till HP-kod Till HP-kod TR Son Ticari Ortak Kodu Son Ticari Ortak Kodu US TP Code To TP Code To ZHS TP 代码至 TP 代码至 19 170 :p_tp_location_from LOV Oracle RLM_TP_LOC_CODES 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_parties party,hz_cust_accounts cust_acct where raa.ece_tp_location_code=raa1.ece_tp_location_code and raa1.cust_account_id=cust_acct.cust_account_id and etd.tp_header_id=raa1.tp_header_id and etd.translator_code between nvl(:$flex$.rlm_tp_f:null,etd.translator_code) and nvl(:$flex$.rlm_tp_t:null,etd.translator_code) and party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id) order by raa.ece_tp_location_code AR موقع الشريك التجاري من موقع الشريك التجاري من D Von Standort Geschäftspartner Von Standort Geschäftspartner E De Ubicación de Partner Comercial De Ubicación de Partner Comercial F Lieu partenaire commercial - De Lieu partenaire commercial - De I Ubicazione partner commerciale - Da Ubicazione partner commerciale - Da JA TP事業所:自 TP事業所:自 KO TP 위치 From TP 위치 From PTB Local TP - De Local TP - De RU Расположение ТП с Расположение ТП с S Från HP-adress Från HP-adress TR İlk Ticari Ortak Yerleşimi İlk Ticari Ortak Yerleşimi US TP Location From TP Location From ZHS TP 地点自 TP 地点自 20 180 :p_tp_location_to LOV Oracle RLM_TP_LOC_CODES 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_parties party,hz_cust_accounts cust_acct where raa.ece_tp_location_code=raa1.ece_tp_location_code and raa1.cust_account_id=cust_acct.cust_account_id and etd.tp_header_id=raa1.tp_header_id and etd.translator_code between nvl(:$flex$.rlm_tp_f:null,etd.translator_code) and nvl(:$flex$.rlm_tp_t:null,etd.translator_code) and party.party_name between nvl(:$flex$.rlm_customer_names:null,party.party_name) and nvl(:$flex$.rlm_customer_names_t:null,party.party_name) and cust_acct.party_id=party.party_id) order by raa.ece_tp_location_code SELECT :$flex$.tp_location_from from dual AR موقع الشريك التجاري إلى موقع الشريك التجاري إلى D Bis Standort Geschäftspartner Bis Standort Geschäftspartner E A Ubicación de Partner Comercial A Ubicación de Partner Comercial F Lieu partenaire commercial - A Lieu partenaire commercial - A I Ubicazione partner commerciale - A Ubicazione partner commerciale - A JA TP事業所:至 TP事業所:至 KO TP 위치 To TP 위치 To PTB Local TP - Até Local TP - Até RU Расположение ТП по Расположение ТП по S Till HP-adress Till HP-adress TR Son Ticari Ortak Yerleşimi Son Ticari Ortak Yerleşimi US TP Location To TP Location To ZHS TP 地点至 TP 地点至 21 190 :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 处理日期自 处理日期自 22 200 :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 处理日期至 处理日期至 23 210 :p_seq_match_attribute LOV Oracle RLM_SEQ_MATCH_ATTRIBUTE Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type like 'RLM_OPTIONAL_MATCH_ATTRIBUTES' and enabled_flag='Y' and substr(lookup_code,(instr(lookup_code,',',1))+1,1) in ('B','F','G','A','H','E','$','I','J','K','L','M','C') and :$flex$.rlm_schedule_type='SEQUENCED' order by value,description AR سمة مطابقة المسلسل سمة مطابقة المسلسل D Abgleichsattribut Sortierung Abgleichsattribut Sortierung E Atributo de Correspondencia de Secuencia Atributo de Correspondencia de Secuencia F Attribut de correspondance du numéro d'ordre Attribut de correspondance du numéro d'ordre I Attributo corrispondente sequenza Attributo corrispondente sequenza JA 順序照合属性 順序照合属性 KO 일련순서 대응 속성 일련순서 대응 속성 PTB Atributo de Correspondência de Sequência Atributo de Correspondência de Sequência RU Атрибут сопоставления номеров Атрибут сопоставления номеров S Sekvensmatchningsattribut Sekvensmatchningsattribut TR Sıra Eşleşme Özelliği Sıra Eşleşme Özelliği US Sequence Matching Attribute Sequence Matching Attribute ZHS 序号匹配属性 序号匹配属性 24 220 :p_demand_type LOV Oracle RLM_FIRM_FORECAST_BOTH Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_FIRM_FORECAST_BOTH' order by value,description Select meaning from fnd_common_lookups where lookup_type = 'RLM_FIRM_FORECAST_BOTH' and lookup_code = 'B' AR نوع الطلب متطلبات (ث)ابتة وت(ق)ديرية و(ك)لاهما D Bedarfsart Anforderungen (F)ix, Pr(o)gnose, (B)eide E Tipo de Demanda Requisitos en (F)irme, Previsi(ó)n, Am(b)os F Type de demande Besoins (F)ermes, P(R)évision, Les (D)eux I Tipo di domanda Requisiti (s)tabili, (p)revisti, (e)ntrambi JA 需要タイプ 要求 確定(F)、予測(O)、両方(B) KO 수요 유형 소요량 확정, 예측, 양쪽 모두 PTB Tipo de Demanda Necessidades (F)irmes, P(R)evisão, (A)mbos RU Тип спроса Потребности: (з)акрепленные, (п)рогнозируемые, (в)се S Efterfrågetyp Behov - (F)asta, (P)rognos, (B)åda TR Talep Tipi Gereksinimler (K)esin, (T)ahmini, (H)er İkisi US Demand Type Requirements (F)irm, F(O)recast, (B)oth ZHS 需求类型 需求固定(&F)、预测(&O)、两者兼有(&B) 25 230 :p_discrepancies_only 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 Nur Differenzen Nur Differenzen E Sólo Discrepancias Sólo Discrepancias F Ecarts uniquement Ecarts uniquement I Solo discrepanze Solo discrepanze JA 差異のみ 差異のみ KO 불일치만 불일치만 PTB Somente Discrepâncias Somente Discrepâncias RU Только расхождения Только расхождения S Endast avvikelser Endast avvikelser TR Salt Uyuşmazlıklar Salt Uyuşmazlıklar US Discrepancies Only Discrepancies Only ZHS 仅限于差异 仅限于差异