APPS.WMS_CROSS_DOCK_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 867: FROM wms_license_plate_numbers

863: END IF;
864: --get l_lpn_context
865: SELECT lpn_context
866: INTO l_lpn_context
867: FROM wms_license_plate_numbers
868: WHERE lpn_id = l_lpn_id;
869:
870: IF (l_debug = 1) THEN
871: mydebug('LPN Context: ' || l_lpn_context);

Line 1567: FROM wms_license_plate_numbers

1563: CURSOR parent_lpn_cur ( p_innermost_lpn_id NUMBER ) IS
1564: SELECT lpn_id, license_plate_number, parent_lpn_id, organization_id, subinventory_code, locator_id,
1565: tare_weight, tare_weight_uom_code, gross_weight, gross_weight_uom_code,
1566: container_volume, container_volume_uom, content_volume, content_volume_uom_code
1567: FROM wms_license_plate_numbers
1568: START WITH lpn_id = p_innermost_lpn_id
1569: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1570:
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);