ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472BD51A9E05362FB09050512 SELECT DISTINCT wpsv.pick_slip_number pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.from_subinventory) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id) from_locator_id, wpsv.to_subinventory to_subinventory, wpsv.to_locator_id to_locator_id, nvl(wpsv.transaction_id ,-99) transaction_id, nvl(wpsv.transaction_id, -99) rev_txn_id, wpsv.move_order_line_id move_order_line_id10, wpsv.detailing_date detailing_date, wpsv.line_status line_status, wpsv.primary_qty, mtrh.request_number mo_number, mtrl.line_id mo_line_id, mtrl.line_number mo_line_number, -99 delivery_detail_id, -99 ser_dd_id, wdd.source_header_number source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char, wdd.source_header_id source_header_id10, wdd.source_line_id source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions shipping_instructions, wdd.ship_tolerance_above ship_tolerance_above, wdd.ship_tolerance_below ship_tolerance_below, wdd.inventory_item_id inventory_item_id, wdd.requested_quantity_uom requested_quantity_uom, wnd.delivery_id delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id 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 set_name , wpgr.customer_flag customer_flag, wpgr.order_number_flag order_number_flag, wpgr.subinventory_flag subinventory_flag, wpgr.customer_flag customer_flag1, wpgr.ship_to_flag ship_to_flag, wpgr.carrier_flag carrier_flag, wpgr.shipment_priority_flag shipment_priority_flag, wpgr.trip_stop_flag trip_stop_flag, wpgr.delivery_flag delivery_flag, wpgr.name name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id 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.from_subinventory )) 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.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.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, 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.CP_trip_name_p CP_trip_name FROM wsh_pick_slip_v 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.line_status = 'UNPICKED' 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_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 &LP_PICK_STATUS &LP_PRINTER_NAME UNION ALL SELECT DISTINCT wpsv.pick_slip_number pick_slip_number, decode(msik.reservable_type,2,wdd.subinventory,wpsv.from_subinventory) from_subinventory, decode(msik.reservable_type,2,wdd.locator_id,wpsv.from_locator_id) from_locator_id, wpsv.to_subinventory to_subinventory, wpsv.to_locator_id to_locator_id, nvl(wpsv.transaction_id ,-99) transaction_id, nvl(wdd.transaction_id, -99) rev_txn_id, wpsv.move_order_line_id move_order_line_id10, wpsv.detailing_date detailing_date, wpsv.line_status line_status, wdd.requested_quantity primary_qty, mtrh.request_number mo_number, mtrl.line_id mo_line_id, mtrl.line_number mo_line_number, wdd.delivery_detail_id, wdd.delivery_detail_id ser_dd_id, wdd.source_header_number source_header_number, to_char(wdd.source_header_id) order_n_header_char, to_char(wdd.source_line_id) order_n_line_char, wdd.source_header_id source_header_id, wdd.source_line_id source_line_id, to_char(wdd.source_header_id) source_header_chr, to_char(wdd.source_line_id) source_line_chr, wdd.shipping_instructions shipping_instructions, wdd.ship_tolerance_above ship_tolerance_above, wdd.ship_tolerance_below ship_tolerance_below, wdd.inventory_item_id inventory_item_id, wdd.requested_quantity_uom requested_quantity_uom, wnd.delivery_id delivery_id, to_char(wnd.delivery_id) delivery_chr, wnd.name delivery_name, wnd.initial_pickup_location_id 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 set_name, wpgr.customer_flag customer_flag, wpgr.order_number_flag order_number_flag, wpgr.subinventory_flag subinventory_flag, wpgr.customer_flag customer_flag1, wpgr.ship_to_flag ship_to_flag, wpgr.carrier_flag, wpgr.shipment_priority_flag shipment_priority_flag, wpgr.trip_stop_flag trip_stop_flag, wpgr.delivery_flag delivery_flag, wpgr.name name, wdd.ship_method_code carrier, wdd.shipment_priority_code priority, wdd.organization_id 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.from_subinventory )) 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.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.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, 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.CP_trip_name_p CP_trip_name FROM wsh_pick_slip_v 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.line_status = 'PICKED' 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 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_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 &LP_PICK_STATUS &LP_PRINTER_NAME order by pick_slip_number, order_n_header_char, organization_id, name, MO_NUMBER, ship_to_flag, customer_flag, order_number_flag, subinventory_flag, customer_flag1, trip_stop_flag, delivery_flag, source_header_id10, to_subinventory, from_subinventory, to_locator_id, move_order_line_id10, DETAILING_DATE, mo_line_id, line_status, mo_line_number, source_header_number, shipping_instructions, ship_tolerance_above, ship_tolerance_below, inventory_item_id, requested_quantity_uom, delivery_id, DELIVERY_NAME, SALES_LINE_NUMBER, order_n_line_char, order_n_header_char, initial_pickup_location_id, delivery_chr, item_description, set_name, carrier, carrier_flag, order_n_line_char, shipment_priority_flag, PRIORITY, source_line_id, from_locator_id, item_info, source_code Y WSH WSHRDPIKX_XML US WSH Pick Slip Report PDF Output Imported from BI Publisher Description: Pick Slip Report PDF Output Application: Shipping Execution Source: Pick Slip Report PDF Output (XML) Short Name: WSHRDPIKX_XML DB package: WSH_WSHRDPIK_XMLP_PKG BI Publisher &lp_customer_id &lp_detail_date &lp_item_display_value &lp_mo_clause &lp_order_num &lp_order_type &lp_pick_slip_num &lp_pick_status &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 US Item Flex Code Item Flex Code 2 -20 :p_locator_flex_code Char MTLL Y US Locator Flex Code Locator Flex Code 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 US Pick Slip Number (Low) Pick Slip Number (Low) 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 US Pick Slip Number (High) Pick Slip Number (High) 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 US Sales Order Type Sales Order Type 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 US Sales Order Number (Low) Sales Order Number (Low) 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 US Sales Order Number (High) Sales Order Number (High) 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 US Move Order Number (Low) Move Order Number (Low) 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 US Move Order Number (High) Move Order Number (High) 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 US Freight Carrier Freight Carrier 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') US Warehouse Warehouse 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 US Customer Customer 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 US Line Status Print Line with Chosen Status 14 120 :p_detail_date_low Date US Detailing Date (Low) Detailing Date (Low) 15 130 :p_detail_date_high Date US Detailing Date (High) Detailing Date (High) 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 US Item Display Print Inventory Item Description or Flex 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 US Printer Name Printer Name