ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B451A9E05362FB09050512Y select wnd.name delivery, wnd.delivery_id delivery_id, substrb(cust.party_name,1,50) customer, wpb.name name, wsh_util_core.get_location_description(wnd.INITIAL_PICKUP_LOCATION_ID, 'NEW UI CODE') ship_from, wsh_util_core.get_location_description(wnd.ULTIMATE_DROPOFF_LOCATION_ID, 'NEW UI CODE') ship_to, wnd.INITIAL_PICKUP_DATE pickup_date1, wnd.ULTIMATE_DROPOFF_DATE dropoff_date1, lv.meaning ship_method, wdi.sequence_number bol, wnd.WAYBILL waybill, wnd.GROSS_WEIGHT gross_weight, wnd.WEIGHT_UOM_CODE uom, we.exception_id, decode(:p_batch_type, 'SC', decode(wnd.status_code, 'CO', 'Y', 'IT','Y', 'CL','Y', 'N'), NULL) shipped, decode(we.exception_id, NULL, 'Y' ,decode(we.error_message,'E', 'N', 'Y')) packed, WSH_WSHRDASP_XMLP_PKG.cf_1formula(wnd.delivery_id) CF_trip_name, WSH_WSHRDASP_XMLP_PKG.cf_message(we.exception_id) CF_message, wsh_util_core.get_location_description(wnd.ULTIMATE_DROPOFF_LOCATION_ID, 'NEW UI CODE') ship_to, to_char(wnd.INITIAL_PICKUP_DATE,'DD-MON-YY') pickup_date, to_char(wnd.ULTIMATE_DROPOFF_DATE ,'DD-MON-YY') dropoff_date, lv.meaning ship_method, wdi.sequence_number bol, wnd.WAYBILL waybill, -- wnd.GROSS_WEIGHT gross_weight, wnd.WEIGHT_UOM_CODE uom, we.exception_id, decode(:p_batch_type, 'SC', decode(wnd.status_code, 'CO', 'Y', 'IT','Y', 'CL','Y', 'N'), NULL) shipped, decode(we.exception_id, NULL, 'Y' ,decode(we.error_message,'E', 'N', 'Y')) packed from wsh_new_deliveries wnd, wsh_picking_batches wpb, wsh_exceptions we, fnd_lookup_values_vl lv, wsh_delivery_legs wdl,wsh_document_instances wdi, ( select cust_acct.cust_account_id, party.party_name from hz_cust_accounts cust_acct, hz_parties party where party.party_id = cust_acct.party_id ) cust where nvl(wnd.shipment_direction, 'O') IN ('O', 'IO') and wnd.delivery_type = 'STANDARD' and wpb.batch_id = decode(:p_batch_type, 'SC', wnd.batch_id, 'AP', wnd.ap_batch_id, wpb.batch_id) and &p_pr_batch &lp_bol_number &p_exceptions we.delivery_id(+) = wnd.delivery_id and we.exception_name(+) = 'WSH_BATCH_MESSAGE' and lv.lookup_code(+) = wpb.ship_method_code and lv.lookup_type(+) = 'SHIP_METHOD' and lv.view_application_id(+) = 3 and cust.cust_account_id (+)=wnd.customer_id and wdi.entity_id (+) = wdl.delivery_leg_id AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS' AND wdi.document_type (+) = 'BOL' AND wdi.status (+) <> 'CANCELLED' AND wnd.delivery_id = wdl.delivery_id (+) ORDER BY 16 DESC,15 DESC,3 ASC,5 ASC,4 ASC,13 ASC,12 ASC,7 ASC,11 ASC,10 ASC,9 ASC,8 ASC,6 ASC,1 ASC,2 ASC WSH WSHRDASC_XML AR WSH تقرير تأكيد الشحن الآلي (بتنسيق XML) Imported from BI Publisher Application: تنفيذ الشحن Source: تقرير تأكيد الشحن الآلي (بتنسيق XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG D WSH Automatische Lieferbestätigung Imported from BI Publisher Application: Shipping Execution Source: Automatische Lieferbestätigung (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG E WSH Informe de Confirmación de Envío Automático Imported from BI Publisher Application: Shipping Execution Source: Informe de Confirmación de Envío Automático (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG F WSH Etat Confirmation d'expédition automatique Imported from BI Publisher Application: Shipping Execution Source: Etat Confirmation d'expédition automatique (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG I WSH Rapporto Conferma spedizione automatica Imported from BI Publisher Application: Shipping Execution Source: Rapporto Conferma spedizione automatica (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG JA WSH 自動出荷確認レポート Imported from BI Publisher Application: Shipping Execution Source: 自動出荷確認レポート(XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG KO WSH 자동 출하 확정 보고서 Imported from BI Publisher Application: Shipping Execution Source: 자동 출하 확정 보고서(XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG PTB WSH Relatório de Confirmação de Entrega Automática Imported from BI Publisher Application: Execução da Entrega Source: Relatório de Confirmação de Entrega Automática (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG RU WSH Отчет об автоподтверждении отгрузки Imported from BI Publisher Application: Выполнение отгрузки Source: Отчет об автоподтверждении отгрузки (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG S WSH Autoleveransbekräftelse - rapport Imported from BI Publisher Application: Shipping Execution Source: Autoleveransbekräftelse - rapport (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG TR WSH Otomatik Sevk Onay Raporu Imported from BI Publisher Application: Sevkiyat Yönetimi Source: Otomatik Sevk Onay Raporu (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG US WSH Auto Ship Confirm Imported from BI Publisher Application: Shipping Execution Source: Auto Ship Confirm Report (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG ZHS WSH 自动发运确认报表 Imported from BI Publisher Application: 发运管理系统 Source: 自动发运确认报表 (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG BI Publisher &lp_bol_number &p_exceptions &p_pr_batch :cp_auto_confirm_rule :cp_batch_id :cp_batch_name :cp_customer :cp_delivery_from :cp_delivery_to :cp_dropoff_date_from :cp_dropoff_date_to :cp_exceptions_only :cp_message :cp_org :cp_pickup_date_from :cp_pickup_date_to :cp_pr_batch :cp_ship_from :cp_ship_method :cp_ship_to :cp_trip_id :cp_trip_name :lp_bol_number :lp_dropoff_date_from :lp_dropoff_date_to :lp_pickup_date_from :lp_pickup_date_to :p_ap_batch_id :p_auto_sc_message :p_batch :p_batch_number :p_batch_type :p_bol_from :p_bol_to :p_conc_request_id :p_customer_id :p_delivery_from :p_delivery_to :p_dropoff_date_from :p_dropoff_date_to :p_exceptions :p_exceptions_only :p_org :p_pickup_date_from :p_pickup_date_to :p_planned_flag :p_pr_batch :p_pr_batch_id :p_sc_batch_id :p_sc_rule_id :p_ship_from :p_ship_method_code :p_ship_to 1 -20 :p_batch_type LOV Oracle WSH_SC_BATCH_TYPE Y select 'SC' id, 'SC' value, null description from dual order by value,description SC AR نوع المجموعة نوع المجموعة D Stapelart Stapelart E Tipo de Lote Tipo de Lote F Type de lot Type de lot I Tipo batch Tipo batch JA バッチ・タイプ バッチ・タイプ KO 뱃치 유형 뱃치 유형 PTB Tipo de Lote Tipo de Lote RU Тип пакета Тип пакета S Batchtyp Batchtyp TR İşlem Grubu Tipi İşlem Grubu Tipi US Batch Type Batch Type ZHS 批类型 批类型 2 10 :p_sc_batch_id LOV Oracle WSH_SC_BATCH Y select batch_id id, name value, null description from wsh_picking_batches where ship_confirm_rule_id is not null order by value,description AR مجموعة تأكيد الشحن مجموعة تأكيد الشحن D Stapel Lieferbestätigung Stapel Lieferbestätigung E Lote de Confirmación de Envío Lote de Confirmación de Envío F Lot de confirmation des expéditions Lot de confirmation des expéditions I Batch conferma spedizione Batch conferma spedizione JA 出荷確認バッチ 出荷確認バッチ KO 출하 확정 뱃치 출하 확정 뱃치 PTB Lote de Confirmação de Entrega Lote de Confirmação de Entrega RU Пакет подтверждения отгрузки Пакет подтверждения отгрузки S Batch för leveransbekräftelse Batch för leveransbekräftelse TR Sevk Onay İşlem Grubu Sevk Onay İşlem Grubu US Ship Confirm Batch Ship Confirm Batch ZHS 发运确认批 发运确认批 3 20 :p_sc_rule_id LOV Oracle WSH_SHIP_CONFIRM_RULES Y select ship_confirm_rule_id id, name value, null description from wsh_ship_confirm_rules where effective_start_date<=sysdate and nvl(effective_end_date,sysdate)>=sysdate order by name AR قاعدة تأكيد الشحن قاعدة تأكيد الشحن D Lieferbestätigungsregel Lieferbestätigungsregel E Regla de Confirmación de Envío Regla de Confirmación de Envío F Règle de confirmation des expéditions Règle de confirmation des expéditions I Regola conferma spedizione Regola conferma spedizione JA 出荷確認ルール 出荷確認ルール KO 출하 확정 규칙 출하 확정 규칙 PTB Regra de Confirmação de Entrega Regra de Confirmação de Entrega RU Правило подтверждения отгрузки Правило подтверждения отгрузки S Regel för leveransbekräftelse Regel för leveransbekräftelse TR Sevk Onay Kuralı Sevk Onay Kuralı US Ship Confirm Rule Ship Confirm Rule ZHS 发运确认规则 发运确认规则 4 30 :p_delivery_from LOV Oracle WSH_DELIVERIES Y select delivery_id id, name value, null description from wsh_new_deliveries where nvl(shipment_direction,'O') in ('O','IO') and delivery_type='STANDARD' order by value,description AR التسليم من التسليم من D Von Auslieferung Von Auslieferung E De Entrega De Entrega F Livraison - De Livraison - De I Consegna - Da Consegna - Da JA 搬送元 搬送元 KO 납품: 부터 납품: 부터 PTB Distribuição - De Distribuição - De RU Доставка с Доставка с S Leverans från Leverans från TR Teslim Eden Teslim Eden US Delivery From Delivery From ZHS 交货自 交货自 5 40 :p_delivery_to LOV Oracle WSH_DELIVERIES Y select delivery_id id, name value, null description from wsh_new_deliveries where nvl(shipment_direction,'O') in ('O','IO') and delivery_type='STANDARD' order by value,description AR التسليم إلى التسليم إلى D Bis Auslieferung Bis Auslieferung E A Entrega A Entrega F Livraison - A Livraison - A I Consegna - A Consegna - A JA 搬送先 搬送先 KO 수령처 수령처 PTB Distribuição - Até Distribuição - Até RU Доставка по Доставка по S Mottagningsplats Mottagningsplats TR Son Teslimat Son Teslimat US Delivery To Delivery To ZHS 交货至 交货至 6 50 :p_bol_from LOV Oracle WSH_QS_BOLS Y select sequence_number id, sequence_number value, null description from wsh_document_instances where entity_name='WSH_DELIVERY_LEGS' and document_type='BOL' and status<>'CANCELED' and entity_id in ( select wlg.delivery_leg_id from wsh_new_deliveries wnd,wsh_delivery_legs wlg where wnd.delivery_id=wlg.delivery_id) order by sequence_number AR بوليصة الشحن من بوليصة الشحن من D Von Frachtbrief Von Frachtbrief E De Conocimiento de Embarque De Conocimiento de Embarque F Bordereau de chargement - De Bordereau de chargement - De I Polizza di carico - Da Polizza di carico - Da JA 船荷証券:自 船荷証券:自 KO 선하증권 From 선하증권 From PTB Conhecimento de Embarque - De Conhecimento de Embarque - De RU Коносамент с Коносамент с S Konossement från Konossement från TR İlk Konşimento İlk Konşimento US Bill of Lading From Bill of Lading From ZHS 提单自 提单自 7 60 :p_bol_to LOV Oracle WSH_QS_BOLS Y select sequence_number id, sequence_number value, null description from wsh_document_instances where entity_name='WSH_DELIVERY_LEGS' and document_type='BOL' and status<>'CANCELED' and entity_id in ( select wlg.delivery_leg_id from wsh_new_deliveries wnd,wsh_delivery_legs wlg where wnd.delivery_id=wlg.delivery_id) order by sequence_number AR بوليصة الشحن إلى بوليصة الشحن إلى D Bis Frachtbrief Bis Frachtbrief E A Conocimiento de Embarque A Conocimiento de Embarque F Bordereau de chargement - A Bordereau de chargement - A I Polizza di carico - A Polizza di carico - A JA 船荷証券:至 船荷証券:至 KO 선하증권 수령처 선하증권 수령처 PTB Conhecimento de Embarque - Até Conhecimento de Embarque - Até RU Коносамент по Коносамент по S Konossement till Konossement till TR Son Konşimento Son Konşimento US Bill of Lading To Bill of Lading To ZHS 提单至 提单至 8 70 :p_customer_id LOV Oracle WSH_SRS_CONSIGNEES Y Y select consignee_id id, party_name value, customer_number description from wsh_consignees_v order by value,description AR العميل العميل D Kunde Kunde E Cliente Cliente F Client Client I Cliente Cliente JA 顧客 顧客 KO 고객 고객 PTB Cliente Cliente RU Заказчик Заказчик S Kund Kund TR Müşteri Müşteri US Customer Customer ZHS 客户 客户 9 80 :p_ship_from LOV Oracle WSH_SRS_LOCATIONS_ALL Y select wsh_location_id id, ui_short_location_code value, ui_location_code description from wsh_locations_v order by ui_short_location_code AR شحن من العنوان شحن من العنوان D Versandadresse Versandadresse E Dirección de Origen del Envío Dirección de Origen del Envío F Adresse d'expédition Adresse d'expédition I Indirizzo origine spedizione Indirizzo origine spedizione JA 出荷元所在地 出荷元所在地 KO 출고처 주소 출고처 주소 PTB Endereço de Entrega Endereço de Entrega RU Адрес отправителя товара Адрес отправителя товара S Avsändaradresser Avsändaradresser TR Sevk Çıkış Adresi Sevk Çıkış Adresi US Ship From Address Ship From Address ZHS 发货地址 发货地址 10 90 :p_ship_to LOV Oracle WSH_SRS_LOCATIONS_ALL Y select wsh_location_id id, ui_short_location_code value, ui_location_code description from wsh_locations_v order by ui_short_location_code AR شحن إلى عنوان شحن إلى عنوان D Lieferadresse Lieferadresse E Dirección de Envío Dirección de Envío F Adresse de livraison Adresse de livraison I Indirizzo di spedizione Indirizzo di spedizione JA 出荷先所在地 出荷先所在地 KO 납품처 주소 납품처 주소 PTB Endereço para Entrega Endereço para Entrega RU Адрес получателя товара Адрес получателя товара S Leveransadress Leveransadress TR Sevk Varış Adresi Sevk Varış Adresi US Ship To Address Ship To Address ZHS 收货地址 收货地址 11 100 :p_pickup_date_from Date AR تاريخ الالتقاط من تاريخ الالتقاط من D Von Abholdatum Von Abholdatum E De Fecha de Recogida De Fecha de Recogida F Date de chargement - Du Date de chargement - Du I Data prelievo - Da Data prelievo - Da JA 荷積日:自 荷積日:自 KO 선적 일자: 부터 선적 일자: 부터 PTB Data da Retirada - De Data da Retirada - De RU Дата погрузки с Дата погрузки с S Hämtningsdatum från Från hämtningsdatum TR Toplama Başlangıç Tarihi Toplama Başlangıç Tarihi US Pick-up Date from Pick-up Date From ZHS 装货起始日期 装货起始日期 12 110 :p_pickup_date_to Date AR تاريخ الالتقاط إلى تاريخ الالتقاط إلى D Bis Abholdatum Bis Abholdatum E A Fecha de Recogida A Fecha de Recogida F Date de chargement - Au Date de chargement - Au I Data prelievo - A Data prelievo - A JA 荷積日:至 荷積日:至 KO 선적 일자: 까지 선적 일자: 까지 PTB Data da Retirada - Até Data da Retirada - Até RU Дата погрузки по Дата погрузки по S Hämtningsdatum till Hämtningsdatum till TR Toplama Bitiş Tarihi Toplama Bitiş Tarihi US Pick-up Date To Pick-up Date To ZHS 装货终止日期 装货终止日期 13 120 :p_dropoff_date_from Date AR تاريخ الإسقاط من تاريخ الإسقاط من D Von Zustelldatum Von Zustelldatum E De Fecha de Entrega De Fecha de Entrega F Date de livraison - Du Date de livraison - Du I Data scarico - Da Data scarico - Da JA 荷降日:自 荷降日:自 KO 하역 일자: 부터 하역 일자: 부터 PTB Data de Entrega - De Data de Entrega - De RU Дата выгрузки с Дата выгрузки с S Från lämningsdatum Från lämningsdatum TR Boşaltma Başlangıç Tarihi Boşaltma Başlangıç Tarihi US Drop-off Date From Drop-off Date From ZHS 卸货起始日期 卸货起始日期 14 130 :p_dropoff_date_to Date AR تاريخ الإسقاط إلى تاريخ الإسقاط إلى D Bis Zustelldatum Bis Zustelldatum E A Fecha de Entrega A Fecha de Entrega F Date de livraison - Au Date de livraison - Au I Data scarico - A Data scarico - A JA 荷降日:至 荷降日:至 KO 하역 일자: 까지 하역 일자: 까지 PTB Data de Entrega - Até Data de Entrega - Até RU Дата выгрузки по Дата выгрузки по S Lämningsdatum till Lämningsdatum till TR Boşaltma Bitiş Tarihi Boşaltma Bitiş Tarihi US Drop-off Date To Drop-off Date To ZHS 卸货终止日期 卸货终止日期 15 140 :p_planned_flag LOV Oracle WSH_SRS_DEL_PLANNED_FLAG Y select lookup_code id, meaning value, null description from fnd_lookup_values_vl where lookup_type='DELIVERY_PLANNED_FLAG' and nvl(start_date_active,sysdate)<=sysdate and nvl(end_date_active,sysdate)>=sysdate and enabled_flag='Y' order by decode(lookup_code,'N',1,'Y',2,3) AR موقف التأكيد المخطط D Fixierungsstatus Geplant E Estado En Firme Planificada F Statut Confirmé Planifié I Stabilisci stato Pianificato JA 確定ステータス 計画済 KO 확정 상태 계획 PTB Status Firme Planejado RU Статус закрепления Запланировано S Status: Fast Planerad TR Kesinlik Statüsü Planlı US Firm Status Planned ZHS 固定状态 已计划 16 150 :p_ship_method_code LOV Oracle WSH_SRS_FREIGHT_CARRIER Y Y select lookup_code id, meaning value, description description from fnd_lookup_values_vl where view_application_id=3 and lookup_type='SHIP_METHOD' and exists (select 1 from wsh_carrier_services wcs,wsh_carriers wc where wcs.ship_method_code=lookup_code and wcs.carrier_id=wc.carrier_id and nvl(wc.generic_flag,'N')='N') order by lookup_code AR طريقة الشحن طريقة الشحن D Versandart Versandart E Método de Envío Método de Envío F Mode d'expédition Mode d'expédition I Metodo di spedizione Metodo di spedizione JA 出荷方法 出荷方法 KO 운송 방법 운송 방법 PTB Mét. de Entrega Mét. de Entrega RU Метод отгрузки Метод отгрузки S Leveransmetod Leveransmetod TR Sevk Yöntemi Sevk Yöntemi US Ship Method Ship Method ZHS 发运方法 发运方法 17 160 :p_pr_batch_id LOV Oracle WSH_QS_RP_PICKING_BATCH Y select batch_id id, name value, null description from wsh_picking_batches a where nvl(a.non_picking_flag,'N')<>'Y' and exists (select b.batch_id from wsh_delivery_details b where b.batch_id=a.batch_id) order by value,description AR مجموعة إصدار الانتقاء مجموعة إصدار الانتقاء D Stapel Entnahmefreigabe Stapel Entnahmefreigabe E Lote de Lanzamiento a Acopio Lote de Lanzamiento a Acopio F Lot de lancement des prélèvements Lot de lancement des prélèvements I Batch rilascio per prelievo Batch rilascio per prelievo JA ピック・リリース・バッチ ピック・リリース・バッチ KO 출고 지시 뱃치 출고 지시 뱃치 PTB Lote de Liberação para Separação Lote de Liberação para Separação RU Пакет комплектования Пакет комплектования S Batch för plockningsavisering Batch för plockningsavisering TR Toplama Emri İşlem Grubu Toplama Emri İşlem Grubu US Pick Release Batch Pick Release Batch ZHS 挑库发放批 挑库发放批 18 170 :p_exceptions_only LOV Oracle WSH_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR الاستثناءات فقط الاستثناءات فقط D Nur Ausnahmen Nur Ausnahmen E Sólo Excepciones Sólo Excepciones F Incidents uniquement Incidents uniquement I Solo eccezioni Solo eccezioni JA 例外のみ 例外のみ KO 예외사항만 예외사항만 PTB Somente Exceções Somente Exceções RU Только исключения Только исключения S Endast undantag Endast undantag TR Salt İstisnalar Salt İstisnalar US Exceptions Only Exceptions Only ZHS 仅限于例外 仅限于例外