APPS.WMS_ITEM_LOAD dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 710: FROM wms_license_plate_numbers

706:
707: -- Get the sub, loc and context of the source LPN ID
708: SELECT lpn_context, NVL(subinventory_code, '###'), NVL(locator_id, -999)
709: INTO l_lpn_context, l_subinv_code, l_locator_id
710: FROM wms_license_plate_numbers
711: WHERE lpn_id = p_lpn_id
712: AND organization_id = p_organization_id;
713: IF (l_debug = 1) THEN
714: print_debug('Source LPN Context: => ' || l_lpn_context);

Line 723: FROM wms_license_plate_numbers

719:
720: -- Get the sub and loc of the destination LPN ID
721: SELECT NVL(subinventory_code, '###'), NVL(locator_id, -999)
722: INTO l_tosubinv_code, l_tolocator_id
723: FROM wms_license_plate_numbers
724: WHERE organization_id = p_organization_id
725: AND lpn_id = p_into_lpn_id;
726: IF (l_debug = 1) THEN
727: print_debug('Into LPN Sub: =======> ' || l_tosubinv_code);

Line 3009: UPDATE wms_license_plate_numbers

3005: IF (l_debug = 1) THEN
3006: print_debug('Update the LPN context for Into LPN');
3007: END IF;
3008: BEGIN
3009: UPDATE wms_license_plate_numbers
3010: SET lpn_context = 2
3011: WHERE lpn_id = p_into_lpn_id
3012: AND organization_id = p_organization_id;
3013: EXCEPTION

Line 3059: FROM wms_license_plate_numbers

3055: SELECT subinventory_code
3056: , locator_id
3057: INTO l_into_sub
3058: , l_into_loc
3059: FROM wms_license_plate_numbers
3060: WHERE lpn_id = p_into_lpn_id;
3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: NULL;