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_LPN_RESERVATIONS_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 842: FROM wms_license_plate_numbers

838: FROM mtl_reservations
839: WHERE organization_id = v_organization_id
840: AND (v_inventory_item_id IS NULL OR inventory_item_id = v_inventory_item_id)
841: AND lpn_id IN (SELECT lpn_id
842: FROM wms_license_plate_numbers
843: WHERE outermost_lpn_id = v_lpn_id OR lpn_id = v_lpn_id)
844: AND demand_source_type_id not in decode(p_system_task_type,3,-1,9);
845:
846: CURSOR serials_lpn(v_reservation_id NUMBER) IS

Line 1074: FROM wms_license_plate_numbers

1070: FROM mtl_reservations
1071: WHERE organization_id = v_organization_id
1072: AND (v_inventory_item_id IS NULL OR inventory_item_id = v_inventory_item_id)
1073: AND lpn_id IN (SELECT lpn_id
1074: FROM wms_license_plate_numbers
1075: WHERE outermost_lpn_id = v_lpn_id OR lpn_id = v_lpn_id)
1076: AND (v_check_dsld_flag='FALSE' OR demand_source_line_detail IS NULL)
1077: AND demand_source_type_id not in decode(p_system_task_type,3,-1,9);
1078: