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

Line 941: FROM wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2

937: SELECT wlpn1.license_plate_number
938: , wlpn2.license_plate_number
939: INTO l_allocated_lpn_name
940: , l_allocated_outermost_lpn_name
941: FROM wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2
942: WHERE wlpn1.lpn_id = l_allocated_lpn_id
943: AND wlpn1.outermost_lpn_id = wlpn2.lpn_id;
944: END IF;
945:

Line 956: FROM wms_license_plate_numbers

952: -- Bug : 6682436 Start
953: -- To handle the case for pick slip cartonization
954: SELECT license_plate_number
955: INTO l_carton_name
956: FROM wms_license_plate_numbers
957: WHERE lpn_id = l_cartonization_id;
958:
959: BEGIN
960: SELECT l.license_plate_number lpn

Line 966: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */

962: , k.concatenated_segments item
963: INTO l_carton_name
964: , l_carton_item_id
965: , l_carton_item_name
966: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */
967: WHERE l.lpn_id = l_cartonization_id
968: AND l.inventory_item_id = k.inventory_item_id
969: AND l.organization_id = k.organization_id;
970: