ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5313869E053B46B63588994 select wdd.delivery_detail_id ,wdd.customer_id ,wdd.ship_to_location_id ship_to_location_id ,wnd.name ,to_char(oe1.request_date,'DD-MON-YYYY HH24:MI') request_date ,to_char(oe1.schedule_ship_date,'DD-MON-YYYY HH24:MI') schedule_ship_date ,mr.lpn_id ,wt.name trip_name ,wdd.source_header_number Barcode ,wdd.source_header_number ,to_char(oe1.line_number)||'.'||to_char(oe1.shipment_number)||decode(oe1.option_number,NULL,NULL,'.'||to_char(oe1.option_number))||decode(oe1.component_number, null, null,decode(oe1.option_number, null, '.',null)||'.'||to_char(oe1.component_number)) line_number ,wdd.inventory_item_id ,&p_item_flex_all c_item_flex_all ,wdd.item_description ,mr.revision ,wdd.requested_quantity_uom ,SUM(wdd.requested_quantity) sum_requested_qty ,wdd.project_id ,wdd.task_id , oes.set_name ,oe1.ship_tolerance_above ,oe1.ship_tolerance_below ,mr.primary_reservation_quantity , HZL.LOCATION, WMS_WMSSCHS1_XMLP_PKG.cf_barcodeformula() CF_BARCODE, WMS_WMSSCHS1_XMLP_PKG.cf_loc_flex_fieldformula() CF_LOC_FLEX_FIELD, WMS_WMSSCHS1_XMLP_PKG.CF_SHIP_TO_LOCATIONFORMULA(wdd.ship_to_location_id) CF_SHIP_TO_LOCATION, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_item_flex_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') CF_ITEM_FLEX_FIELD, WMS_WMSSCHS1_XMLP_PKG.CF_LPN_NUMBERFORMULA(mr.lpn_id) CF_LPN_NUMBER, WMS_WMSSCHS1_XMLP_PKG.CF_OUTERMOST_LPNFORMULA(mr.lpn_id) CF_OUTERMOST_LPN, WMS_WMSSCHS1_XMLP_PKG.CF_PROJECTFORMULA(wdd.project_id) CF_PROJECT, WMS_WMSSCHS1_XMLP_PKG.CF_TASKFORMULA(wdd.task_id,wdd.project_id) CF_TASK FROM WSH_DELIVERY_DETAILS WDD ,WSH_NEW_DELIVERIES WND ,WSH_DELIVERY_ASSIGNMENTS WDA ,WSH_DELIVERY_LEGS WDL ,OE_ORDER_LINES_ALL oe1 ,OE_SETS oes ,MTL_RESERVATIONS mr ,WSH_TRIPS WT ,WSH_TRIP_STOPS WTS ,MTL_SYSTEM_ITEMS MSI ,HZ_CUST_SITE_USES_ALL HZL WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID AND WDA.DELIVERY_ID = WND.DELIVERY_ID(+) AND WDD.ORGANIZATION_ID = :P_ORG_ID AND WDD.SOURCE_LINE_ID = OE1.LINE_ID AND WDD.RELEASED_STATUS IN ('B','R') AND WDD.SOURCE_CODE = 'OE' AND WND.DELIVERY_ID = WDL.DELIVERY_ID(+) AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID(+) AND WTS.TRIP_ID = WT.TRIP_ID(+) AND WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND WDD.CONTAINER_FLAG = 'N' AND MSI.ORGANIZATION_ID = :P_ORG_ID AND inv_salesorder.get_salesorder_for_oeheader(OE1.HEADER_ID) = MR.demand_source_header_id (+) AND WDD.CUSTOMER_ID = :P_CUSTOMER_ID AND oe1.INTMED_SHIP_TO_org_ID= hzl.site_use_id(+) AND oe1.SHIP_SET_ID= OES.SET_ID(+) &LP_PRIOR_RES_FLAG &LP_SHIPMENT_SCHEDULE_DATE &LP_REQUEST_DATE &LP_DELIVERY_ID &LP_TRIP_STOP &LP_PROJECT &LP_TASK &LP_SO_HEADER &LP_SO_LINE GROUP BY wdd.customer_id ,wdd.ship_to_location_id ,wnd.name ,oe1.request_date ,oe1.schedule_ship_date , HZL.location ,mr.lpn_id ,wt.name ,wdd.source_header_number , to_char(oe1.line_number)||'.'||to_char(oe1.shipment_number)||decode(oe1.option_number,NULL,NULL,'.'||to_char(oe1.option_number))||decode(oe1.component_number, null, null,decode(oe1.option_number, null, '.',null)||'.'||to_char(oe1.component_number)) ,wdd.inventory_item_id ,&p_item_flex_all ,wdd.item_description ,mr.revision ,wdd.requested_quantity_uom ,wdd.project_id ,wdd.task_id , oes.set_name ,oe1.ship_tolerance_above ,oe1.ship_tolerance_below ,wdd.delivery_detail_id ,mr.primary_reservation_quantity,fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_item_flex_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Y WMS WMSSCHS1_XML AR WMS تقرير الشحنة المجدولة (بدون رموز الشريط) (بتنسيق XML) Application: إدارة المستودعات Source: تقرير الشحنة المجدولة (بدون رموز الشريط) (بتنسيق XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG D WMS Geplante Lieferungen (Ohne Barcodes) Application: Warehouse Management Source: Geplante Lieferungen (Ohne Barcodes) (XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG F WMS Etat Livraison programmée (sans codes barres) Application: Warehouse Management Source: Etat Livraison programmée (sans codes barres) (XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG US WMS Scheduled Shipment Report (Without Barcodes) Application: Warehouse Management Source: Scheduled Shipment Report (Without Barcodes) (XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG ZHS WMS 预定发运报表（无条形码） Application: 仓库管理系统 Source: 预定发运报表（无条形码）(XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG BI Publisher &lp_delivery_id &lp_prior_res_flag &lp_project &lp_request_date &lp_shipment_schedule_date &lp_so_header &lp_so_line &lp_task &lp_trip_stop &p_item_flex_all :lp_delivery_id :lp_prior_res_flag :lp_project :lp_request_date :lp_shipment_schedule_date :lp_so_header :lp_so_line :lp_task :lp_trip_stop :p_actual_start_date :p_conc_request_id :p_customer_id :p_customer_name :p_customer_number :p_delivery_id :p_item_flex_all :p_license_plate_number :p_line_number :p_loc_flex_all :p_order_header_id :p_order_line_id :p_order_number :p_order_type :p_org_code :p_org_id :p_org_name :p_outermost_lpn :p_print_cus_details :p_print_cus_prod_det :p_printer :p_prior_res_flag :p_project :p_project_1 :p_project_id :p_report_name :p_request_date :p_request_date_from :p_request_date_to :p_res_flag :p_save_output_flag :p_schedule_shipment_from_date :p_schedule_shipment_to_date :p_ship_to_location :p_so_type :p_task :p_task_1 :p_task_id :p_trip_id 1 10 :p_org_id LOV Oracle INV_SRS_ORG Y select to_char(organization_id) id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_customer_id LOV Oracle WMS_SRS_CUSTOMERS_NEW Y Y select cust_acct.cust_account_id id, substrb(party.party_name,1,50) value, cust_acct.account_number description from hz_parties party,hz_cust_accounts cust_acct where party.party_id=cust_acct.party_id order by party.party_name Y AR العميل D Kunde F Client US Customer ZHS 客户 3 30 :p_order_type LOV Oracle WMS_SRS_ORDER_TYPES Y select transaction_type_id id, name value, null description from oe_transaction_types_tl where language=userenv('LANG') and exists (select 1 from oe_transaction_types_all where transaction_type_id= oe_transaction_types_tl.transaction_type_id and transaction_type_code='ORDER') order by name AR نوع أمر المبيعات D Kundenauftragsart F Type de commande client US Sales Order Type ZHS 销售订单类型 4 40 :p_order_header_id LOV Oracle WMS_SRS_SALES_ORDERS Y select header_id id, order_number value, null description from oe_order_headers_all where order_type_id=:$flex$.wms_srs_order_types and booked_flag='Y' order by value,description AR رقم أمر المبيعات D Kundenauftragsnummer F Numéro commande client US Sales Order Number ZHS 销售订单编号 5 50 :p_order_line_id LOV Oracle WMS_SRS_SALES_ORDER_LINES Y select line_id id, line_number||'.'||shipment_number||'.'||decode(option_number,null,' ','.'||option_number) value, null description from oe_order_lines_all where header_id=:$flex$.wms_srs_sales_orders and :$flex$.wms_srs_sales_orders is not null order by 1 AR رقم سطر أمر المبيعات D Kundenauftragspositionsnummer F Numéro de ligne de commande client US Sales Order Line Number ZHS 销售订单行号 6 60 :p_schedule_shipment_from_date Date AR تاريخ الجدولة من D Von Plandatum F Date programmée - Du US Schedule Date From ZHS 计划日期自 7 70 :p_schedule_shipment_to_date Date AR تاريخ الجدولة إلى D Bis Plandatum F Date programmée - Au US Schedule Date To ZHS 计划日期至 8 80 :p_request_date_from Date AR تاريخ الطلب من D Von Anforderungsdatum F Date de demande - Du US Request Date From ZHS 请求日期自 9 90 :p_request_date_to Date AR تاريخ الطلب إلى D Bis Anforderungsdatum F Date de demande - Au US Request Date To ZHS 请求日期至 10 100 :p_delivery_id LOV Oracle WMS_SRS_DELIVERIES Y select delivery_id id, name value, null description from wsh_new_deliveries where organization_id=:$flex$.inv_srs_org and status_code!='CL' order by name AR التسليم D Auslieferung F Livraison US Delivery ZHS 交货 11 110 :p_trip_id LOV Oracle WMS_SRS_TRIPS Y select trip_id id, name value, null description from wsh_trips where status_code='OP' order by name AR الرحلة D Tour F Trajet US Trip ZHS 行程 12 120 :p_project LOV Oracle WMS_SRS_PROJECTS Y select project_id id, project_number value, null description from pjm_projects_org_v where inventory_organization_id=:$flex$.inv_srs_org order by project_number AR المشروع D Projekt F Projet US Project ZHS 项目 13 130 :p_task LOV Oracle WMS_SRS_TASKS Y select task_id id, task_number value, null description from pjm_tasks_v where project_id=:$flex$.wms_srs_projects order by task_number AR المهمة D Teilprojekt F Tâche US Task ZHS 任务 14 140 :p_prior_res_flag LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code= 2 AR طباعة عمليات الحجز السابقة فقط D Nur frühere Reservierungen drucken F Imprimer les quantités déjà réservées uniquement US Print Prior Reservations Only ZHS 仅打印以前的保留项 15 150 :p_print_cus_prod_det LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code= 1 AR طباعة تفاصيل إنتاج العميل D Kunden-Produktionsdetails drucken F Imprimer les détails de production client US Print Customer Production Details ZHS 打印客户生产详细资料 :$flex$.inv_srs_org Organization Delivery :$flex$.inv_srs_org Organization Project :$flex$.wms_srs_order_types Sales Order Type Sales Order Number :$flex$.wms_srs_projects Project Task :$flex$.wms_srs_sales_orders Sales Order Number Sales Order Line Number