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.INV_MWB_QUERY_MANAGER dependencies on WMS_LOADED_QUANTITIES_V

Line 2138: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn

2134: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2135: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2136: select nvl(sum(wlqv.quantity),0)
2137: into packed_loaded_qty
2138: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn
2139: where wlqv.inventory_item_id = rec.item_id
2140: and wlqv.organization_id = rec.org_id
2141: and wlqv.containerized_flag = 1
2142: and (rec.subinventory_code is null or wlqv.subinventory_code = rec.subinventory_code)

Line 2158: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn

2154: and wlpn.license_plate_number <= nvl(inv_mwb_globals.g_lpn_to,wlpn.license_plate_number);
2155:
2156: select nvl(sum(wlqv.quantity),0)
2157: into unpacked_loaded_qty
2158: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn
2159: where wlqv.inventory_item_id = rec.item_id
2160: and wlqv.organization_id = rec.org_id
2161: and wlqv.containerized_flag = 2
2162: and (rec.subinventory_code is null or wlqv.subinventory_code = rec.subinventory_code)

Line 2179: from WMS_LOADED_QUANTITIES_V

2175:
2176: ELSE
2177: select nvl(sum(quantity),0)
2178: into packed_loaded_qty
2179: from WMS_LOADED_QUANTITIES_V
2180: where inventory_item_id = rec.item_id
2181: and organization_id = rec.org_id
2182: and containerized_flag = 1
2183: and (rec.subinventory_code is null or subinventory_code = rec.subinventory_code)

Line 2196: from WMS_LOADED_QUANTITIES_V

2192: and (rec.lpn_id is null or nvl(content_lpn_id,lpn_id) = rec.lpn_id);--bug13478665,content_lpn not lpn populated for the partial lpn picked
2193:
2194: select nvl(sum(quantity),0)
2195: into unpacked_loaded_qty
2196: from WMS_LOADED_QUANTITIES_V
2197: where inventory_item_id = rec.item_id
2198: and organization_id = rec.org_id
2199: and containerized_flag = 2
2200: and (rec.subinventory_code is null or subinventory_code = rec.subinventory_code)

Line 2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

2216: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'serial '||rec.serial);
2217:
2218: select 1 into l_serial_loaded
2219: from dual
2220: where exists (select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2221: where wlqv.transaction_temp_id IS NOT NULL
2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number

Line 2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt

2222: and wlqv.transaction_temp_id = msnt.transaction_temp_id
2223: and wlqv.inventory_item_id = rec.item_id
2224: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number
2225: union
2226: select 1 from WMS_LOADED_QUANTITIES_V wlqv, mtl_serial_numbers_temp msnt
2227: where wlqv.serial_transaction_temp_id IS NOT NULL
2228: and wlqv.serial_transaction_temp_id = msnt.transaction_temp_id
2229: and wlqv.inventory_item_id = rec.item_id
2230: and rec.serial between msnt.fm_serial_number and msnt.to_serial_number);