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 776: FROM wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2

772: SELECT wlpn1.license_plate_number
773: , wlpn2.license_plate_number
774: INTO l_allocated_lpn_name
775: , l_allocated_outermost_lpn_name
776: FROM wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2
777: WHERE wlpn1.lpn_id = l_allocated_lpn_id
778: AND wlpn1.outermost_lpn_id = wlpn2.lpn_id;
779: END IF;
780:

Line 791: FROM wms_license_plate_numbers

787: -- Bug : 6682436 Start
788: -- To handle the case for pick slip cartonization
789: SELECT license_plate_number
790: INTO l_carton_name
791: FROM wms_license_plate_numbers
792: WHERE lpn_id = l_cartonization_id;
793:
794: BEGIN
795: SELECT l.license_plate_number lpn

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

797: , k.concatenated_segments item
798: INTO l_carton_name
799: , l_carton_item_id
800: , l_carton_item_name
801: FROM wms_license_plate_numbers l, mtl_system_items_vl k /* Bug 5581528 */
802: WHERE l.lpn_id = l_cartonization_id
803: AND l.inventory_item_id = k.inventory_item_id
804: AND l.organization_id = k.organization_id;
805: