APPS.MTL_CCEOI_ACTION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1199: FROM WMS_LICENSE_PLATE_NUMBERS

1195:
1196: -- Check for LPN subinventory discrepancy
1197: SELECT subinventory_code, locator_id
1198: INTO l_sub, l_loc_id
1199: FROM WMS_LICENSE_PLATE_NUMBERS
1200: WHERE lpn_id = l_lpn.lpn_id
1201: AND organization_id = p_interface_rec.organization_id;
1202:
1203: IF p_interface_rec.subinventory <> l_sub OR p_interface_rec.locator_id <> l_loc_id THEN