ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472BE51A9E05362FB09050512Y SELECT DISTINCT wpsv.pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.locator_id) from_locator_id, wpsv.transfer_subinventory to_subinventory, wpsv.transfer_to_location to_locator_id, nvl(wpsv.transaction_temp_id,-99) transaction_id, nvl(wpsv.transaction_temp_id,-99) rev_txn_id, wpsv.move_order_line_id, wpsv.creation_date detailing_date, 'UNPICKED' line_status, ABS(wpsv.primary_quantity) primary_qty, mtrh.request_number mo_number, mtrl.line_id mo_line_id, mtrl.line_number mo_line_number, -99 delivery_detail_id1, -99 ser_dd_id, wdd.source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char1, wdd.source_header_id, wdd.source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions, wdd.ship_tolerance_above, wdd.ship_tolerance_below, wdd.inventory_item_id, wdd.requested_quantity_uom, wnd.delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id, oola.line_number sales_line_number, &LP_ITEM_DISPLAY_VALUE item_info, msitl.description item_description, msik.revision_qty_control_code, os.set_name, wpgr.customer_flag CUSTOMER_FLAG1, wpgr.order_number_flag, wpgr.subinventory_flag, wpgr.customer_flag, wpgr.ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag, wpgr.trip_stop_flag, wpgr.delivery_flag, wpgr.name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id, wdd.requested_quantity2 secondary_qty_requested, wdd.requested_quantity_uom2 secondary_qty_requested_uom, wdd.shipped_quantity2 secondary_qty_shipped, wdd.requested_quantity_uom2 secondary_qty_shipped_uom, wdd.preferred_grade grade, wdd.freight_terms_code freight_terms, wdd.date_requested requested_ship_date, wdd.attribute1 wdd_attribute1, wdd.attribute2 wdd_attribute2, wdd.attribute3 wdd_attribute3, wdd.attribute4 wdd_attribute4, wdd.attribute5 wdd_attribute5, wdd.attribute6 wdd_attribute6, wdd.attribute7 wdd_attribute7, wdd.attribute8 wdd_attribute8, wdd.attribute9 wdd_attribute9, wdd.attribute10 wdd_attribute10, wdd.attribute11 wdd_attribute11, wdd.attribute12 wdd_attribute12, wdd.attribute13 wdd_attribute13, wdd.attribute14 wdd_attribute14, wdd.attribute15 wdd_attribute15, wnd.attribute1 wnd_attribute1, wnd.attribute2 wnd_attribute2, wnd.attribute3 wnd_attribute3, wnd.attribute4 wnd_attribute4, wnd.attribute5 wnd_attribute5, wnd.attribute6 wnd_attribute6, wnd.attribute7 wnd_attribute7, wnd.attribute8 wnd_attribute8, wnd.attribute9 wnd_attribute9, wnd.attribute10 wnd_attribute10, wnd.attribute11 wnd_attribute11, wnd.attribute12 wnd_attribute12, wnd.attribute13 wnd_attribute13, wnd.attribute14 wnd_attribute14, wnd.attribute15 wnd_attribute15, msik.concatenated_segments item_name, wdd.source_code source_code, WSH_WSHRDPIK_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_warehouse, WSH_WSHRDPIK_XMLP_PKG.cf_tempformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_temp, WSH_WSHRDPIK_XMLP_PKG.cf_requisition_numberformula(wdd.source_header_id) CF_requisition_number, WSH_WSHRDPIK_XMLP_PKG.cf_ship_to_addressformula(wpgr.ship_to_flag,wpsv.pick_slip_number) CF_ship_to_address, WSH_WSHRDPIK_XMLP_PKG.cf_carrierformula(wpgr.carrier_flag,wdd.ship_method_code) CF_carrier, WSH_WSHRDPIK_XMLP_PKG.cf_shipment_priorityformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_shipment_priority, WSH_WSHRDPIK_XMLP_PKG.cf_subinventoryformula(wpgr.subinventory_flag,decode (msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code)) CF_subinventory, WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id) CF_delivery_id, WSH_WSHRDPIK_XMLP_PKG.cf_deliveryformula(wpgr.delivery_flag,wnd.name) CF_delivery, WSH_WSHRDPIK_XMLP_PKG.cf_trip_stop_address1formula(wpgr.trip_stop_flag,wpgr.delivery_flag,WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id),wpsv.pick_slip_number) CF_trip_stop_address, WSH_WSHRDPIK_XMLP_PKG.cf_order_numberformula(wpgr.order_number_flag,wdd.source_header_number) CF_order_number, WSH_WSHRDPIK_XMLP_PKG.cf_customer_nameformula(wpgr.customer_flag,wdd.source_header_id) CF_customer_name, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_code_p CP_warehouse_code, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_name_p CP_warehouse_name, WSH_WSHRDPIK_XMLP_PKG.st_addr1_p st_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr3_p ts_addr3, WSH_WSHRDPIK_XMLP_PKG.ts_addr4_p ts_addr4, WSH_WSHRDPIK_XMLP_PKG.ts_addr5_p ts_addr5, WSH_WSHRDPIK_XMLP_PKG.ts_addr1_p ts_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr2_p ts_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr4_p st_addr4, WSH_WSHRDPIK_XMLP_PKG.st_addr5_p st_addr5, WSH_WSHRDPIK_XMLP_PKG.st_addr2_p st_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr3_p st_addr3, WSH_WSHRDPIK_XMLP_PKG.f_to_locationformula(wpsv.transfer_to_location,wdd.organization_id) F_TO_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_customerformula(wpgr.customer_flag,wdd.source_header_id) CF_customer, WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id) CF_trip_id, WSH_WSHRDPIK_XMLP_PKG.f_item_descriptionformula(msitl.description,wdd.inventory_item_id,wdd.organization_id,msitl.description) F_ITEM_DESCRIPTION, WSH_WSHRDPIK_XMLP_PKG.f_requested_quantityformula(wdd.source_header_id,wdd.source_line_id,wpsv.move_order_line_id) F_REQUESTED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.f_shipped_quantityformula() F_SHIPPED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.cf_trip_chrformula(WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id)) CF_TRIP_CHR, WSH_WSHRDPIK_XMLP_PKG.CP_trip_name_p CP_trip_name, WSH_WSHRDPIK_XMLP_PKG.f_from_locationformula(decode (msik.reservable_type,2,wdd.locator_id,wpsv.locator_id),wdd.organization_id) F_FROM_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_freight_terms_nameformula(wdd.freight_terms_code,wdd.source_code) CF_FREIGHT_TERMS_NAME, WSH_WSHRDPIK_XMLP_PKG.cf_revisionformula(nvl (wpsv.transaction_temp_id,-99)) CF_REVISION, WSH_WSHRDPIK_XMLP_PKG.B_task_idFt(wdd.organization_id) B_task_idFt FROM MTL_MATERIAL_TRANSACTIONS_TEMP wpsv, wsh_delivery_details wdd, mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, oe_order_lines_all oola, oe_sets os, wsh_pick_grouping_rules wpgr, mtl_system_items_b_kfv msik, mtl_system_items_tl msitl WHERE msik.inventory_item_id=msitl.inventory_item_id AND msik.organization_id=msitl.organization_id AND msitl.LANGUAGE=userenv('LANG') AND NVL(wpsv.parent_line_id,0)=0 AND wpsv.pick_slip_number IS NOT NULL AND ABS(NVL(wpsv.transaction_quantity,0))>0 AND wpsv.move_order_line_id=mtrl.line_id AND mtrl.header_id=mtrh.header_id AND mtrl.line_id=wdd.move_order_line_id AND wdd.inventory_item_id=msik.inventory_item_id(+) AND wdd.organization_id=msik.organization_id(+) AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+) AND (wnd.delivery_type is null or wnd.delivery_type='STANDARD') AND wdd.source_line_id=oola.line_id AND wdd.source_header_id=oola.header_id AND wdd.released_status='S' AND wdd.source_code='OE' AND wdd.container_flag IN ('N','Y') AND wdd.ship_set_id=os.set_id(+) AND mtrh.grouping_rule_id=wpgr.pick_grouping_rule_id(+) &LP_PICK_STATUS_UNPICK &LP_WAREHOUSE_CLAUSE &LP_MO_CLAUSE &lp_pick_slip_num &LP_ORDER_NUM &LP_ORDER_TYPE &LP_CUSTOMER_ID &lp_ship_method_code &LP_DETAIL_DATE_UNPICK &LP_PRINTER_NAME UNION ALL SELECT DISTINCT parent_mmtt.pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.locator_id) from_locator_id, wpsv.transfer_subinventory to_subinventory, wpsv.transfer_to_location to_locator_id, nvl(wpsv.transaction_temp_id,-99) transaction_id, nvl(wpsv.transaction_temp_id,-99) rev_txn_id, wpsv.move_order_line_id, wpsv.creation_date detailing_date, 'UNPICKED' line_status, ABS(wpsv.primary_quantity) primary_qty, mtrh.request_number mo_number, mtrl.line_id mo_line_id, mtrl.line_number mo_line_number, -99 delivery_detail_id1, -99 ser_dd_id, wdd.source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char1, wdd.source_header_id, wdd.source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions, wdd.ship_tolerance_above, wdd.ship_tolerance_below, wdd.inventory_item_id, wdd.requested_quantity_uom, wnd.delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id, oola.line_number sales_line_number, &LP_ITEM_DISPLAY_VALUE item_info, msitl.description item_description, msik.revision_qty_control_code, os.set_name, wpgr.customer_flag CUSTOMER_FLAG1, wpgr.order_number_flag, wpgr.subinventory_flag, wpgr.customer_flag, wpgr.ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag, wpgr.trip_stop_flag, wpgr.delivery_flag, wpgr.name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id, wdd.requested_quantity2 secondary_qty_requested, wdd.requested_quantity_uom2 secondary_qty_requested_uom, wdd.shipped_quantity2 secondary_qty_shipped, wdd.requested_quantity_uom2 secondary_qty_shipped_uom, wdd.preferred_grade grade, wdd.freight_terms_code freight_terms, wdd.date_requested requested_ship_date, wdd.attribute1 wdd_attribute1, wdd.attribute2 wdd_attribute2, wdd.attribute3 wdd_attribute3, wdd.attribute4 wdd_attribute4, wdd.attribute5 wdd_attribute5, wdd.attribute6 wdd_attribute6, wdd.attribute7 wdd_attribute7, wdd.attribute8 wdd_attribute8, wdd.attribute9 wdd_attribute9, wdd.attribute10 wdd_attribute10, wdd.attribute11 wdd_attribute11, wdd.attribute12 wdd_attribute12, wdd.attribute13 wdd_attribute13, wdd.attribute14 wdd_attribute14, wdd.attribute15 wdd_attribute15, wnd.attribute1 wnd_attribute1, wnd.attribute2 wnd_attribute2, wnd.attribute3 wnd_attribute3, wnd.attribute4 wnd_attribute4, wnd.attribute5 wnd_attribute5, wnd.attribute6 wnd_attribute6, wnd.attribute7 wnd_attribute7, wnd.attribute8 wnd_attribute8, wnd.attribute9 wnd_attribute9, wnd.attribute10 wnd_attribute10, wnd.attribute11 wnd_attribute11, wnd.attribute12 wnd_attribute12, wnd.attribute13 wnd_attribute13, wnd.attribute14 wnd_attribute14, wnd.attribute15 wnd_attribute15, msik.concatenated_segments item_name, wdd.source_code source_code, WSH_WSHRDPIK_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_warehouse, WSH_WSHRDPIK_XMLP_PKG.cf_tempformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_temp, WSH_WSHRDPIK_XMLP_PKG.cf_requisition_numberformula(wdd.source_header_id) CF_requisition_number, WSH_WSHRDPIK_XMLP_PKG.cf_ship_to_addressformula(wpgr.ship_to_flag,parent_mmtt.pick_slip_number) CF_ship_to_address, WSH_WSHRDPIK_XMLP_PKG.cf_carrierformula(wpgr.carrier_flag,wdd.ship_method_code) CF_carrier, WSH_WSHRDPIK_XMLP_PKG.cf_shipment_priorityformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_shipment_priority, WSH_WSHRDPIK_XMLP_PKG.cf_subinventoryformula(wpgr.subinventory_flag,decode (msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code)) CF_subinventory, WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id) CF_delivery_id, WSH_WSHRDPIK_XMLP_PKG.cf_deliveryformula(wpgr.delivery_flag,wnd.name) CF_delivery, WSH_WSHRDPIK_XMLP_PKG.cf_trip_stop_address1formula(wpgr.trip_stop_flag,wpgr.delivery_flag,WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id),parent_mmtt.pick_slip_number) CF_trip_stop_address, WSH_WSHRDPIK_XMLP_PKG.cf_order_numberformula(wpgr.order_number_flag,wdd.source_header_number) CF_order_number, WSH_WSHRDPIK_XMLP_PKG.cf_customer_nameformula(wpgr.customer_flag,wdd.source_header_id) CF_customer_name, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_code_p CP_warehouse_code, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_name_p CP_warehouse_name, WSH_WSHRDPIK_XMLP_PKG.st_addr1_p st_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr3_p ts_addr3, WSH_WSHRDPIK_XMLP_PKG.ts_addr4_p ts_addr4, WSH_WSHRDPIK_XMLP_PKG.ts_addr5_p ts_addr5, WSH_WSHRDPIK_XMLP_PKG.ts_addr1_p ts_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr2_p ts_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr4_p st_addr4, WSH_WSHRDPIK_XMLP_PKG.st_addr5_p st_addr5, WSH_WSHRDPIK_XMLP_PKG.st_addr2_p st_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr3_p st_addr3, WSH_WSHRDPIK_XMLP_PKG.f_to_locationformula(wpsv.transfer_to_location,wdd.organization_id) F_TO_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_customerformula(wpgr.customer_flag,wdd.source_header_id) CF_customer, WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id) CF_trip_id, WSH_WSHRDPIK_XMLP_PKG.f_item_descriptionformula(msitl.description,wdd.inventory_item_id,wdd.organization_id,msitl.description) F_ITEM_DESCRIPTION, WSH_WSHRDPIK_XMLP_PKG.f_requested_quantityformula(wdd.source_header_id,wdd.source_line_id,wpsv.move_order_line_id) F_REQUESTED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.f_shipped_quantityformula() F_SHIPPED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.cf_trip_chrformula(WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id)) CF_TRIP_CHR, WSH_WSHRDPIK_XMLP_PKG.CP_trip_name_p CP_trip_name, WSH_WSHRDPIK_XMLP_PKG.f_from_locationformula(decode (msik.reservable_type,2,wdd.locator_id,wpsv.locator_id),wdd.organization_id) F_FROM_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_freight_terms_nameformula(wdd.freight_terms_code,wdd.source_code) CF_FREIGHT_TERMS_NAME, WSH_WSHRDPIK_XMLP_PKG.cf_revisionformula(nvl (wpsv.transaction_temp_id,-99)) CF_REVISION, WSH_WSHRDPIK_XMLP_PKG.B_task_idFt(wdd.organization_id) B_task_idFt FROM MTL_MATERIAL_TRANSACTIONS_TEMP wpsv, MTL_MATERIAL_TRANSACTIONS_TEMP parent_mmtt, wsh_delivery_details wdd, mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, oe_order_lines_all oola, oe_sets os, wsh_pick_grouping_rules wpgr, mtl_system_items_b_kfv msik, mtl_system_items_tl msitl WHERE wpsv.parent_line_id=parent_mmtt.transaction_temp_id AND wpsv.parent_line_id<>wpsv.transaction_temp_id AND msik.inventory_item_id=msitl.inventory_item_id AND msik.organization_id=msitl.organization_id AND msitl.LANGUAGE=userenv('LANG') AND parent_mmtt.pick_slip_number IS NOT NULL AND ABS(NVL(wpsv.transaction_quantity,0))>0 AND wpsv.move_order_line_id=mtrl.line_id AND mtrl.header_id=mtrh.header_id AND mtrl.line_id=wdd.move_order_line_id AND wdd.inventory_item_id=msik.inventory_item_id(+) AND wdd.organization_id=msik.organization_id(+) AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+) AND (wnd.delivery_type is null or wnd.delivery_type='STANDARD') AND wdd.source_line_id=oola.line_id AND wdd.source_header_id=oola.header_id AND wdd.released_status='S' AND wdd.source_code='OE' AND wdd.container_flag IN ('N','Y') AND wdd.ship_set_id=os.set_id(+) AND mtrh.grouping_rule_id=wpgr.pick_grouping_rule_id(+) &LP_PICK_STATUS_UNPICK &LP_WAREHOUSE_CLAUSE &LP_MO_CLAUSE &lp_pick_slip_num &LP_ORDER_NUM &LP_ORDER_TYPE &LP_CUSTOMER_ID &lp_ship_method_code &LP_DETAIL_DATE_UNPICK &LP_PRINTER_NAME UNION ALL SELECT DISTINCT wpsv.pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.locator_id) from_locator_id, wpsv.transfer_subinventory to_subinventory, wpsv.transfer_to_location to_locator_id, nvl(wpsv.transaction_temp_id,-99) transaction_id, nvl(wpsv.transaction_temp_id,-99) rev_txn_id, wpsv.move_order_line_id, wpsv.creation_date detailing_date, 'UNPICKED' line_status, ABS(wpsv.primary_quantity) primary_qty, mtrh.request_number mo_number, mtrl.line_id mo_line_id, mtrl.line_number mo_line_number, -99 delivery_detail_id1, -99 ser_dd_id, wdd.source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char1, wdd.source_header_id, wdd.source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions, wdd.ship_tolerance_above, wdd.ship_tolerance_below, wdd.inventory_item_id, wdd.requested_quantity_uom, wnd.delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id, oola.line_number sales_line_number, &LP_ITEM_DISPLAY_VALUE item_info, msitl.description item_description, msik.revision_qty_control_code, os.set_name, wpgr.customer_flag CUSTOMER_FLAG1, wpgr.order_number_flag, wpgr.subinventory_flag, wpgr.customer_flag, wpgr.ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag, wpgr.trip_stop_flag, wpgr.delivery_flag, wpgr.name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id, wdd.requested_quantity2 secondary_qty_requested, wdd.requested_quantity_uom2 secondary_qty_requested_uom, wdd.shipped_quantity2 secondary_qty_shipped, wdd.requested_quantity_uom2 secondary_qty_shipped_uom, wdd.preferred_grade grade, wdd.freight_terms_code freight_terms, wdd.date_requested requested_ship_date, wdd.attribute1 wdd_attribute1, wdd.attribute2 wdd_attribute2, wdd.attribute3 wdd_attribute3, wdd.attribute4 wdd_attribute4, wdd.attribute5 wdd_attribute5, wdd.attribute6 wdd_attribute6, wdd.attribute7 wdd_attribute7, wdd.attribute8 wdd_attribute8, wdd.attribute9 wdd_attribute9, wdd.attribute10 wdd_attribute10, wdd.attribute11 wdd_attribute11, wdd.attribute12 wdd_attribute12, wdd.attribute13 wdd_attribute13, wdd.attribute14 wdd_attribute14, wdd.attribute15 wdd_attribute15, wnd.attribute1 wnd_attribute1, wnd.attribute2 wnd_attribute2, wnd.attribute3 wnd_attribute3, wnd.attribute4 wnd_attribute4, wnd.attribute5 wnd_attribute5, wnd.attribute6 wnd_attribute6, wnd.attribute7 wnd_attribute7, wnd.attribute8 wnd_attribute8, wnd.attribute9 wnd_attribute9, wnd.attribute10 wnd_attribute10, wnd.attribute11 wnd_attribute11, wnd.attribute12 wnd_attribute12, wnd.attribute13 wnd_attribute13, wnd.attribute14 wnd_attribute14, wnd.attribute15 wnd_attribute15, msik.concatenated_segments item_name, wdd.source_code source_code, WSH_WSHRDPIK_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_warehouse, WSH_WSHRDPIK_XMLP_PKG.cf_tempformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_temp, WSH_WSHRDPIK_XMLP_PKG.cf_requisition_numberformula(wdd.source_header_id) CF_requisition_number, WSH_WSHRDPIK_XMLP_PKG.cf_ship_to_addressformula(wpgr.ship_to_flag,wpsv.pick_slip_number) CF_ship_to_address, WSH_WSHRDPIK_XMLP_PKG.cf_carrierformula(wpgr.carrier_flag,wdd.ship_method_code) CF_carrier, WSH_WSHRDPIK_XMLP_PKG.cf_shipment_priorityformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_shipment_priority, WSH_WSHRDPIK_XMLP_PKG.cf_subinventoryformula(wpgr.subinventory_flag,decode (msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code)) CF_subinventory, WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id) CF_delivery_id, WSH_WSHRDPIK_XMLP_PKG.cf_deliveryformula(wpgr.delivery_flag,wnd.name) CF_delivery, WSH_WSHRDPIK_XMLP_PKG.cf_trip_stop_address1formula(wpgr.trip_stop_flag,wpgr.delivery_flag,WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id),wpsv.pick_slip_number) CF_trip_stop_address, WSH_WSHRDPIK_XMLP_PKG.cf_order_numberformula(wpgr.order_number_flag,wdd.source_header_number) CF_order_number, WSH_WSHRDPIK_XMLP_PKG.cf_customer_nameformula(wpgr.customer_flag,wdd.source_header_id) CF_customer_name, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_code_p CP_warehouse_code, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_name_p CP_warehouse_name, WSH_WSHRDPIK_XMLP_PKG.st_addr1_p st_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr3_p ts_addr3, WSH_WSHRDPIK_XMLP_PKG.ts_addr4_p ts_addr4, WSH_WSHRDPIK_XMLP_PKG.ts_addr5_p ts_addr5, WSH_WSHRDPIK_XMLP_PKG.ts_addr1_p ts_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr2_p ts_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr4_p st_addr4, WSH_WSHRDPIK_XMLP_PKG.st_addr5_p st_addr5, WSH_WSHRDPIK_XMLP_PKG.st_addr2_p st_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr3_p st_addr3, WSH_WSHRDPIK_XMLP_PKG.f_to_locationformula(wpsv.transfer_to_location,wdd.organization_id) F_TO_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_customerformula(wpgr.customer_flag,wdd.source_header_id) CF_customer, WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id) CF_trip_id, WSH_WSHRDPIK_XMLP_PKG.f_item_descriptionformula(msitl.description,wdd.inventory_item_id,wdd.organization_id,msitl.description) F_ITEM_DESCRIPTION, WSH_WSHRDPIK_XMLP_PKG.f_requested_quantityformula(wdd.source_header_id,wdd.source_line_id,wpsv.move_order_line_id) F_REQUESTED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.f_shipped_quantityformula() F_SHIPPED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.cf_trip_chrformula(WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id)) CF_TRIP_CHR, WSH_WSHRDPIK_XMLP_PKG.CP_trip_name_p CP_trip_name, WSH_WSHRDPIK_XMLP_PKG.f_from_locationformula(decode (msik.reservable_type,2,wdd.locator_id,wpsv.locator_id),wdd.organization_id) F_FROM_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_freight_terms_nameformula(wdd.freight_terms_code,wdd.source_code) CF_FREIGHT_TERMS_NAME, WSH_WSHRDPIK_XMLP_PKG.cf_revisionformula(nvl (wpsv.transaction_temp_id,-99)) CF_REVISION, WSH_WSHRDPIK_XMLP_PKG.B_task_idFt(wdd.organization_id) B_task_idFt FROM (SELECT parent_mmtt.subinventory_code from_subinventory, parent_mmtt.locator_id from_locator_id, parent_mmtt.transfer_subinventory to_subinventory, parent_mmtt.transfer_to_location to_locator_id, 0 primary_quantity, parent_mmtt.pick_slip_number, parent_mmtt.creation_date detailing_date, (SELECT child_mmtt.move_order_line_id FROM mtl_material_transactions_temp child_mmtt WHERE child_mmtt.parent_line_id=parent_mmtt.transaction_temp_id AND child_mmtt.pick_slip_number IS NULL AND ROWNUM=1 ) move_order_line_id, 'UNPICKED' line_status, parent_mmtt.transaction_temp_id transaction_id, creation_date, transaction_temp_id, transfer_to_location, transfer_subinventory, locator_id, subinventory_code FROM mtl_material_transactions_temp parent_mmtt WHERE parent_mmtt.pick_slip_number IS NOT NULL AND parent_mmtt.transaction_temp_id=parent_mmtt.parent_line_id) wpsv, wsh_delivery_details wdd, mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, oe_order_lines_all oola, oe_sets os, wsh_pick_grouping_rules wpgr, mtl_system_items_b_kfv msik, mtl_system_items_tl msitl WHERE msik.inventory_item_id=msitl.inventory_item_id AND msik.organization_id=msitl.organization_id AND msitl.LANGUAGE=userenv('LANG') AND wpsv.pick_slip_number IS NOT NULL AND wpsv.move_order_line_id=mtrl.line_id AND mtrl.header_id=mtrh.header_id AND mtrl.line_id=wdd.move_order_line_id AND wdd.inventory_item_id=msik.inventory_item_id(+) AND wdd.organization_id=msik.organization_id(+) AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+) AND (wnd.delivery_type is null or wnd.delivery_type='STANDARD') AND wdd.source_line_id=oola.line_id AND wdd.source_header_id=oola.header_id AND wdd.released_status='S' AND wdd.source_code='OE' AND wdd.container_flag IN ('N','Y') AND wdd.ship_set_id=os.set_id(+) AND mtrh.grouping_rule_id=wpgr.pick_grouping_rule_id(+) &LP_PICK_STATUS_UNPICK &LP_WAREHOUSE_CLAUSE &LP_MO_CLAUSE &lp_pick_slip_num &LP_ORDER_NUM &LP_ORDER_TYPE &LP_CUSTOMER_ID &lp_ship_method_code &LP_DETAIL_DATE_UNPICK &LP_PRINTER_NAME UNION ALL SELECT DISTINCT wpsv.pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id) from_locator_id, wpsv.to_subinventory, wpsv.to_locator_id, nvl(wpsv.transaction_id,-99) transaction_id, nvl(wdd.transaction_id,-99) rev_txn_id, wpsv.move_order_line_id, wpsv.detailing_date, 'PICKED' line_status, nvl(wdd.picked_quantity,wdd.requested_quantity) primary_qty, mtrh.request_number mo_number, wpsv.line_id mo_line_id, wpsv.line_number mo_line_number, wdd.delivery_detail_id delivery_detail_id1, wdd.delivery_detail_id ser_dd_id, wdd.source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char1, wdd.source_header_id, wdd.source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions, wdd.ship_tolerance_above, wdd.ship_tolerance_below, wdd.inventory_item_id, wdd.requested_quantity_uom, wnd.delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id, oola.line_number sales_line_number, &LP_ITEM_DISPLAY_VALUE item_info, msitl.description item_description, msik.revision_qty_control_code, os.set_name, wpgr.customer_flag CUSTOMER_FLAG1, wpgr.order_number_flag, wpgr.subinventory_flag, wpgr.customer_flag, wpgr.ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag, wpgr.trip_stop_flag, wpgr.delivery_flag, wpgr.name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id, wdd.requested_quantity2 secondary_qty_requested, wdd.requested_quantity_uom2 secondary_qty_requested_uom, wdd.shipped_quantity2 secondary_qty_shipped, wdd.requested_quantity_uom2 secondary_qty_shipped_uom, wdd.preferred_grade grade, wdd.freight_terms_code freight_terms, wdd.date_requested requested_ship_date, wdd.attribute1 wdd_attribute1, wdd.attribute2 wdd_attribute2, wdd.attribute3 wdd_attribute3, wdd.attribute4 wdd_attribute4, wdd.attribute5 wdd_attribute5, wdd.attribute6 wdd_attribute6, wdd.attribute7 wdd_attribute7, wdd.attribute8 wdd_attribute8, wdd.attribute9 wdd_attribute9, wdd.attribute10 wdd_attribute10, wdd.attribute11 wdd_attribute11, wdd.attribute12 wdd_attribute12, wdd.attribute13 wdd_attribute13, wdd.attribute14 wdd_attribute14, wdd.attribute15 wdd_attribute15, wnd.attribute1 wnd_attribute1, wnd.attribute2 wnd_attribute2, wnd.attribute3 wnd_attribute3, wnd.attribute4 wnd_attribute4, wnd.attribute5 wnd_attribute5, wnd.attribute6 wnd_attribute6, wnd.attribute7 wnd_attribute7, wnd.attribute8 wnd_attribute8, wnd.attribute9 wnd_attribute9, wnd.attribute10 wnd_attribute10, wnd.attribute11 wnd_attribute11, wnd.attribute12 wnd_attribute12, wnd.attribute13 wnd_attribute13, wnd.attribute14 wnd_attribute14, wnd.attribute15 wnd_attribute15, msik.concatenated_segments item_name, wdd.source_code source_code, WSH_WSHRDPIK_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_warehouse, WSH_WSHRDPIK_XMLP_PKG.cf_tempformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_temp, WSH_WSHRDPIK_XMLP_PKG.cf_requisition_numberformula(wdd.source_header_id) CF_requisition_number, WSH_WSHRDPIK_XMLP_PKG.cf_ship_to_addressformula(wpgr.ship_to_flag,wpsv.pick_slip_number) CF_ship_to_address, WSH_WSHRDPIK_XMLP_PKG.cf_carrierformula(wpgr.carrier_flag,wdd.ship_method_code) CF_carrier, WSH_WSHRDPIK_XMLP_PKG.cf_shipment_priorityformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_shipment_priority, WSH_WSHRDPIK_XMLP_PKG.cf_subinventoryformula(wpgr.subinventory_flag,decode (msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code)) CF_subinventory, WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id) CF_delivery_id, WSH_WSHRDPIK_XMLP_PKG.cf_deliveryformula(wpgr.delivery_flag,wnd.name) CF_delivery, WSH_WSHRDPIK_XMLP_PKG.cf_trip_stop_address1formula(wpgr.trip_stop_flag,wpgr.delivery_flag,WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id),wpsv.pick_slip_number) CF_trip_stop_address, WSH_WSHRDPIK_XMLP_PKG.cf_order_numberformula(wpgr.order_number_flag,wdd.source_header_number) CF_order_number, WSH_WSHRDPIK_XMLP_PKG.cf_customer_nameformula(wpgr.customer_flag,wdd.source_header_id) CF_customer_name, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_code_p CP_warehouse_code, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_name_p CP_warehouse_name, WSH_WSHRDPIK_XMLP_PKG.st_addr1_p st_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr3_p ts_addr3, WSH_WSHRDPIK_XMLP_PKG.ts_addr4_p ts_addr4, WSH_WSHRDPIK_XMLP_PKG.ts_addr5_p ts_addr5, WSH_WSHRDPIK_XMLP_PKG.ts_addr1_p ts_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr2_p ts_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr4_p st_addr4, WSH_WSHRDPIK_XMLP_PKG.st_addr5_p st_addr5, WSH_WSHRDPIK_XMLP_PKG.st_addr2_p st_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr3_p st_addr3, WSH_WSHRDPIK_XMLP_PKG.f_to_locationformula(wpsv.to_locator_id,wdd.organization_id) F_TO_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_customerformula(wpgr.customer_flag,wdd.source_header_id) CF_customer, WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id) CF_trip_id, WSH_WSHRDPIK_XMLP_PKG.f_item_descriptionformula(msitl.description,wdd.inventory_item_id,wdd.organization_id,msitl.description) F_ITEM_DESCRIPTION, WSH_WSHRDPIK_XMLP_PKG.f_requested_quantityformula(wdd.source_header_id,wdd.source_line_id,wpsv.move_order_line_id) F_REQUESTED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.f_shipped_quantityformula() F_SHIPPED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.cf_trip_chrformula(WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id)) CF_TRIP_CHR, WSH_WSHRDPIK_XMLP_PKG.CP_trip_name_p CP_trip_name, WSH_WSHRDPIK_XMLP_PKG.f_from_locationformula(decode (msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id),wdd.organization_id) F_FROM_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_freight_terms_nameformula(wdd.freight_terms_code,wdd.source_code) CF_FREIGHT_TERMS_NAME, WSH_WSHRDPIK_XMLP_PKG.cf_revisionformula(nvl (wpsv.transaction_id,-99)) CF_REVISION, WSH_WSHRDPIK_XMLP_PKG.B_task_idFt(wdd.organization_id) B_task_idFt FROM ( SELECT mmt.subinventory_code subinventory_code, mmt.locator_id from_locator_id, mmt.transfer_subinventory to_subinventory, mmt.transfer_locator_id to_locator_id, abs(mmt.primary_quantity) primary_qty, mmt.pick_slip_number, mmt.transaction_date detailing_date, mmt.move_order_line_id, 'PICKED' line_status, mmt.transaction_id, mmt.transaction_uom, mmt.secondary_transaction_quantity, mmt.secondary_uom_code, mtrl.header_id, mtrl.line_id, mtrl.line_number FROM mtl_material_transactions mmt, mtl_txn_request_lines mtrl WHERE mmt.pick_slip_number IS NOT NULL AND nvl(mmt.transaction_quantity,0)<0 AND mmt.move_order_line_id=mtrl.line_id &LP_PICK_STATUS &LP_WAREHOUSE_CLAUSE &LP_DETAIL_DATE_MMT &LP_PICK_SLIP_NUM_MMT ) wpsv, wsh_delivery_details wdd, mtl_txn_request_headers mtrh, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, oe_order_lines_all oola, oe_sets os, wsh_pick_grouping_rules wpgr, mtl_system_items_b_kfv msik, mtl_system_items_tl msitl WHERE msik.inventory_item_id=msitl.inventory_item_id AND msik.organization_id=msitl.organization_id AND msitl.LANGUAGE=userenv('LANG') AND wpsv.header_id=mtrh.header_id AND wpsv.move_order_line_id=wdd.move_order_line_id AND nvl(wpsv.transaction_id,-99)=decode(nvl(wdd.transaction_id,-99),-99,nvl(wpsv.transaction_id,-99),wdd.transaction_id) AND wdd.inventory_item_id=msik.inventory_item_id(+) AND wdd.organization_id=msik.organization_id(+) AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+) AND (wnd.delivery_type is null or wnd.delivery_type='STANDARD') AND wdd.source_line_id=oola.line_id AND wdd.source_header_id=oola.header_id AND wdd.source_code='OE' AND wdd.released_status!='S' AND wdd.container_flag IN ('N','Y') AND wdd.ship_set_id=os.set_id(+) AND mtrh.grouping_rule_id=wpgr.pick_grouping_rule_id(+) &LP_MO_CLAUSE &LP_ORDER_NUM &LP_ORDER_TYPE &LP_CUSTOMER_ID &lp_ship_method_code &LP_PRINTER_NAME UNION ALL SELECT DISTINCT wpsv.pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id) from_locator_id, wpsv.to_subinventory, wpsv.to_locator_id, nvl(wpsv.transaction_id,-99) transaction_id, nvl(wdd.transaction_id,-99) rev_txn_id, wpsv.move_order_line_id, wpsv.detailing_date, 'PICKED' line_status, nvl(wdd.picked_quantity,wdd.requested_quantity) primary_qty, mtrh.request_number mo_number, wpsv.line_id mo_line_id, wpsv.line_number mo_line_number, wdd.delivery_detail_id delivery_detail_id1, wdd.delivery_detail_id ser_dd_id, wdd.source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char1, wdd.source_header_id, wdd.source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions, wdd.ship_tolerance_above, wdd.ship_tolerance_below, wdd.inventory_item_id, wdd.requested_quantity_uom, wnd.delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id, oola.line_number sales_line_number, &LP_ITEM_DISPLAY_VALUE item_info, msitl.description item_description, msik.revision_qty_control_code, os.set_name, wpgr.customer_flag CUSTOMER_FLAG1, wpgr.order_number_flag, wpgr.subinventory_flag, wpgr.customer_flag, wpgr.ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag, wpgr.trip_stop_flag, wpgr.delivery_flag, wpgr.name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id, wdd.requested_quantity2 secondary_qty_requested, wdd.requested_quantity_uom2 secondary_qty_requested_uom, wdd.shipped_quantity2 secondary_qty_shipped, wdd.requested_quantity_uom2 secondary_qty_shipped_uom, wdd.preferred_grade grade, wdd.freight_terms_code freight_terms, wdd.date_requested requested_ship_date, wdd.attribute1 wdd_attribute1, wdd.attribute2 wdd_attribute2, wdd.attribute3 wdd_attribute3, wdd.attribute4 wdd_attribute4, wdd.attribute5 wdd_attribute5, wdd.attribute6 wdd_attribute6, wdd.attribute7 wdd_attribute7, wdd.attribute8 wdd_attribute8, wdd.attribute9 wdd_attribute9, wdd.attribute10 wdd_attribute10, wdd.attribute11 wdd_attribute11, wdd.attribute12 wdd_attribute12, wdd.attribute13 wdd_attribute13, wdd.attribute14 wdd_attribute14, wdd.attribute15 wdd_attribute15, wnd.attribute1 wnd_attribute1, wnd.attribute2 wnd_attribute2, wnd.attribute3 wnd_attribute3, wnd.attribute4 wnd_attribute4, wnd.attribute5 wnd_attribute5, wnd.attribute6 wnd_attribute6, wnd.attribute7 wnd_attribute7, wnd.attribute8 wnd_attribute8, wnd.attribute9 wnd_attribute9, wnd.attribute10 wnd_attribute10, wnd.attribute11 wnd_attribute11, wnd.attribute12 wnd_attribute12, wnd.attribute13 wnd_attribute13, wnd.attribute14 wnd_attribute14, wnd.attribute15 wnd_attribute15, msik.concatenated_segments item_name, wdd.source_code source_code, WSH_WSHRDPIK_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_warehouse, WSH_WSHRDPIK_XMLP_PKG.cf_tempformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_temp, WSH_WSHRDPIK_XMLP_PKG.cf_requisition_numberformula(wdd.source_header_id) CF_requisition_number, WSH_WSHRDPIK_XMLP_PKG.cf_ship_to_addressformula(wpgr.ship_to_flag,wpsv.pick_slip_number) CF_ship_to_address, WSH_WSHRDPIK_XMLP_PKG.cf_carrierformula(wpgr.carrier_flag,wdd.ship_method_code) CF_carrier, WSH_WSHRDPIK_XMLP_PKG.cf_shipment_priorityformula(wpgr.shipment_priority_flag,wdd.shipment_priority_code) CF_shipment_priority, WSH_WSHRDPIK_XMLP_PKG.cf_subinventoryformula(wpgr.subinventory_flag,decode (msik.reservable_type,2,wdd.subinventory,wpsv.subinventory_code)) CF_subinventory, WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id) CF_delivery_id, WSH_WSHRDPIK_XMLP_PKG.cf_deliveryformula(wpgr.delivery_flag,wnd.name) CF_delivery, WSH_WSHRDPIK_XMLP_PKG.cf_trip_stop_address1formula(wpgr.trip_stop_flag,wpgr.delivery_flag,WSH_WSHRDPIK_XMLP_PKG.cf_delivery_idformula(wpgr.delivery_flag,wnd.delivery_id),wpsv.pick_slip_number) CF_trip_stop_address, WSH_WSHRDPIK_XMLP_PKG.cf_order_numberformula(wpgr.order_number_flag,wdd.source_header_number) CF_order_number, WSH_WSHRDPIK_XMLP_PKG.cf_customer_nameformula(wpgr.customer_flag,wdd.source_header_id) CF_customer_name, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_code_p CP_warehouse_code, WSH_WSHRDPIK_XMLP_PKG.CP_warehouse_name_p CP_warehouse_name, WSH_WSHRDPIK_XMLP_PKG.st_addr1_p st_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr3_p ts_addr3, WSH_WSHRDPIK_XMLP_PKG.ts_addr4_p ts_addr4, WSH_WSHRDPIK_XMLP_PKG.ts_addr5_p ts_addr5, WSH_WSHRDPIK_XMLP_PKG.ts_addr1_p ts_addr1, WSH_WSHRDPIK_XMLP_PKG.ts_addr2_p ts_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr4_p st_addr4, WSH_WSHRDPIK_XMLP_PKG.st_addr5_p st_addr5, WSH_WSHRDPIK_XMLP_PKG.st_addr2_p st_addr2, WSH_WSHRDPIK_XMLP_PKG.st_addr3_p st_addr3, WSH_WSHRDPIK_XMLP_PKG.f_to_locationformula(wpsv.to_locator_id,wdd.organization_id) F_TO_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_customerformula(wpgr.customer_flag,wdd.source_header_id) CF_customer, WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id) CF_trip_id, WSH_WSHRDPIK_XMLP_PKG.f_item_descriptionformula(msitl.description,wdd.inventory_item_id,wdd.organization_id,msitl.description) F_ITEM_DESCRIPTION, WSH_WSHRDPIK_XMLP_PKG.f_requested_quantityformula(wdd.source_header_id,wdd.source_line_id,wpsv.move_order_line_id) F_REQUESTED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.f_shipped_quantityformula() F_SHIPPED_QUANTITY, WSH_WSHRDPIK_XMLP_PKG.cf_trip_chrformula(WSH_WSHRDPIK_XMLP_PKG.cf_trip_idformula(wnd.delivery_id,wnd.initial_pickup_location_id)) CF_TRIP_CHR, WSH_WSHRDPIK_XMLP_PKG.CP_trip_name_p CP_trip_name, WSH_WSHRDPIK_XMLP_PKG.f_from_locationformula(decode (msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id),wdd.organization_id) F_FROM_LOCATION, WSH_WSHRDPIK_XMLP_PKG.cf_freight_terms_nameformula(wdd.freight_terms_code,wdd.source_code) CF_FREIGHT_TERMS_NAME, WSH_WSHRDPIK_XMLP_PKG.cf_revisionformula(nvl (wpsv.transaction_id,-99)) CF_REVISION, WSH_WSHRDPIK_XMLP_PKG.B_task_idFt(wdd.organization_id) B_task_idFt FROM ( SELECT mtrl.from_subinventory_code subinventory_code, mtrl.from_locator_id, mtrl.to_subinventory_code to_subinventory, mtrl.to_locator_id, abs(mtrl.primary_quantity) primary_quantity, mtrl.pick_slip_number, mtrl.pick_slip_date detailing_date, mtrl.line_id move_order_line_id, 'PICKED' line_status, to_number(null) transaction_id, mtrl.uom_code, mtrl.secondary_quantity, mtrl.secondary_uom_code, mtrl.header_id, mtrl.line_id, mtrl.line_number FROM mtl_txn_request_lines mtrl WHERE mtrl.pick_slip_number is not null &LP_PICK_STATUS &LP_WAREHOUSE_CLAUSE &LP_DETAIL_DATE_MTRL &LP_PICK_SLIP_NUM_MTRL ) wpsv, wsh_delivery_details wdd, mtl_txn_request_headers mtrh, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, oe_order_lines_all oola, oe_sets os, wsh_pick_grouping_rules wpgr, mtl_system_items_b_kfv msik, mtl_system_items_tl msitl WHERE msik.inventory_item_id=msitl.inventory_item_id AND msik.organization_id=msitl.organization_id AND msitl.LANGUAGE=userenv('LANG') AND wpsv.header_id=mtrh.header_id AND wpsv.move_order_line_id=wdd.move_order_line_id AND nvl(wpsv.transaction_id,-99)=decode(nvl(wdd.transaction_id,-99),-99,nvl(wpsv.transaction_id,-99),wdd.transaction_id) AND wdd.inventory_item_id=msik.inventory_item_id(+) AND wdd.organization_id=msik.organization_id(+) AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+) AND (wnd.delivery_type is null or wnd.delivery_type='STANDARD') AND wdd.source_line_id=oola.line_id AND wdd.source_header_id=oola.header_id AND wdd.source_code='OE' AND wdd.released_status!='S' AND wdd.container_flag IN ('N','Y') AND wdd.ship_set_id=os.set_id(+) AND mtrh.grouping_rule_id=wpgr.pick_grouping_rule_id(+) &LP_MO_CLAUSE &LP_ORDER_NUM &LP_ORDER_TYPE &LP_CUSTOMER_ID &lp_ship_method_code &LP_PRINTER_NAME ORDER BY 1 ASC,50 ASC,47 ASC,12 ASC,42 ASC,38 ASC,39 ASC,40 ASC,41 ASC,45 ASC,46 ASC,18 ASC,20 ASC,4 ASC,2 ASC,5 ASC,8 ASC,9 ASC,13 ASC,10 ASC,14 ASC,17 ASC,24 ASC,25 ASC,26 ASC,27 ASC,28 ASC,29 ASC,31 ASC,33 ASC,19 ASC,22 ASC,32 ASC,30 ASC,34 ASC,37 ASC,48 ASC,43 ASC,23 ASC,44 ASC,49 ASC,21 ASC,3 ASC WSH WSHRDPIK_XML AR WSH تقرير بطاقة الانتقاء (بتنسيق XML) Imported from BI Publisher Description: تقرير بطاقة الانتقاء Application: تنفيذ الشحن Source: تقرير بطاقة الانتقاء (بتنسيق XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG D WSH Entnahmeschein Imported from BI Publisher Description: Entnahmeschein Application: Shipping Execution Source: Entnahmeschein (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG E WSH Informe Notas de Acopio Imported from BI Publisher Description: Informe de notas de acopio Application: Shipping Execution Source: Informe Notas de Acopio (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG F WSH Etat des bordereaux de prélèvement Imported from BI Publisher Description: Etat des bordereaux de prélèvement Application: Shipping Execution Source: Etat des bordereaux de prélèvement (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG I WSH Rapporto Distinta di prelievo Imported from BI Publisher Description: Rapporto distinta di prelievo Application: Shipping Execution Source: Rapporto Distinta di prelievo (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG JA WSH ピック・スリップ・レポート Imported from BI Publisher Description: ピック・スリップ・レポート Application: Shipping Execution Source: ピック・スリップ・レポート(XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG KO WSH 피킹 지시 보고서 Imported from BI Publisher Description: 출하지시 보고서 Application: Shipping Execution Source: 피킹 지시 보고서(XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG PTB WSH Relatório da Lista de Separação Imported from BI Publisher Description: Relatório do Slip de Separação Application: Execução da Entrega Source: Relatório da Lista de Separação (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG RU WSH Отчет о товарных накладных Imported from BI Publisher Description: Отчет о товарных накладных Application: Выполнение отгрузки Source: Отчет о товарных накладных (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG S WSH Plocksedelsrapport Imported from BI Publisher Description: Plocksedelsrapport Application: Shipping Execution Source: Plocksedelsrapport (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG TR WSH Toplama Fişi Raporu Imported from BI Publisher Description: Toplama Fişi Raporu Application: Sevkiyat Yönetimi Source: Toplama Fişi Raporu (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG US WSH Pick Slip Imported from BI Publisher Description: Pick Slip Report Application: Shipping Execution Source: Pick Slip Report (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG ZHS WSH 挑库单报表 Imported from BI Publisher Description: 挑库单报表 Application: 发运管理系统 Source: 挑库单报表 (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG BI Publisher &lp_customer_id &lp_detail_date_mmt &lp_detail_date_mtrl &lp_detail_date_unpick &lp_item_display_value &lp_mo_clause &lp_order_num &lp_order_type &lp_pick_slip_num &lp_pick_slip_num_mmt &lp_pick_slip_num_mtrl &lp_pick_status &lp_pick_status_unpick &lp_printer_name &lp_ship_method_code &lp_warehouse_clause :cp_cache_delivery_id :cp_cache_trip_id :cp_cache_trip_name :cp_trip_name :cp_warehouse_code :cp_warehouse_name :lp_customer_id :lp_detail_date_high :lp_detail_date_mmt :lp_detail_date_mtrl :lp_detail_date_unpick :lp_item_display_value :lp_mo_clause :lp_no :lp_order_num :lp_order_type :lp_pick_slip_num :lp_pick_slip_num_mmt :lp_pick_slip_num_mtrl :lp_pick_status :lp_pick_status_unpick :lp_printer_name :lp_ship_method_code :lp_structure_num :lp_warehouse_clause :lp_warehouse_code :lp_warehouse_name :lp_yes :p_application_id :p_conc_request_id :p_concurrent_program_name :p_customer_id :p_detail_date_high :p_detail_date_low :p_enabled_flag :p_entity_headers :p_entity_lines :p_freight_code :p_function_name :p_header_id_high :p_header_id_low :p_item_display :p_item_flex_code :p_level_type_id1 :p_level_type_id2 :p_locator_flex_code :p_move_order_high :p_move_order_low :p_order_num_high :p_order_num_low :p_order_type_id :p_organization_id :p_pick_slip_num_high :p_pick_slip_num_low :p_pick_status :p_pick_status_value :p_printer_name :st_addr1 :st_addr2 :st_addr3 :st_addr4 :st_addr5 :ts_addr1 :ts_addr2 :ts_addr3 :ts_addr4 :ts_addr5 1 -30 :p_item_flex_code Char MSTK Y AR الرمز المرن للصنف الرمز المرن للصنف D Artikel-FlexFeld-Schlüssel Artikel-FlexFeld-Schlüssel E Código de Estructura de Artículo Código de Estructura de Artículo F Code clé article Code clé article I Codice flexfield Articolo Codice flexfield Articolo JA 品目フレックス・コード 品目フレックス・コード KO 품목 가변 코드 품목 가변 코드 PTB Código Flex. do Item Código Flex. do Item RU Код ГП позиции Код ГП позиции S Artikelflexkod Artikelflexkod TR Kalem Esnek Kodu Kalem Esnek Kodu US Item Flex Code Item Flex Code ZHS 项目弹性域代码 项目弹性域代码 2 -20 :p_locator_flex_code Char MTLL Y AR الرمز المرن لمحدد الموقع الرمز المرن لمحدد الموقع D Lagerplatz-FlexFeld-Schlüssel Lagerplatz-FlexFeld-Schlüssel E Código de Estructura de Ubicación Código de Estructura de Ubicación F Code clé emplacement Code clé emplacement I Codice flexfield Collocazione Codice flexfield Collocazione JA 保管棚フレックス・コード 保管棚フレックス・コード KO 보관처 가변 코드 보관처 가변 코드 PTB Código Flex. do Endereço Código Flex. do Endereço RU Код ГП складского места Код ГП складского места S Flexkod för lagerplats Flexkod för lagerplats TR Stok Adresi Esnekalan Kodu Stok Adresi Esnekalan Kodu US Locator Flex Code Locator Flex Code ZHS 货位弹性域代码 货位弹性域代码 3 10 :p_pick_slip_num_low LOV Oracle WSH_SRS_PICK_SLIP_NUMBER Y select pick_slip_number id, pick_slip_number value, null description from wsh_srs_pick_slip_v order by pick_slip_number AR رقم بطاقة الانتقاء (من) رقم بطاقة الانتقاء (من) D Von Entnahmeschein-Nr. Von Entnahmeschein-Nr. E De Número de Nota de Acopio De Número de Nota de Acopio F Numéro de bordereau prélèvement - De Numéro de bordereau prélèvement - De I Numero distinta di prelievo (minimo) Numero distinta di prelievo (minimo) JA ピック・スリップ番号 (自) ピック・スリップ番号 (自) KO 출하지시서 번호(하한) 출하지시서 번호(하한) PTB Número do Slip de Separação (Inferior) Número do Slip de Separação (Inferior) RU Номер товарной накладной с Номер товарной накладной с S Plocksedelnummer (från) Plocksedelnummer (från) TR Toplama Fişi Numarası (Alt Değer) Toplama Fişi Numarası (Alt Değer) US Pick Slip Number (Low) Pick Slip Number (Low) ZHS 挑库单编号（下限） 挑库单编号（下限） 4 20 :p_pick_slip_num_high LOV Oracle WSH_SRS_PICK_SLIP_NUMBER Y select pick_slip_number id, pick_slip_number value, null description from wsh_srs_pick_slip_v order by pick_slip_number select :$flex$.pick_slip_number_low from dual AR رقم بطاقة الانتقاء (إلى) رقم بطاقة الانتقاء (إلى) D Bis Entnahmeschein-Nr. Bis Entnahmeschein-Nr. E A Número de Nota de Acopio A Número de Nota de Acopio F Numéro de bordereau prélèvement - A Numéro de bordereau prélèvement - A I Numero distinta di prelievo (massimo) Numero distinta di prelievo (massimo) JA ピック・スリップ番号 (至) ピック・スリップ番号 (至) KO 출하지시서 번호(상한) 출하지시서 번호(상한) PTB Número do Slip de Separação (Superior) Número do Slip de Separação (Superior) RU Номер товарной накладной по Номер товарной накладной по S Plocksedelnummer (till) Plocksedelnummer (till) TR Toplama Fişi Numarası (Üst Değer) Toplama Fişi Numarası (Üst Değer) US Pick Slip Number (High) Pick Slip Number (High) ZHS 挑库单编号（上限） 挑库单编号（上限） 5 30 :p_order_type_id LOV Oracle WSH_SRS_ORDER_TYPE Y select order_type_id id, order_type_name value, null description from wsh_order_types_regular_v order by order_type_name AR نوع أمر المبيعات نوع أمر المبيعات D Kundenauftragsart Kundenauftragsart E Tipo de Pedido de Venta Tipo de Pedido de Venta F Type de commande client Type de commande client I Tipo ordine di vendita Tipo ordine di vendita JA 受注タイプ 受注タイプ KO 판매 주문 유형 판매 주문 유형 PTB Tipo de Ordem de Venda Tipo de Ordem de Venda RU Тип заказа на продажу Тип заказа на продажу S Kundordertyp Kundordertyp TR Satış Siparişi Tipi Satış Siparişi Tipi US Sales Order Type Sales Order Type ZHS 销售订单类型 销售订单类型 6 40 :p_order_num_low LOV Oracle WSH_SRS_ORDER_NUMBERS Y select order_number id, order_number value, null description from oe_order_headers_all where order_type_id=:$flex$.wsh_srs_order_type order by order_number AR رقم أمر المبيعات (من) رقم أمر المبيعات (من) D Von Kundenauftragsnummer Von Kundenauftragsnummer E De Número de Pedido de Venta De Número de Pedido de Venta F Numéro de commande client (De) Numéro de commande client (De) I Numero ordine di vendita (minimo) Numero ordine di vendita (minimo) JA 受注番号 (自) 受注番号 (自) KO 판매 주문 번호 (하한) 판매 주문 번호 (하한) PTB Número da Ordem de Venda (Inferior) Número da Ordem de Venda (Inferior) RU Номер заказа на продажу с Номер заказа на продажу с S Från kundordernummer Från kundordernummer TR Satış Siparişi Numarası (Alt Değer) Satış Siparişi Numarası (Alt Değer) US Sales Order Number (Low) Sales Order Number (Low) ZHS 销售订单编号（下限） 销售订单编号（下限） 7 50 :p_order_num_high LOV Oracle WSH_SRS_ORDER_NUMBERS Y select order_number id, order_number value, null description from oe_order_headers_all where order_type_id=:$flex$.wsh_srs_order_type order by order_number AR رقم أمر المبيعات (إلى) رقم أمر المبيعات (إلى) D Bis Kundenauftragsnummer Bis Kundenauftragsnummer E A Número de Pedido de Venta A Número de Pedido de Venta F Numéro de commande client (A) Numéro de commande client (A) I Numero ordine di vendita (massimo) Numero ordine di vendita (massimo) JA 受注番号 (至) 受注番号 (至) KO 판매 주문 번호 (상한) 판매 주문 번호 (상한) PTB Número da Ordem de Venda (Superior) Número da Ordem de Venda (Superior) RU Номер заказа на продажу по Номер заказа на продажу по S Till kundordernummer Till kundordernummer TR Satış Siparişi Numarası (Üst Değer) Satış Siparişi Numarası (Üst Değer) US Sales Order Number (High) Sales Order Number (High) ZHS 销售订单编号（上限） 销售订单编号（上限） 8 60 :p_move_order_low LOV Oracle WSH_SRS_MOVE_ORDERS Y select request_number id, request_number value, null description from mtl_txn_request_headers order by request_number AR رقم طلب النقل (من) رقم طلب النقل (من) D Von Transferauftrags-Nr. Von Transferauftrags-Nr. E De Número de Orden de Movimiento De Número de Orden de Movimiento F Numéro d'ordre de transfert (De) Numéro d'ordre de transfert (De) I Numero ordine spostamento (minimo) Numero ordine spostamento (minimo) JA 移動オーダー番号 (自) 移動オーダー番号 (自) KO 이동 지시 번호(하한) 이동 지시 번호(하한) PTB Nr. Ordem Movimentação (Inferior) Nr. Ordem Movimentação (Inferior) RU Номер заказа на перемещение с Номер заказа на перемещение с S Från transportordernr Från transportordernr TR Taşıma Emri Numarası (Alt Değer) Taşıma Emri Numarası (Alt Değer) US Move Order Number (Low) Move Order Number (Low) ZHS 物料搬运单编号（下限） 物料搬运单编号（下限） 9 70 :p_move_order_high LOV Oracle WSH_SRS_MOVE_ORDERS Y select request_number id, request_number value, null description from mtl_txn_request_headers order by request_number select :$flex$.move_order_number_low from dual AR رقم طلب النقل (إلى) رقم طلب النقل (إلى) D Bis Transferauftrags-Nr. Bis Transferauftrags-Nr. E A Número de Orden de Movimiento A Número de Orden de Movimiento F Numéro d'ordre de transfert (A) Numéro d'ordre de transfert (A) I Numero ordine spostamento (massimo) Numero ordine spostamento (massimo) JA 移動オーダー番号 (至) 移動オーダー番号 (至) KO 이동 지시 번호(상한) 이동 지시 번호(상한) PTB Nr. Ordem Movimentação (Superior) Nr. Ordem Movimentação (Superior) RU Номер заказа на перемещение по Номер заказа на перемещение по S Till transportordernr Till transportordernr TR Taşıma Emri Numarası (Üst Değer) Taşıma Emri Numarası (Üst Değer) US Move Order Number (High) Move Order Number (High) ZHS 物料搬运单编号（上限） 物料搬运单编号（上限） 10 80 :p_freight_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 Transporteur Transporteur E Transportista Transportista F Transporteur Transporteur I Vettore Vettore JA 運送業者 運送業者 KO 운송 회사 운송 회사 PTB Transportadora Transportadora RU Перевозчик Перевозчик S Speditör Speditör TR Taşımacı Taşımacı US Freight Carrier Freight Carrier ZHS 承运人 承运人 11 90 :p_organization_id LOV Oracle WSH_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code select organization_code from org_organization_definitions where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR المستودع المستودع D Lagerorganisation Lagerorganisation E Almacén Almacén F Entrepôt Entrepôt I Magazzino Magazzino JA 倉庫 倉庫 KO 창고 창고 PTB Depósito Depósito RU Склад Склад S Lager Lager TR Temin Yeri Temin Yeri US Warehouse Warehouse ZHS 仓库 仓库 12 100 :p_customer_id LOV Oracle WSH_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 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 客户 客户 13 110 :p_pick_status LOV Oracle WSH_SRS_LINE_STATUS Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='LINE_STATUS' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'LINE_STATUS' and lookup_code = 'A' Y AR موقف السطر طباعة السطر بالموقف المختار D Positionsstatus Position mit gewähltem Status drucken E Estado de Línea Imprimir Línea con Estado Seleccionado F Statut de ligne Imprimer la ligne avec le statut choisi I Stato linea Stampa la linea associata allo stato selezionato JA 明細ステータス 選択ステータスで明細の印刷 KO 라인 상태 선택된 상태로 라인 인쇄 PTB Status Linha Imprimir Linha com o Status Escolhido RU Статус строки Печать строки с выбранным статусом S Radstatus Skriv ut rad med vald status TR Satır Statüsü Seçilen Statüye Sahip Satırı Yazdırır. US Line Status Print Line with Chosen Status ZHS 行状态 打印具有选定状态的行 14 120 :p_detail_date_low Date AR تاريخ التفصيل (من) تاريخ التفصيل (من) D Von Detaildatum Von Detaildatum E De Fecha de Detalle De Fecha de Detalle F Date de détail (Du) Date de détail (Du) I Data dettaglio (minimo) Data dettaglio (minimo) JA 詳細日 (自) 詳細日 (自) KO 상세 일자 (하한) 상세 일자 (하한) PTB Data do Detalhamento (Inferior) Data do Detalhamento (Inferior) RU Дата детализации с Дата детализации с S Specificeringsdatum (från) Specificeringsdatum (från) TR Detay Oluşturma Tarihi (Alt Değer) Detay Oluşturma Tarihi (Alt Değer) US Detailing Date (Low) Detailing Date (Low) ZHS 详细分析日期（下限） 详细分析日期（下限） 15 130 :p_detail_date_high Date AR تاريخ التفصيل (إلى) تاريخ التفصيل (إلى) D Bis Detaildatum Bis Detaildatum E A Fecha de Detalle A Fecha de Detalle F Date de détail (Au) Date de détail (Au) I Data dettaglio (massimo) Data dettaglio (massimo) JA 詳細日 (至) 詳細日 (至) KO 상세 일자 (상한) 상세 일자 (상한) PTB Data do Detalhamento (Superior) Data do Detalhamento (Superior) RU Дата детализации по Дата детализации по S Specificeringsdatum (till) Specificeringsdatum (till) TR Detay Oluşturma Tarihi (Üst Değer) Detay Oluşturma Tarihi (Üst Değer) US Detailing Date (High) Detailing Date (High) ZHS 详细分析日期（上限） 详细分析日期（上限） 16 140 :p_item_display LOV Oracle WSH_MGD_ITEM_DISPLAY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='ITEM_DISPLAY' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'ITEM_DISPLAY' and lookup_code ='D' Y AR عرض الصنف طباعة الصنف المخزني الوصفي أو المرن D Artikelanzeige Lagerartikel-Beschreibung oder FlexFeld drucken E Presentación del Artículo Imprimir Descripción de Artículo de Inventario o Estructura F Affichage article Imprimer description ou clé d'article stocké I Visualizzazione articolo Stampa la descrizione o il flexfield dell'articolo di magazzino JA 品目表示 在庫品目摘要またはフレックスの印刷 KO 품목 표시 재고 품명 또는 가변 PTB Exibição do Item Imprimir Descrição ou Flex. do Item de Inventário RU Вывод позиции Печать описания или ГП позиции запасов S Artikelvisning Skriv ut beskr. av lagerart. eller flexfält TR Kalem Görüntüleme Envanter Kalemi Tanımlamasını veya Esnekalanını Yazdırır. US Item Display Print Inventory Item Description or Flex ZHS 物料显示 打印库存物料说明或弹性域 17 150 :p_printer_name LOV Oracle WSH_PRINTERS Y select printer_name id, printer_name value, null description from fnd_printer where printer_name in (select printer_name from fnd_printer_tl t where t.language=userenv('LANG')) order by value,description AR اسم الطابعة اسم الطابعة D Druckerbezeichnung Druckerbezeichnung E Nombre de Impresora Nombre de Impresora F Nom de l'imprimante Nom de l'imprimante I Nome stampante Nome stampante JA プリンタ名 プリンタ名 KO 프린터명 프린터명 PTB Nome da Impressora Nome da Impressora RU Имя принтера Имя принтера S Skrivare Skrivare TR Yazıcı Adı Yazıcı Adı US Printer Name Printer Name ZHS 打印机名称 打印机名称