ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5323869E053B46B63588994Y SELECT wt.name Trip_Number, wnd.name Delivery_Number, oeh.order_number, PARTY.party_name customer_name, PARTY.party_number customer_number, lpn1.Lpn_id, lpn1.license_plate_number, lpn2.License_plate_number outermost_lpn, lpn1.Subinventory_code, lpn1.Locator_id, null c_loc_flexdata, lpn1.Outermost_lpn_id, wd2.inventory_item_id, null c_item_flexdata, wd2.requested_quantity_uom uom, wd2.requested_quantity Qty, wd2.revision, wd2.lot_number, wd2.serial_number, 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, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_loc_flex_field', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') CF_Loc_Flex_Field, WMS_WMSSTCON_XMLP_PKG.inmultiplesoformula(lpn1.Lpn_id) InMultipleSO, WMS_WMSSTCON_XMLP_PKG.inmultipledeliveryformula(lpn1.Lpn_id) InMultipleDelivery, WMS_WMSSTCON_XMLP_PKG.inmultipletripformula(lpn1.Lpn_id) InMultipleTrip FROM WMS_License_Plate_Numbers LPN1, WSH_DELIVERY_DETAILS WD1, WSH_DELIVERY_ASSIGNMENTS WDA, WSH_NEW_DELIVERIES WND, WSH_DELIVERY_LEGS WDL, WSH_TRIP_STOPS WTS, WSH_TRIPS WT, WMS_License_Plate_Numbers LPN2, WSH_DELIVERY_DETAILS WD2, OE_ORDER_HEADERS_ALL OEH, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, MTL_SYSTEM_ITEMS MSI, MTL_ITEM_LOCATIONS MIL WHERE &p_where_clause and WND.Organization_id = :p_org_id and WND.delivery_id = WDA.delivery_id and WDA.parent_delivery_detail_id = WD1.delivery_detail_id (+) and WD1.lpn_id = LPN1.lpn_id (+) and LPN1.outermost_lpn_id = LPN2.lpn_id (+) and WD2.delivery_detail_id = WDA.delivery_detail_id and WD2.released_status = 'Y' and WND.delivery_id = WDL.delivery_id (+) and WDL.pick_up_stop_id = WTS.stop_id (+) and WTS.trip_id = WT.trip_id (+) and WD2.source_code = 'OE' and WD2.source_header_id = OEH.header_id and WD2.inventory_item_id = MSI.inventory_item_id and WD2.organization_id = MSI.organization_id and LPN1.locator_id = MIL.inventory_location_id and LPN1.organization_id = MIL.organization_id and PARTY.party_id = oeh.sold_to_org_id and CUST_ACCT.party_id = PARTY.party_id ORDER BY Trip_Number, Delivery_Number, Order_Number, lpn1.License_plate_number, lpn1.subinventory_code, MIL.SEGMENT1 || ',' || MIL.SEGMENT2 || ',' || MIL.SEGMENT3 || ',' || MIL.SEGMENT19 || ',' || MIL.SEGMENT20, MSI.SEGMENT1, wd2.lot_number, wd2.serial_number WMS WMSSTCON_XML AR WMS تقرير التجميع (بتنسيق XML) Application: إدارة المستودعات Source: تقرير التجميع (بتنسيق XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG D WMS Konsolidierung Application: Warehouse Management Source: Konsolidierung (XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG F WMS Etat Groupage Application: Warehouse Management Source: Etat Groupage (XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG US WMS Consolidation Application: Warehouse Management Source: Consolidation Report (XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG ZHS WMS 合并报表 Application: 仓库管理系统 Source: 合并报表 (XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG BI Publisher &p_where_clause :p_conc_request_id :p_customer_id :p_customer_name :p_customer_number :p_delivery_id :p_delivery_name :p_item_flex_data :p_loc_flex_data :p_multiple_association_check :p_multiple_no :p_multiple_yes :p_order_item :p_order_loc :p_order_type_id :p_org_code :p_org_id :p_org_name :p_sales_order :p_sales_order_header_id :p_trip_id :p_trip_name :p_where_clause :rp_report_name 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 Organisationsschlüssel F Code organisation US Oragnization Code ZHS 组织代码 2 20 :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 行程 3 30 :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 交货 4 40 :p_order_type_id 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 销售订单类型 5 50 :p_sales_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 销售订单编号 6 60 :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 AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 7 70 :p_multiple_association_check 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 AR فحص الارتباط المتعدد لـ LPN D Mehrfache VPN-Zuordnungen prüfen F Vérifier les associations multiples de LPN US Check LPN Multiple Association ZHS 检查 LPN 多项关联