ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B351A9E05362FB09050512Y 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 party.party_name, cust_acct.cust_account_id, 'C' consignee_flag FROM hz_parties party, hz_cust_accounts cust_acct WHERE cust_acct.party_id = party.party_id UNION SELECT party.party_name, pv.vendor_id cust_account_id, 'V' consignee_flag FROM hz_parties party, po_vendors pv WHERE pv.party_id = party.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 cust.consignee_flag (+)= NVL(wnd.consignee_flag,'C') 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 WSHRDAPK_XML AR WSH تقرير التعبئة الآلية (بتنسيق XML) Imported from BI Publisher Application: تنفيذ الشحن Source: تقرير التعبئة الآلية (بتنسيق XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG D WSH Automatisch packen Imported from BI Publisher Application: Shipping Execution Source: Automatisch packen (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG E WSH Informe Embalaje Automático Imported from BI Publisher Application: Shipping Execution Source: Informe Embalaje Automático (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG F WSH Etat Colisage automatique Imported from BI Publisher Application: Shipping Execution Source: Etat Colisage automatique (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG I WSH Rapporto Imballaggio automatico Imported from BI Publisher Application: Shipping Execution Source: Rapporto Imballaggio automatico (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG JA WSH 自動梱包レポート Imported from BI Publisher Application: Shipping Execution Source: 自動梱包レポート(XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG KO WSH 자동 포장 보고서 Imported from BI Publisher Application: Shipping Execution Source: 자동 포장 보고서(XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG PTB WSH Relatório para Empacotamento Automático Imported from BI Publisher Application: Execução da Entrega Source: Relatório para Empacotamento Automático (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG RU WSH Отчет об автоупаковке Imported from BI Publisher Application: Выполнение отгрузки Source: Отчет об автоупаковке (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG S WSH Autopacka - rapport Imported from BI Publisher Application: Shipping Execution Source: Autopacka - rapport (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG TR WSH Otomatik Yükleme Raporu Imported from BI Publisher Application: Sevkiyat Yönetimi Source: Otomatik Yükleme Raporu (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG US WSH Auto-pack Imported from BI Publisher Application: Shipping Execution Source: Auto-pack Report (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG ZHS WSH 自动装箱报表 Imported from BI Publisher Application: 发运管理系统 Source: 自动装箱报表 (XML) Short Name: WSHRDAPK_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 -10 :p_batch_type LOV Oracle WSH_AP_BATCH_TYPE Y select 'AP' id, 'AP' value, null description from dual order by value,description AP 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_ap_batch_id LOV Oracle WSH_AP_BATCHES Y select a.batch_id id, a.name value, null description from wsh_picking_batches a where a.autopack_flag='Y' and exists ( select 1 from wsh_new_deliveries b where a.batch_id=b.ap_batch_id and b.delivery_type='STANDARD') order by a.name AR مجموعة التعبئة الآلية مجموعة التعبئة الآلية D Stapel Automatisch packen Stapel Automatisch packen E Lote de Empaquetado Automático Lote de Empaquetado Automático F Lot de colisage automatique Lot de colisage automatique I Batch imballaggio automatico Batch imballaggio automatico JA 自動梱包バッチ 自動梱包バッチ KO 자동 포장 뱃치 자동 포장 뱃치 PTB Acondicionar Lote Automaticamente Acondicionar Lote Automaticamente RU Пакет автоупаковки Пакет автоупаковки S Batch för autopackning Batch för autopackning TR Otomatik Yükleme İşlem Grubu Otomatik Yükleme İşlem Grubu US Auto-pack Batch Auto-pack Batch ZHS 自动装箱批 自动装箱批 3 20 :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 التسليم من Delivery _from D Von Auslieferung Von Auslieferung E De Entrega De Entrega F Livraison - De Livraison - De I Consegna - Da Consegna - Da JA 搬送元 搬送元 KO 수령 출처 Delivery _from PTB Distribuição - De Distribuição - De RU Доставка с Доставка с S Leverans från Leverans från TR İlk Teslimat İlk teslimat US Delivery From Delivery _from ZHS 交货自 交货自 4 30 :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 交货至 交货至 5 40 :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 Bord. chargt (De) Bord. chargt (De) I Polizza di carico - Da Polizza di carico - Da JA BOL:自 BOL:自 PTB BOL De BOL De RU Коносамент с Коносамент с S Fraktsedel från Fraktsedel från TR İlk Konşimento İlk Konşimento US BOL From BOL From ZHS 提单自 提单自 6 50 :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 Bord. chargt (A) Bord. chargt (A) I Polizza di carico - A Polizza di carico - A JA BOL:至 BOL:至 PTB BOL Até BOL Até RU Коносамент по Коносамент по S Fraktsedel till Fraktsedel till TR Son Konşimento Son Konşimento US BOL To BOL To ZHS 提单至 提单至 7 60 :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 客户 客户 8 70 :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 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 发货方 发货方 9 80 :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 Liefern an Liefern an E Dirección de Envío Dirección de 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 收货方 收货方 10 90 :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 Från hämtningsdatum Från hämtningsdatum TR Toplama Başlangıç Tarihi Toplama Başlangıç Tarihi US Pick-up Date From Pick-up Date From ZHS 装货起始日期 装货起始日期 11 100 :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 装货终止日期 装货终止日期 12 110 :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 Lämningsdatum från TR Boşaltma Başlangıç Tarihi Boşaltma Başlangıç Tarihi US Drop-off Date From Drop-off Date from ZHS 卸货起始日期 卸货起始日期 13 120 :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 卸货终止日期 卸货终止日期 14 130 :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 固定状态 已计划 15 140 :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 发运方法 发运方法 16 150 :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 挑库发放批 挑库发放批 17 160 :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 仅限于例外 仅限于例外