eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_SHIPPING_LOVS dependencies on WMS_PICKING_PKG

Line 185: AND oeh.order_number NOT IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.list_order_numbers) )

181: WHERE mmtt.organization_id = p_organization_id
182: AND oeh.order_number LIKE (p_order_number)
183: AND mmtt.transaction_source_id = mso.sales_order_id
184: AND mso.segment1 = oeh.order_number
185: AND oeh.order_number NOT IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.list_order_numbers) )
186: AND v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
187: AND mmtt.standard_operation_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
188: AND mmtt.subinventory_code = NVL(p_zone, mmtt.subinventory_code)
189: AND NVL(v.eqp_id, -999) = NVL(p_equipment_id, NVL(v.eqp_id, -999))

Line 249: AND mmtt.pick_slip_number NOT IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.list_pick_slip_numbers) )

245: AND mmtt.subinventory_code = sub.secondary_inventory_name
246: AND mmtt.organization_id = sub.organization_id
247: AND mmtt.parent_line_id IS NULL -- Added for bulk task
248: AND mmtt.pick_slip_number LIKE (p_pick_slip_number)
249: AND mmtt.pick_slip_number NOT IN ( SELECT * FROM TABLE(WMS_PICKING_PKG.list_pick_slip_numbers) )
250: AND (mmtt.wms_task_status <> 8 OR mmtt.wms_task_status IS NULL )
251: AND mmtt.transaction_action_id = 28
252: AND mmtt.transaction_source_type_id IN (2,8)
253: AND NOT EXISTS ( SELECT 1